My Oracle Support Banner

Oracle Cloud Receivable Transaction With Revenue Rule Could Not Be Saved Because Of Error (Doc ID 2326608.1)

Last updated on APRIL 03, 2019

Applies to:

Oracle Fusion Receivables Cloud Service - Version and later
Information in this document applies to any platform.


Attempting to create receivable transaction with revenue rule but cannot save due to error.

This is the first time creating AR transaction with invoice revenue rule as ‘Daily Rate All period’ with Start as 2-nov-2017 & end as 2-nov-2018.
You have confirmed the GL and AR periods affected are not in closed status. But the following error is still occurring when you try to save the AR transaction:

ORA-20001: Define All periods in which revenue is to be recognized or credited. Revenue cannot be recognized or credited in closed and close pending periods. ORA-06512: at FUSION.ARP_DATES

The issue can be reproduced at will with the following steps:
1. Billing
2. Create Transaction
3. Save and notice the error


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

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