R12:AP: Unique Constraint HZ_CODE_ASSIGNMENTS_U1 Voilation Occurs While Selecting Fiscal Classifications Code In The Supplier Creation Page
(Doc ID 3015631.1)
Last updated on APRIL 15, 2024
Applies to:
Oracle Payables - Version 12.0.1 and laterInformation in this document applies to any platform.
Symptoms
While selecting fiscal classifications code of the Associated Fiscal Classifications, Error appears in Supplier creation page
Below exception details can be seen in the page
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "" violated during post operation:"Insert" using SQL Statement "INSERT INTO HZ_CODE_ASSIGNMENTS(CODE_ASSIGNMENT_ID,OWNER_TABLE_NAME,OWNER_TABLE_ID,CLASS_CATEGORY,CLASS_CODE,PRIMARY_FLAG,CONTENT_SOURCE_TYPE,START_DATE_ACTIVE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,ACTUAL_CONTENT_SOURCE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:550)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5743)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "" violated during post operation:"Insert" using SQL Statement "INSERT INTO HZ_CODE_ASSIGNMENTS(CODE_ASSIGNMENT_ID,OWNER_TABLE_NAME,OWNER_TABLE_ID,CLASS_CATEGORY,CLASS_CODE,PRIMARY_FLAG,CONTENT_SOURCE_TYPE,START_DATE_ACTIVE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,ACTUAL_CONTENT_SOURCE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:550)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5743)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
It is expected that fiscal classification code can be assigned to supplier successfully
Steps To Reproduce:
1. Use the navigation Payables Super user Responsibility-> Supplier
2. Query the supplier
3. Assign Fiscal Classification code and save the changes
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 |