Skip to Main Content
Return to Navigation

Testing Inbound Flat File Processing

To test inbound files:

  1. Create a sample flat file, or ask the third-party vendor for a sample flat file.

  2. Set up processing rules for the test.

    Select select PeopleTools, then select Integration Broker, then select File Utilities, then select Inbound File Loader Rules to access the Inbound File Loader Rules page.

    See Setting Up Inbound File Loader Processing Rules.

  3. Initiate file processing.

    Select select PeopleTools, then select Integration Broker, then select File Utilities, then select Inbound File Processing to access the Inbound File Processing page.

    See Initiating Inbound Flat File Processing.

  4. Verify the inbound processing created a message that contains the sample flat file data.

    1. If you used application class processing, verify if the production or staging tables are loaded with the correct field values. For production tables, look in the PeopleSoft application pages. For staging tables, use either the PeopleSoft application pages or run a query by using PeopleSoft Query.

    2. If you used PeopleSoft Integration Broker for file processing, use the Service Operations Monitor to ensure the inbound file processing created a service operation that contains the sample flat file data.

      Verify that the standard inbound notification process received the message and processed it into the application tables.

      Determine whether the values become the inherited values (if you used the inherited value feature in file layout).

      Validate that the production or staging tables loaded with the correct field values. For production tables, look in the PeopleSoft application pages. For staging tables, use either the PeopleSoft application pages or run a query by using PeopleSoft Query.

      Ensure that the date formats conform.