1. Tables and Views for Sales and Fusion Service
  2. SVC_SELF_SERVICE_ROLES_INT

SVC_SELF_SERVICE_ROLES_INT

This table is used to store self service roles created by users.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

SVC_CSS_ROLES_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
FILE_RECORD_NUM NUMBER 10 This column is required by import wizard to relate record in the interface table to the file row. Import framework would populate this value .
ACCOUNT_PARTY_NUMBER VARCHAR2 30 Additional column to resolve ACCOUNT_PARTY_ID using alternate key ACCOUNT_PARTY_NUMBER.
ACCOUNT_PARTY_ORIG_SYS VARCHAR2 30 Additional column to resolve ACCOUNT_PARTY_ID using origninal system reference key.
ACCOUNT_PARTY_ORIG_SYS_REF VARCHAR2 255 Additional column to resolve ACCOUNT_PARTY_ID using origninal system reference key.
CONTACT_PARTY_NUMBER VARCHAR2 30 Additional column to resolve CONTACT_PARTY_ID using alternate key CONTACT_PARTY_NUMBER.
CONTACT_ORIG_SYS VARCHAR2 30 Additional column to resolve CONTACT_PARTY_ID using origninal system reference key.
CONTACT_ORIG_SYS_REF VARCHAR2 255 Additional column to resolve CONTACT_PARTY_ID using origninal system reference key.
ERROR_MESSAGE VARCHAR2 3000 This is an optional column and would be useful if consumers want any error message as the first error.
IMPORT_STATUS_CODE VARCHAR2 1 The other important column that interface tables needs to have is IMPORT_STATUS_CODE. This column will be populated as 'X' by import framework if there is any Format Errors. Otherwise the column will be null. During the base table load the consumers code should populate this value with correct value to indicate whether the row is successfully loaded or there is any error like validation error. (the possible values would be 'S','E').
FILE_NAME_SYSTASK_ID NUMBER 18 The column saves the individual sys task id for each input csv file, corresponding to value in the mkt_cm_systask table. This value will be populated by the import framework.
BATCH_ID NUMBER 18 Yes For each run of the job, import wizard generates a new batch id and this batch id will be used uniquely.
INTERFACE_ROW_ID NUMBER 18 Yes INTERFACE_ROW_ID is the unique identifier for the record with in a batch. Combination of BATCH_ID and INTERFACE_ROW_ID will be the unique in the interface table.
ACTION_CODE VARCHAR2 30 Specifies insert/update, etc operation to be performed on a record.
INTERNAL_ACTION_CODE VARCHAR2 30 Used by the ODI import logic. This is used to check whether is ODI or ADF flow.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
ROLE_ID NUMBER 18 If the role_id is passed by the user during import then it is insert otherwise it is update.
REGISTRATION_ID NUMBER 18 Foreign Key to Registration Object(SVC_SELF_REGISTRATION (REGISTRATION_ID)).
ACCOUNT_PARTY_ID NUMBER 18 Foreign Key to Account Object(HZ_PARTIES (PARTY_ID)).
CONTACT_PARTY_ID NUMBER 18 Foreign Key to Contact Object(HZ_PARTIES (PARTY_ID)).
LOGIN_ID VARCHAR2 320 This column will store userName to create ldap account
RELATIONSHIP_TYPE_CD VARCHAR2 320 This column is stores relationship type System Look up.
START_DATE DATE START_DATE will be stamped when a role is created.
END_DATE DATE END_DATE will be stamped when a role is deleted from DB. Delete role is soft delete here.
DELETE_FLAG VARCHAR2 1 DELETE_FLAG will store the value of whether roles deleted (also called as soft delete).
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
SVC_CSS_ROLES_INT_N1 Non Unique Default BATCH_ID, IMPORT_STATUS_CODE
SVC_CSS_ROLES_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID