Page 1 of 1

Data not flowing from interface to base table PO

Posted: Fri Mar 13, 2009 6:04 am
by warne
Hello All ,

I am trying to work on PO conversions.I have successfully loaded the data into PO_HEADERS_INTERFACE table and then I am trying to run IMPORT STANDARD PURCHASE ORDER concurrent program.I have chosen update "YES" and Status as "INCOMPLETE" as parameters when I run this concurrent program.

I am trying to open the output file but it says the output file is 0 bytes.

I am not able to find the data in base table PO_HEADERS_ALL.

I know its a bit vague in here, but any suggestions will be appreciated.

Thanks
Warne

Posted: Sun Mar 15, 2009 12:56 am
by warne
Atleast can anyone please tell me where can I find error table for PO.

I am not able to find the concurrent program entry in po_interface_errors table so that I can debug as to which columns data are wrongly assigned.

Request fro advice.

Thanks
Warne

Posted: Sun Mar 15, 2009 1:23 am
by admin
po_headers_interface
po_lines_interface

Posted: Sun Mar 15, 2009 1:30 am
by warne
Thanks Admin ,

I have the data in Interface Tables.

Can you please suggest me some validations as to why data is not flowing to BASE TABLES or any idea would be helpful.

Thanks
Warne

Posted: Tue Mar 17, 2009 4:49 pm
by warne
Finally PO conversion working perfectly.

Thanks