1. Tables and Views for Sales, Fusion Service, and Field Service
  2. OSS_RERATE_DEPENDENT_OBJ_T

OSS_RERATE_DEPENDENT_OBJ_T

Following table is a temporary table used to store dependant objects.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

OSS_RERATE_DPNDNT_OBJ_PK

ID

Columns

Name Datatype Length Precision Not-null Comments
ID NUMBER 18 Yes This column represents the Primary key of the table.
BATCH_ID NUMBER 18 Yes This column represents the Batch ID of the Rerate Batch.
OBJECT_NAME VARCHAR2 30 Yes This column represents the Name of the dependent entitlement.
OBJECT_ID NUMBER 18 Yes This column represents the ID of the dependent entitlement.
STATUS VARCHAR2 30 This column represents whether dependent entitlement is processed.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
BALANCE_REGISTER_ID NUMBER 18 Following field is referring to the unique identifier of balance register for oss balance registers.
BALANCE_CODE_ID NUMBER 18 Following field is referring to the unique identifier of balance code for oss balance codes.
EFFECTIVE_START_DATE DATE Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
SUBSCRIPTION_ID NUMBER 18 This field denotes the subscription id of the subscription product corresponding to the usage event.
SUBSCRIPTION_PRODUCT_ID NUMBER 18 This field denotes the subscription product id of the subscription product corresponding to the usage event.
ORIG_SUBSCRIPTION_PRODUCT_PUID VARCHAR2 240 This field tracks the original subscription product alternate identifier associated to subscription product.
PRODUCT_CHANGE_SEQUENCE_NUMBER NUMBER This field tracks the product change sequence number.
RENEWAL_SEQUENCE_NUMBER NUMBER This field tracks the renewal sequence number.
ALLOWANCE_POOLING_GROUP VARCHAR2 30 Field used to capture the pooling group for the allowance.
ADDTL_POOLING_FILTER_CODE VARCHAR2 30 Field used to capture the additional filter for pooling.
POOL_ACROSS_RENEWALS VARCHAR2 1 Field used to capture whether the pooling should be done across renewals of subscriptions.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
OSS_RERATE_DEPENDENT_OBJ_T_N1 Non Unique Default BATCH_ID, OBJECT_ID, STATUS
OSS_RERATE_DEPENDENT_OBJ_T_PK Unique Default ID