My Oracle Support Banner

The User Followed the Steps Given in Doc ID 1502838.1 but the Data was not Inserted into the Staging Records (Doc ID 2934895.1)

Last updated on MARCH 13, 2023

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 and later
Information in this document applies to any platform.


The user followed the steps given in Doc ID 1502838.1 but the data was not inserted into the staging records.

The issue can be reproduced at will with the following steps:
      1. Follow the steps given in Doc ID 1502838.1
      2. Navigate : Enterprise Component > Integration Definition > Inbound File Rule
            File Identifier: ITEM_PRICELIST_LOAD_IN_FILE
            Inbound File: Enter csv file path (Place the file in the shared folder)
            Definition Name : ITEM_PRICELIST_LOAD
      3. People Tools > Integration Broker > Integration Setup > Service Operation > ITEM_PRICELIST_LOAD
            Activate the operation, Handler, Routing and Run the Queue
      4. Navigate : Enterprise Component> Integration Definition> Initiate Process>Inbound File Publish
            Create Run Control
            Select File Identifier ITEM_PRICELIST_LOAD_IN_FILE
            Run EOP_PUBLISHF
      5. Check the data
                  SELECT * FROM PS_ITM_LOAD_INV_EC;
                  No data

                  SELECT * FROM PS_ITM_LOAD_MST_EC;
                  No data

                  SELECT * FROM PS_ITM_LOAD_PUR_EC;
                  No data

                  SELECT * FROM PS_ITM_LOAD_VND_EC;
                  No data


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.