Application Error Occurred due to error column ambiguously defined
(Doc ID 3054374.1)
Last updated on OCTOBER 21, 2024
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version 24.1 and laterInformation in this document applies to any platform.
Symptoms
When trying to create a merchandise invoice in IMCS, running into application error occurred issue.
logger logs, includes the following details.
sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-00918: column ambiguously defined@2REIM_DOCUMENT_SQL.VALIDATE_DEAL_CURR_CODE_CURR ORA-00918: column ambiguously defined
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go on IMCS> Tasks>Document Maintenance>Create Document
2. Choose document type
3. Enter Document
4. Choose order number
5. Enter document date
6. Enter quantity
7. Enter Merchandise Amount
8. Click on Save – Error appears
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 |