Enter Transactions Form (ARXTWMAI) Freezes When Performing Query Run (Doc ID 161256.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Receivables - Version 11.5.5 to 11.5.10.0 [Release 11.5.5 to 11.5.10]
Information in this document applies to any platform.

Symptoms

While entering Transactions form it freezes when Performing Query Run
Error encountered during parse: ORA-01445


The following statement encountered a error during parse:

SELECT ROWID,NOTE_DATE,AL_NOTE_TYPE_MEANING,TEXT,ROW_ID,CUSTOMER_TRX_ID,
NOTE_ID,NOTE_TYPE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATED_BY,
CREATION_DATE,LAST_UPDATE_DATE
FROM AR_NOTES_V
WHERE customer_trx_id = :1
order by creation_date

 

 

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