My Oracle Support Banner

When Using CTM and Affiliations, INSTITUTION Must be a Field for PDL Staging Record SAD_PDL_HDR_STG (Doc ID 2287878.1)

Last updated on FEBRUARY 05, 2019

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.


The Affiliation Overrides - Institution must be a field for the staged record name on CTM Transaction Setup.

Navigation: Set Up SACR > System Administration > Utilities > Constituent Transaction Mgmt > Data Update Rule Entry

For an individual that is a current employee, only a few data fields should be updated by the Test Score Load. However, all fields are being updated.

Users are unable to get the CTM Search Match Post process to recognize the Affiliation Overrides setup for a Data Update Rule. The main rule is associated with the Transaction Setup parameter. This main rule has other rules set up by Affiliation on the Affiliation Overrides page.

Per ORACLE Documentation, Campus Community Fundamentals > Setting Up CTM > Setting Up Affiliation Overrides for a Data Update Rule > Under the "Setting up Affiliation Overrides for a Data Update Rule" section, there is a message box which contains the following content:

Warning! To use Affiliation Overrides, Transaction Setup must be set to Partition by Transaction, Institution must be a field for the Staged Record Name entered in the Transaction Status and Date section of Transaction Setup, and the Affiliation Overrides page must be set up.

 The delivered staged record for ACT Test Score Load is SAD_PDL_HDR_STG. Therefore, INSTITUTION must be a field on this staging record - SAD_PDL_HDR_STG - for the Affiliation Overrides to work correctly.

If this understanding is correct, why does Record SAD_PDL_HDR_STG not include field INSTITUTION? The delivered transaction setup for ACT Test Score Load does not contain this field and there is no suggestion of a different record to use. Is there one that contains the INSTITUTION field that would work when using PDL to load both ACT Test Score Load and GRE Test Score Load? Shouldn't Affiliation Overrides work correctly for either process?


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.