7.0-7.3 Account Product Split Conversion Issue in The upgrade_account_product_split.sql (Doc ID 1620913.1)

Last updated on FEBRUARY 14, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 to 7.3.0.0.0 [Release 7.0.0 to 7.3.0]
Information in this document applies to any platform.

Goal

Using the upgrade_account_product_split.sql file from <Patch 17450101> on 7.3.0.0.0/Solaris , it is running into an issue.

It looks like the scripts relies on the au_account_products_t table but here at the user's side, for whatever reason, there has very few records in that table.  Due to this, the conversion of account_products_t -> purchased_product_t data does not look correct.  

Example of data records:

  

Solution

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