My Oracle Support Banner

ORMBA 2.7 Installation : Repository View Refers A Table Field That Does not Exist In CI_TXN_HEADER (Doc ID 2499696.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing Analytics - Version 2.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.7.0.0.0 version, ORMBA - Dashboards

ACTUAL BEHAVIOR
---------------
ORMBA 2.7 Installation : Repository View refers a table field that does not exist in CI_TXN_HEADER

During the ORMBA 2.7 Installation, the ORMBA Repository schema RMB1REP has views which refer to ORMB base table CI_TXN_HEADER. However, this view BF_FEED_VW is referring the following field: JRN_FLG, JRN_SCN and JRN_EFF_START_DTTM from CI_TXN_HEADER ORMB table which does not exist in the table.

EXPECTED BEHAVIOR
-----------------------
The JRN_FLG, JRN_SCN and JRN_EFF_START_DTTM should exist in the CI_TXN_HEADER ORMB table.


Cause

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
Symptoms
Cause
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.