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 11.1.10.0.0 and later
Oracle Fusion Receivables - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 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
-----------------------

Error ORA-01403: no data found


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

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

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

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