My Oracle Support Banner

Test Scores Data Not Loading in Production Tables from Staging After Applying PUM 13 (Doc ID 2564433.1)

Last updated on JULY 10, 2021

Applies to:

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

Symptoms

On Campus Solutions release 9.2, External Data Loads

ACTUAL BEHAVIOR
---------------
After applying PUM 13, when attempting to load test scores data through File Parser/PDL into PS_SCC_STG_TESTCMP and run Transaction Management Process, the process runs to success but does not LOAD to PS_STDNT_TEST_COMP table or Test Results page. It loads to the other tables.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Run File Parser to load Test Scores Data to Constituent Staging
  2. Navigate to Campus Community > Constituent Transaction Management > Constituent Staging to confirm if test scores data gets loaded in PS_SCC_STG_TESTCMP
  3. Run Transaction Management Process under Campus Community > Constituent Transaction Management > Transaction Management Process with all options checked.
  4. Process goes to Success but no test scores data appears in Test Results page or PS_SCC_STG_TESTCMP

 

Cause

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
Symptoms
Cause
Solution
References


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