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

SVC_AP_ACT_CONDITIONS_INT

This table contains the definitions of conditions for the entity object of an action.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

SVC_AP_ACT_CONDITIONS_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
ACTION_CONDITION_ID NUMBER 18 The data to this column is filled during enrichment.
ACTION_ID NUMBER 18 Foreign key that references SVC_AP_ACTIONS.ACTION_ID, the action whose object the condition is defined for.This will be enriched.
NAME VARCHAR2 400 Name of the condition for an action.
DESCRIPTION VARCHAR2 1000 Description of the condition for an action.
CONDITION VARCHAR2 1000 Expression that evaluates to true or false to indicate whether the condition is met or not.
ACTION_STATUS_CD VARCHAR2 30 Lookup code that indicates the status to set an action to if the condition is met.
COMPLETION_FLAG VARCHAR2 1 This flag indicates that the current condition when met would depict the completion of this action.
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.
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 Used to link this record with the error record.
FILE_RECORD_NUM NUMBER 10 This column is required by import wizard to relate record in the interface table to the file row.
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 This column indicates import wizard if the import to base table was successful or Erorred out.
FILE_NAME_SYSTASK_ID NUMBER 18 This column is required for bulk import operations.
ACTION_CODE VARCHAR2 30 Action code will be used to determine what operation should be done: insert,update,delete.
INTERNAL_ACTION_CODE VARCHAR2 30 Internal action code will be populated internally by framework based on outcome of match step.
INTERNAL_OVN NUMBER 9 The Object Version Number of the record being updated. Used for Optimistic Locking as part of Incremental Update.
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.
ACTION_OSR VARCHAR2 255 This is used for enriching the action id during import.

Indexes

Index Uniqueness Tablespace Columns
SVC_AP_ACT_CONDITIONS_INT_N1 Non Unique Default BATCH_ID, IMPORT_STATUS_CODE
SVC_AP_ACT_CONDITIONS_INT_N2 Non Unique Default BATCH_ID, ACTION_OSR
SVC_AP_ACT_CONDITIONS_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID