My Oracle Support Banner

EBI9.2: Why Data From The BI Extract Tables Did Not Get Retained After PS Application Upgrade? (Doc ID 2361873.1)

Last updated on FEBRUARY 15, 2018

Applies to:

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


Q1: Since there is no data in the Extract tables now, what will be the impact when a user tries to print any of the existing invoices that are already Finalized before upgrade?

Customer's business scenario:
PeopleSoft FSCM upgrade from 9.0 to 9.2 (Tools upgrade from 8.51 to 8.54 and to 8.56) has been completed (Initial Pass).
When observed the UPG Count, the data that were existing in the Billing Extract tables have not got retained in the upgraded instance 9.2 DB. The row count for the extract tables are showing Zero and there is no data.
Through the script - DLEPUPV07.DMS (DMS Script) the BI extract tables have got dropped off during initial pass and recreated and hence there are no rows in these tables post upgrade.

Q2: As per Doc ID 1422351.1, it's normal for the step DLEPUPM07.DMS to drop tables,views, or both, on the Copy of Production database, as some tables and views need to be dropped from the database prior to compare, copy, or generating DDL scripts.

Customer is aware that at some point is normal to have 0 rows Billing tables:

- BI_EXTRCT_LINE ; BI_EXTRCT; BI_EXT_HDR_NOTE; BI_EXT_LIN_NOTE, as the DMS script that removed the data from them, but the question is:

Since there is no data in the BI extract tables now, what will be the impact when a user tries to print any of the existing invoices in the upgraded application, that were finalized before upgrade?


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.