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

OSS_MRA_RENEWAL_PARTIES

In Subscription Renewal process, this table is used for intermediate data processing, which has denormed party of Subscriptions entities.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: DEFAULT

Primary Key

Name Columns

OSS_MRA_RENEWAL_PARTIES_PK

TARGET_SUBSCRIPTION_PARTY_ID

Columns

Name Datatype Length Precision Not-null Comments
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SUBSCRIPTION_PARTY_ID NUMBER 18 Source Subscription Party Id from Parties
SUBSCRIPTION_ID NUMBER 18 Source Subscription Id
TARGET_SUBSCRIPTION_PARTY_ID NUMBER 18 Yes Primary Key
TARGET_PARTY_PUID VARCHAR2 120 TARGET_PARTY_PUID
TARGET_SUBSCRIPTION_ID NUMBER 18 Target Subscription Id
TARGET_SUBSCRIPTION_NUMBER VARCHAR2 300 Target Subscription Number
TARGET_PARTY_ROLE VARCHAR2 30 Target Party Role
TARGET_START_DATE DATE Target Subscription Start Date
TARGET_END_DATE DATE Target Subscriprion End Date
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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_MRA_RENEWAL_PARTIES_PK Unique Default TARGET_SUBSCRIPTION_PARTY_ID