ORMB V2.9 Upgrade - Deferred Revenue Recognition Functionality Issues "DRR_STATUS_FLG" column in the "CI_REV_REC_SCH" table is no longer exists
(Doc ID 2698502.1)
Last updated on AUGUST 14, 2020
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, ENV - Environment
ORMB v2.9 upgrade - Deferred revenue recognition functionality issues
We did the DB upgrade from v22.214.171.124 to v2.9.0 on a DB with Production transaction data successfully, so we now have the following stack up and running:
App v126.96.36.199 (plain vanilla)
DB v188.8.131.52 (on 19c) (with DQ Prod Transaction data + Prod Gold config + Prod blueprint data)
Weblogic 184.108.40.206 (Native mode)
We are trying to configure all the pre-requisites before running the "Upgrade Batch for Deferred Revenue Recognition (C1-RRUPG)" to convert data from old DRR data model to new DRR data model. The upgrade guide for v220.127.116.11 (where this new batch was introduced) and the Batch control description mentions the below statement:
"...This batch considers all existing deferred revenue recognitions which are in the Draft or Active status..."
But in v2.9 DB above we are finding that the "DRR_STATUS_FLG" column in the "CI_REV_REC_SCH" table is no longer there and there is not other column containing the status of the DRR record (eg: Draft, Active).
how this batch is actually going to work in absence of status on the DRR record?
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