EBI9.0+: Billing Interface Accounting Entries Not Created Following Correction of 0060 Invalid Customer (Doc ID 1438051.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


Statement of Issue
-----------------------------------
Billing Interface Accounting Entries Not Created Following Correction of 0060 Invalid Customer
Customer is loading billing interface from external source. When a 0060 Invalid Customer is encountered, there are situations when users only corrected the PS_BI_INTFC and not the PS_BI_INTFC_AEDS rows.

Expected Behavior
-----------------------------------
Customer expects the system should be able to detect business unit mismatch at the billing interface so it won’t create the bill to be invoiced.

Actual Behavior
--------------------------------
It creates the invoice but without the accounting entry from PS_BI_INTFC_AEDS

Business Impact
---------------------------------------
The invoice gets generated without any error that the accounting entry is missing all the way to GL. By the time the users find out the bill is already invoiced and sent to GL

Steps to Replicate
----------------------------
1. Create an interface that will result in invalid customer
2. Run billing interface
3. Generate the invoice

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