My Oracle Support Banner

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 2.9.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 2.9.0.0.0 version, ENV - Environment

ORMB v2.9 upgrade - Deferred revenue recognition functionality issues

We did the DB upgrade from v2.4.0.1 to v2.9.0 on a DB with Production transaction data successfully, so we now have the following stack up and running:

App v2.9.0.0 (plain vanilla)
DB v2.9.0.0 (on 19c) (with DQ Prod Transaction data + Prod Gold config + Prod blueprint data)
Weblogic 12.2.1.3 (Native mode)
JDK 1.8

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 v2.6.0.1 (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?
 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.