My Oracle Support Banner

Newly Created Record SCC_SL_SM_RSLT is Saving Data From Previous Record for Suspended Records in Transaction Management Process (Doc ID 1914424.1)

Last updated on JANUARY 03, 2023

Applies to:

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

Symptoms

ISSUE STATEMENT
-------------------------------------

When using the Search/Match Setup relating to Transaction Setup, the results show the SCC_STG_STATUS = 'SA' to add an EMPLID, along with the SEARCH_RULE_NBR > 0, rather than updated or suspended (if more than one id is found) assigned to 'SA' rows.

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


1. Run Search/Match/Post for an applicant record in the constituent staging table.
2. Query the SCC_SL_SM_RSLT record.
3. Run the SMP for an applicant you know will suspend.
4. Query the record again and the data will be from the previous row.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users cannot use the new record to find constituents with no matches from search/match as it is generating incorrect data.

Changes

 

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
Changes
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.