AutoInvoice: Please define all periods in which revenue is to be recognized or credited for lines with Different Accounting Rules

(Doc ID 2135833.1)

Last updated on JULY 24, 2017

Applies to:

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


On : 12.1.3 version, Transactions Related

Unable to create invoices with different Accounting Rule per line. 

When attempt to create a manual transaction with an accounting rule,
receive the following error “FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502”.

Click on OK,  receive error "An Unexpected Error -6502 has occurred. An alert has been sent the system administrator. ORA-01403: no data found".

Note:  If create invoice with no Accounting Rule, then do not receive error.

Same issue when importing invoices using Autoinvoice


FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502



Errors: 1) Please define all periods in which revenue is to be recognized or credited.
Note that revenue cannot be recognized or credited in closed and close pending periods.

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

Using Receivables Manager responsibility, navigate to Transactions, Transactions
Enter information, customer Bill To / Ship To information, etc.
Select Invoice Rule = In Advance
Click on lines; enter item information, quantity, price etc.
Click on Rules; enter duration and date
Click on Distributions to check or change account, then encounter error

The issue has the following business impact:
Due to this issue, users cannot create transactions with accounting rules.


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