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.

Symptoms

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


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

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

 

Autoinvoice:

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.



STEPS
-----------------------
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

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

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