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:

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

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