Unable To Create AR Invoice For Customer (Doc ID 2155391.1)

Last updated on MARCH 31, 2017

Applies to:

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


On : version, Billing - Transactions

Unable to create AR invoice for customer

Error ORA-01403: no data found

We are trying to create a transaction for the 22nd March 2016 although it comes up with the above error


Error ORA-01403: no data found

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

1. Login with BILLING_MGR_OPERATIONS/Welcome1
2. Navigate to Billing -> Manage Customers
3. Create a new customer, account, site by clicking the create icon. Provide
the start dates for the account and site to 01/01/2014.
4. Click on the plus icon at the site purpose level. Notice that the from
date gets defaulted to sysdate. Choose site purpose as SHIP_TO, save and

5. Now query the customer in the manage page, click on the site number.
Delete the ship to site purpose. Create a new one with the from date as
01/01/2014. Save and close
6. navigate to Billing > Create transactions

7. Create a transaction with a transaction date on 22/03/2016 > Error ORA-01403: no data found

The issue has the following business impact:
Due to this issue, users cannot create an invoice on 22/03/16.


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