ITEM PRICELIST LOAD : Blank data in staging tables.
Hi Team,
I am working on PS delivered functionality to update Supplier Item price. I am using .csv as input file to get the changes in price.
I have followed ORACLE document. (Doc ID 1502838.1)
I am able to create XML file from CSV inbound file, and the message through IB service operation ITEM_PRICELIST_LOAD is in done status and rows are inserted in staging tables.
SELECT * FROM PS_ITM_LOAD_INV_EC;
SELECT * FROM PS_ITM_LOAD_MST_EC;
SELECT * FROM PS_ITM_LOAD_PUR_EC;
SELECT * FROM PS_ITM_LOAD_VND_EC;
However, the xml file load does not have any data in xml tag pushed through csv file. Also, though the rows are created in staging table, they does not have any information on INV_ITEM_ID or other field sent through CSV inbound file.