Autoinvoice and Transactions Workbench: RAXTRX: Error Calling Raapic() and Transactions Form Raises Multiple Errors: FRM-40735, ORA-01403, ORA-01795 (Doc ID 1486824.1)

Last updated on JUNE 05, 2024

Applies to:

Symptoms

On : 12.1.3 version, Transactions Related

Attempting to run Autoinvoice Import Program(RAXTRX) and receive the following error:

ORA-01795: maximum number of expressions in a list is 1000
Error calling arcdaa_do_autoaccounting()
Error calling raaddl()
Error calling raapic()

Attempting to Save AR transaction Lines in Transactions Workbench (ARXTWMAI) and receive the following error:

FRM-40735:ON-INSERT trigger raised unhandled exception ORA-01795.
ORA-01403:no data found

1) If the records of assignment rules is equal or less then 1000, both RAXTRX and ARXTWMAI are fine.
2) If the records of assignment rules is more then 1000, RAXTRX and ARXTWMAI will get error lists above.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Responsibility: Receivables Manager

Navigation: Autoinvoice > Submit

Or

Responsibility:  Receivables Manager
Navigation:  Revenue Management > Revenue Contingencies > Assignment Rules
[Update] on Rule List
[Update] on Parameter
[Add Values]

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receivables > Autoinvoice > Submit

Cause

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