PE Sync Corrupts AIR Course Entity Which Results in APT Request Not Working
(Doc ID 2493278.1)
Last updated on FEBRUARY 03, 2019
Applies to:PeopleSoft Enterprise CS Student Records - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Student Records Additional Features
We are having issues with PE Sync, We deselected Child Academic items checkbox on AIR Course as we don't want it to have any children and prevent users from setting any. However PE Sync corrupted course entity in Entity Registry (an orphan dodgy row is added)
Now if we try to fix it by using SQL and then run PE sync we get the same issue again
This issue caused break in APT Request and Self Service. both are not working.
Cannot find entity id child of (NOCHILDREN) (0,0) SCC_COMMON.ENTITY.EntityRegFactory.OnExecute Nam e:createEntity PCPC:1144 Statement:21 Called from:SCC_COMMON.ENTITY.EntityRegFactory.OnExecute Name:createEntityWithoutChildren Statemen t:5 Called from:SCC_COMMON.ENTITY.EntityRegCache.OnExecute Name:getEntityNoChildren Statement:491 Called from:SSR_AIR.ENTITY.AIREntityCE.OnExecute Name:fillNow Statement:54 Called from:SCC_COMMON.ENTITY.ChildEntity.OnExecute Name:childEntities Statement:738 Cal
The issue can be reproduced at will with the following steps:
1- Navigate to Set Up SACR - Product Related - Student Records - Program Enrollment - Academic Item Types > Course
2 - Uncheck "Child Academic Items" checkbox. Say yes to warning message and save
4 - Go to Set Up SACR - Product Related - Student Records - Program Enrollment and click on Sync Entities
5 - Once PE Sync is done. Check AIR Course Entity (Set Up SACR - System Administration - Entity - Entity Registry)
AIR Student Milestone Child entity has been removed leaving an orphan blank row for Order nbr 50
6 - Verify that self service is not working
7 - Verify that APT Request is not working
Showing"Cannot find entity id child of (NOCHILDREN) (0,0) " error
8 - navigate back to Academic Item Types > Course
9 - Check Child Academic Items chekbox
10 - navigate to item type matrix and sync Entities and also check if COURSE has child items
11 - Check Air Course Entity. AIR Student Milestone has been added as Children entity for COURSE but the orphan blank row still exists
12. Try running the APT Request process. It will go to No Success with error
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