My Oracle Support Banner

Does CI_TXN_DETAIL_STG Table have Primary Key Constraint? (Doc ID 2514125.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Goal

On RMB v2.6.0.1, we are trying to create FK constraint on CI_TXN_DTL_PRITM_STG to PK on CI_TXN_DETAIL_STG.

But we notice CI_TXN_DETAIL_STG table does not have Primary key constraint.

This article confirms if this is correct behavior. It also confirms if the following is valid:
1) Should CI_TXN_DETAIL_STG have primary key constraint on TXN_DETAIL_ID?
2) Should CI_TXN_DTL_PRITM_STG table have FK on CI_TXN_DETAIL_STG table?
 

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


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