My Oracle Support Banner

Include ITEM_EFFECTIVE_DT on External File Layout and External File Load (Doc ID 2608939.1)

Last updated on APRIL 14, 2022

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9.2 and later
Information in this document applies to any platform.


A business process needs to perform a Mass Select of organizations based on a file from an external source. For the organization id's in the file from the external source, a Group Post of transactions will be created.

The Item Effective Date for the transactions in the Group Post needs to be unique to the organization.

The File Mapping used with the Mass Selection process does not include the Item Effective Date field. There is a provision to override the Item Effective Date for all transactions created in the group but this is not sufficient because the Item Effective Date will be different for each transaction created.

Is there an alternative means to load a unique Item Effective Date for each transaction from the external source?


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.