EBI 9.2 Page Data Inconsistent Error When Proforma or Invoice Icon Pressed When Billing Interface Has Been Recently Run (Doc ID 2055834.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : 9.2 version, Billing Finalization/Proforma Image 11

Page Data Inconsistent Error when Proforma or Invoice Icon pressed when Billing Interface has been recently run
We are periodically receiving the following error when using the Proforma & Invoice icon on the Standard Billing page.

ERROR
-----------------------
Page data is inconsistent with database. (18,1)

We have determined the error occurs if a Billing Interface program has run since the Standard Billing page has been opened. The Billing Interface programs updates the Last BI Intfc ID counter on INSTALLATION_BI, so when logic on the Standard Billing page attempts to save the component to allow the proforma to either be scheduled or rendered online, table INSTALLATION_BI does not match what was originally loaded into the buffer. We believe in particular code to update INSTALLATION_BI.IVC_PRO_TOGGLE is conflicting.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a new invoice
2. New Window and run billing interface
3. Go back to other window and run proforma or generate invoice action

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer just went live 9.2 a couple weeks ago, and have many users reporting these errors. Much of the interfaced billing data comes from projects/costing, so the billing interface needs to be run manually throughout the day (about 50 times per day). This is generating many errors for other billing specialists manually entering/processing other types of bills.

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