My Oracle Support Banner

Error Occurs While Creating Any Document Using ReST Service (Doc ID 3055612.1)

Last updated on OCTOBER 25, 2024

Applies to:

Oracle Retail Invoice Matching Cloud Service - Version 24.1 to 24.1 [Release 24.1]
Information in this document applies to any platform.

Symptoms

Error occurs while creating any document using ReST Service. Same is the case with UI too.

ERROR
-----------------------
object line object handle number name 0x2fc099180 294 package body RMS01.SQL_LIB.CREATE_MSG 0x1d5294788 1656 package body RMS01.REIM_DOCUMENT_SQL.VALIDATE_DEAL_CURR_CODE_CURR 0x1d5294788 10268 package body RMS01.REIM_DOCUMENT_SQL.VALIDATE_WKSHT_DOC 0x15cb68168 1 anonymous block ORA-00918: column ambiguously defined ORA-06512: at "RMS01.REIM_DOCUMENT_SQL", line 1592

Steps to Recreate:

  1. Navigate to Document Maintenance > Create Document.
  2. Enter the values on the Invoice document , as shown in the image that has all the values on it, but without error.
  3. Then click on Save button at the bottom of that page.
  4. Observe that all fields on the page are cleared and "application error occurred" image is displayed.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.