GMDQMSMC Workflow Error - ORA-20108 (Doc ID 1908946.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Workflow Issues

Dynamic Query is used for AME attribute 'Operating_Unit' .Based upon the operating unit returned by query ,sample notification is send to different approval group.
During actual transaction following error is seen

ERROR
-----------------------
ORA-20108: The transaction ID specified returned an incorrect number of rows for OPERATING_UNIT. Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable and subscribe event oracle.apps.gmi.lotexpirydate.update
2. Set the AME for the transaction type - Process Quality Lot Expiry Sample Creation
3. Submit concurrent program Lot Expire date Program.
4.System is trowing below error .
ORA-20108: The transaction ID specified returned an incorrect number of rows for OPERATING_UNIT. Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Users are not getting the notifications

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