Questions on Opened_t Update of G/L And ITEM_T with 7.4 MPS2 Upgrade
(Doc ID 2150713.1)
Last updated on MARCH 19, 2019
Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.4.0] Information in this document applies to any platform.
This article is to clarify some detailed questions about upgrade process of 7.4 MPS2.
The user is trying to upgrade from 7.4 PS10 (<Patch 13518161>) to 7.4MPS2 (<Patch 19626042>) and need more information on the update to the G/L stored procedures, data patch update to ITEM_T.OPENED_T and UseActualBilledTimeForGLReport parameter in billing business params.
The questions are based on the patch installation document for 7.4MPS2 which discusses about the following changes: (1). A new parameter UseActualBilledTimeForGLReport is introduced in billing business params to report previously billed based on actual billing date (OPENED_T). (2). The data patch fix_items_with_zero_opened_t.source to set OPENED_T on items whose effective_t is greater than or equal to a user-provided cut off date. (3). Dropping and recreating the index i_item_glseg_eff__id Index that takes an expression to include OPENED_T in the composite index
Questions and Answers
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!