My Oracle Support Banner

Transaction Purge Process Deletes Data in Person/Bio Common Attribute Record PS_SCC_CAF_PERSBIO (Doc ID 2807352.1)

Last updated on NOVEMBER 12, 2021

Applies to:

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


When common attribute fields (CAF Fields) based on attribute record SCC_CAF_PERSBIO are created and data is entered for those fields under "Personal" page of "Add/Update a person" component, the Transaction Purge Process will delete all data in the attribute record PS_SCC_CAF_PERSBIO, regardless where the EMPLID originates.

The issue can be reproduced with the following steps:

  1. Create new common attribute fields based and link them to Record Context SCC_PERS_BIOG.
  2. Run Entity Sync.
  3. Go to Campus Solutions Administrator Homepage.
  4. Click Campus Community tile.
  5. Search for ID= AA0001 in Add / Update a Person.
  6. Go to Personal tab.
  7. Enter data for the common attribute fields.
  8. Do the same for another ID = AA0002.
  9. Navigate to Student Admissions > Application Transaction Mgmt > Constituent Staging.
  10. Do a search. Make sure there is a row Transaction Status = Posted. If there's none, open any Loaded status row and click Run Search/Match/Post button.
  11. Remember the Transaction Code e.g. ADMISSIONS_APPLICATION and the ID created.
  12. Repeat steps 3 to 7 for the ID Created.
  13. Query the record PS_SCC_CAF_PERSBIO in the backend -- should display data entered for the common attribute fields for at least the 3 EMPLIDs.
  14. Run Transaction Purge Process under Student Admissions > Application Transaction Mgmt.
  15. Go to Constituent Staging to check if the Purge process worked. All Transaction with Posted status should now be gone if the process worked.
  16. Query the PS_SCC_CAF_PERSBIO table again in the backend -- table is now empty.




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.