Financial Management - PSFT (MOSC)

MOSC Banner

ITEM PRICELIST LOAD : Blank data in staging tables.

edited Mar 6, 2023 3:28PM in Financial Management - PSFT (MOSC) 4 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center