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 NOVEMBER 05, 2019

Applies to:

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

Goal

Q1 : 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] 0.0.0.2 /event/delayed/session/telco/gsm/mms 1430878044115040871 0

1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /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:

nap(18262)> robj - 0.0.0.2 /event/delayed/session/telco/gsm/mms 1430878044115040871

  number of field entries allocated 60, used 59

0 PIN_FLD_POID POID [0] 0.0.0.2 /event/delayed/session/telco/gsm/mms 1430878044115040871 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1365155005) Fri Apr 5 09:43:25 2013
0 PIN_FLD_MOD_T TSTAMP [0] (1365155005) Fri Apr 5 09:43:25 2013
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.2 /account 6064262 0
.
.
.
.
.
1 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.2 /item/messages_usage 6065958 0
1 PIN_FLD_LINEAGE STR [0] ""
1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.2 /purchased_product 6065062 0
1 PIN_FLD_PERCENT DECIMAL [0] 0
1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 615335 0
.
.
.

Example 2:

nap(18262)> robj - 0.0.0.2 /event/delayed/session/telco/gsm 1430966005046037359

  number of field entries allocated 60, used 59

0 PIN_FLD_POID POID [0] 0.0.0.2 /event/delayed/session/telco/gsm 1430966005046037359 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1365588459) Wed Apr 10 10:07:39 2013
0 PIN_FLD_MOD_T TSTAMP [0] (1365588459) Wed Apr 10 10:07:39 2013
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.2 /account 7073196 0
.
.
1 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.2 /item/misc 7077797 0
1 PIN_FLD_LINEAGE STR [0] ""
1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.2 /purchased_product 7077733 0
1 PIN_FLD_PERCENT DECIMAL [0] 0
1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 621947 0
1 PIN_FLD_QUANTITY DECIMAL [0] 200000

.
.

Customer needs confirmation on whether FK/Reference to the first schema is expected by Oracle (So it is OOTB).

Also Customer would like to know is there any impact of having views in second schema.
 

Q2 : pin_rel always puts the value as 1, irrespective of the schema where the account is. Is it correct?

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.