Intended Use update in Fiscal Invoice Lines Open Interface is failing with ORA-01422 error
(Doc ID 2646496.1)
Last updated on AUGUST 27, 2024
Applies to:
LAD Add-on Localizations - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
Version 12.1: Brazil Consulting Localizations
Actual Behavior
Intended Use update in Fiscal Invoice Lines Open Interface is failing with ORA-01422 error.
Expected Behavior
Intended Use update in Fiscal Invoice Lines Open Interface should complete without any error.
Steps
The issue can be reproduced at will with the following steps:
- Responsibility: Integrated Receiving
- Navigation: Receipts > Open Interface
- Find any Fiscal Invoice
- Click Lines
- On Invoice Lines tab, enter a new value for Intended Use Id or Intended Use Code
The following error message is exhibited:
Error Message: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01422
Business Impact
Due to this issue, incorrect Intended Uses cannot be fixed in Fiscal Invoice Lines of Open Interface.
Changes
N/A
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 |