My Oracle Support Banner

R12 Unable To Query Bills Receivable Transaction (Doc ID 2648519.1)

Last updated on MARCH 16, 2020

Applies to:

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

Symptoms

On : 12.2.x version, Bills Receivable

Unable to query the BR transaction  due to the error "ORA-01403: no data found"


ERROR
-----------------------

 ORA-01403: no data found

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01436

   

FND Debug log shows following lines:

ar.plsql.AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh.begin AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh()+
ar.plsql.AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh >>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh ()ORA-01436: CONNECT BY loop in user data
ar.plsql.AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected >>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected ()
ar.plsql.AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected Is_BR_Remit_Selected:            p_trh_id  : xxxxxxx
ar.plsql.validate_actions >>>>>>>>>> EXCEPTION : validate_actions ()
ar.plsql.validate_actions "Validate_actions: p_customer_trx_id : xxxxxxxx"
fnd.forms.ARBRMAIN.ON_ERROR "FND?FND_FORMS_ERROR_LOGGING?N?ERRNO?-1436?N?REASON?ORA-01403: no data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a BR
2. Try to query the BR
3. You will see an error message "ORA-01403: no data found"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot query the BR and view it on the transaction form.

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


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