My Oracle Support Banner

Quality Collection Workbench lov for a User Defined Element gives error (Doc ID 2740610.1)

Last updated on JANUARY 01, 2021

Applies to:

Oracle Quality - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, SUPPORT



In an user defined existing collection plan , there was an element  that had a validation code set in the element. Now that element is displaying error if the lov is clicked. Even the auto populated value is also getting invalidated due to the validation code.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 .Set up element for Supplier with out any LOV
2. Add validation code to element
3. Add to collection plan after collection plan has been is use.
4 Open Collection workbench
5. Assign the organization.
6. Search for 'user defined' collection plan.
7. Click on the 'user defined' collection plan link.
8. Click on the Add Data(0) button.
9  Enter the Item and hit tab.
There is an Error information displayed on the top of the page:

Error: Can not execute the action on element Item because of the following error: The user-defined validation string cannot validate the data for collection element Supplier Old. Please check the 'Assign a Value' action in the Collection Plans' form


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete their go live for December 4

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