Mass Assign Service Indicators Inserts Invalid Data into SRVC_IND_DATA (Doc ID 1214293.1)

Last updated on JANUARY 30, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms


When you run the batch process to mass assign Service Indicators using a query that may not pick up any new students you are getting orphan rows in the records SRVC_IND_DATA and AUDIT_SRVC_IND.

EXPECTED BEHAVIOR
-----------------------
Expect to not get any rows written to SRVC_IND_DATA if none have been assigned to EMPLIDs.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a query that will not pick up anyone and use it as the selection tool for Pop Selection for the mass assign SIs. Campus Community - Service Indicators (Student) - Mass Assign
2. Run the process.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are getting invalid data in 2 records mentioned and the rows cannot be removed via PIA, however the rows do not cause any errors.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms