Cannot Query AutoAccounting Type = Receivable getting FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422
(Doc ID 2949402.1)
Last updated on MAY 16, 2023
Applies to:
Oracle Receivables - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.11 version, Setup
When attempting, Cannot query AutoAccounting Type = Receivable after configuring Autoaccounting rules,
the following error occurs.
ERROR
-----------------------
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Responsibility: Receivables Manager
2.Navigation: Setup > Transactions > AutoAccounting
Run a query and the error is raised
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, cannot query the AutoAccounting rules
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 |