Data not flowing from interface to base table PO

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
warne
Posts: 8
Joined: Tue Mar 10, 2009 5:33 am
Location: USA

Data not flowing from interface to base table PO

Post 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
warne
Posts: 8
Joined: Tue Mar 10, 2009 5:33 am
Location: USA

Post 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
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

po_headers_interface
po_lines_interface
warne
Posts: 8
Joined: Tue Mar 10, 2009 5:33 am
Location: USA

Post 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
warne
Posts: 8
Joined: Tue Mar 10, 2009 5:33 am
Location: USA

Post by warne »

Finally PO conversion working perfectly.

Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest