My Oracle Support Banner

Product Foreign Key For Events In 2nd Schema Refers To Product In 1st Schema (Doc ID 1571226.1)

Last updated on JANUARY 26, 2022

Applies to:

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


While rating events for accounts in 2nd schema, foreign key of the product refers the product object from 1st schema. i.e:

0 PIN_FLD_POID POID [0] /event/delayed/session/telco/gsm/mms 1430878044115040871 0
1     PIN_FLD_PRODUCT_OBJ POID [0] /product 615335 0

This foreign key refers to the same database. Please find snippet of two examples of events for customers in 2nd schema as below.

Example 1:

The user needs confirmation on whether FK/Reference to the first schema is expected by Oracle (So it is OOTB).
Is there any impact of having views in second schema?
And, pin_rel always puts the value as 1, irrespective of the schema where the account is. Is it correct?


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

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