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

ZCA_EXP_JOBS

The table contains one record per defined bulk export job.

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ZCA_EXP_JOBS_PK

EXPORT_JOB_ID

Columns

Name Datatype Length Precision Not-null Comments
EXPORT_JOB_ID NUMBER 18 Yes Primary Key.
JOB_PARAMETERS VARCHAR2 1000 This columns containts details regarding the job parameters.
EMAIL_ADDRESS VARCHAR2 500 Email Address for sending email notification of export activity completion
MASS_UPDATE_DTL_ID NUMBER 18 Mass Update Detail Id for Export Jobs
HIERARCHY_PARENT_OBJ_CD VARCHAR2 128 Contains Parent Object Code for Hierarchy JOB
ZIP_FILE_NAME VARCHAR2 250 Maintains zip file name for hierarchy job
ENABLE_SPLIT VARCHAR2 20 Stores final zip file splitting enabled or not - YES/NO
ENABLE_EXPORT_ATTACHMENTINFO VARCHAR2 20 Export Attachment info of Export object -YES/NO
SPLIT_SIZE NUMBER 18 Stores split size number parent records exporting in zip file
HIERARCHY_PARENT_OBJ_ID NUMBER 18 Maintains parent object ID for hierarchy job
INITIAL_EXTRACT_FILTER_TM TIMESTAMP This field saves the Intial Date time of the interval between which the data export has to happen.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
EXPORT_JOB_NUMBER VARCHAR2 200 Alternate Key for Export Jobs
SEEDED_FLAG VARCHAR2 1 Seeded Flag to indicate whether the job is a seeded job or not.
VISIBLE_FLAG VARCHAR2 1 Visible Flag to indicate whether the job is going to be visible in the job listing page.
NAME VARCHAR2 100 Yes Export Job Name
DESC_TEXT VARCHAR2 250 Job Description
FILE_TYPE VARCHAR2 30 Yes File export type, e.g. CSV (for future use XML)
FILE_CHARSET VARCHAR2 30 Yes Charset to use, e.g. UTF-8, UTF-16, etc. Lookup to FND_LOOKUPS
ERROR_THRESHOLD NUMBER 9 Number of errors to allow before aborting. Null = no limit
DELIMITER VARCHAR2 30 Delimiter to use, e.g. comma, tab
QUOTE_CHAR VARCHAR2 10 Character(s) to use to encapsulate value if it contains the delimiter (e.g. double quote, single quote, null for nothing)
END_OF_LINE VARCHAR2 30 End of Line Chararcter to use. Lookup to be CR, LF, or CRLF. Default: LF
HEADER_ROW_INCLUDED VARCHAR2 1 Y/N to include the header row in the output
NULL_VALUE VARCHAR2 30 The value to use to represent a null value. If null itself no value is output. Default: null
COMPRESSION VARCHAR2 1 Compression options. G=gzip individual files, Z=create single zip of all files, J=create single zip of all files
ACTIVE_FLAG VARCHAR2 1 Indicate whether the task is active (registered within ESS)
SCHEDULE_TYPE_CD VARCHAR2 30 SCHEDULE_TYPE_CD
SCHEDULE_MODE_CD VARCHAR2 30 Schedule mode - repating, one time (manually), one time (scheduled)
SCHEDULE_STATUS_CD VARCHAR2 30 Schedule status (scheduled, not scheduled, running, complete, error)
START_TM TIMESTAMP Start date for schedule
NEXT_SCHEDULE_TM TIMESTAMP Next scheduled date
REPEAT_FREQUENCY NUMBER 10 Number of repeat frequency
END_DATE_TM TIMESTAMP End date time
REPEAT_UNIT_CD VARCHAR2 30 Repeat unit code (hours, days, weeks, months)
EXPORT_MAP_ID NUMBER 18 Identifies the export mapping used for field mappings
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PARENT_REQUEST_ID NUMBER 18 Parent Scheduler Request in case of Repeating exports
TIMESTAMP_FORMAT VARCHAR2 120 Timestamp Format
DATE_FORMAT VARCHAR2 120 Date Format
DECIMAL_SEPARATOR VARCHAR2 1 Decimal Separator
LAST_BATCH_ID NUMBER 18 Most recently run batch
LAST_BATCH_START_TM TIMESTAMP The last time a batch for this job was started
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_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes 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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
EXPORT_TYPE VARCHAR2 100 Export type specifies the type of export job, whether it is Standard or classic.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
ZCA_EXP_JOBS zca_exp_maps EXPORT_MAP_ID
zca_exp_batches zca_exp_jobs EXPORT_JOB_ID

Indexes

Index Uniqueness Tablespace Columns
ZCA_EXP_JOBS_U1 Unique Default EXPORT_JOB_ID, ORA_SEED_SET1
ZCA_EXP_JOBS_U11 Unique Default EXPORT_JOB_ID, ORA_SEED_SET2