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

Last updated on DECEMBER 04, 2019

Applies to:

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

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