Getting ORA-04023 Error When Trying To Query Transaction In Transaction Workbench (Doc ID 2303717.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Symptoms

Getting below error when querying an Invoice or Credit memo in Transaction Workbench  

ORA-04023: Object SELECT TRX_NUMBER,BS_BATCH_SOURCE_NAME,ORG_ID,LEGAL_ENTITY_ID,TRX_DATE,ROW_ID,CUSTOMER_TRX_ID,BATCH_ID, RAB_BATCH_NAME,RAB_BATCH_DATE,RAB_GL_DATE,RAB_BATCH_SOURCE_ID,INITIAL_CUSTOMER_TRX_ID, CT_COMMITMENT_NUMBER,BATCH_SOURCE_ID,BS_CREDIT_MEMO_BATCH_SOURCE_ID,CUST_TRX_TYPE_ID,CTT_OPEN_RECEIVABLES_FLAG,CTT_POST_TO_GL, CTT_CREATION_SIGN,CTT_ALLOW_OVERAPP_FLAG,CTT_NATURAL_APP_ONLY_FLAG,CTT_CREDIT_MEMO_TYPE_ID,CTT_CLASS,INVOICING_RULE_ID, INVOICE_CURRENCY_CODE,GD_GL_DATE,EXCHANGE_DATE,EXCHANGE_RATE_TYPE,EXCHANGE_RATE,GDCT_USER_EXCHANGE_RATE_TYPE,PRIMARY_SALESREP_ID, BILL_TO_CUSTOMER_ID,BILL_TO_ADDRESS_ID,BILL_TO_CONTACT_ID

FRM-40505: ORACLE error: unable to perform query.

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation: Transactions > Transactions>Query Transaction

This error is also produced when credit transaction is performed

Changes

 No Changes

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms