My Oracle Support Banner

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

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