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

ZSF_FCST_AUTO_PILOT_JOB_DEFN

A list of managed jobs that should be scheduled by Autopilot Job shall be maintained in table ZSF_FCST_AUTO_PILOT_JOB_DEFN. Data for this table shall be inserted using SQL script during upgrade.

Details

  • Schema: FUSION

  • Object owner: ZSF

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZSF_FCST_AUTO_PILOT_JOB_D_PK

MANAGED_JOB_CODE

Columns

Name Datatype Length Precision Not-null Comments
MANAGED_JOB_CODE VARCHAR2 100 Yes Primary Key. Name of the managed job to be scheduled by autopilot.
ESS_JOB_PACKAGE VARCHAR2 1000 Yes Package within which the ESS job has been defined in the CrmEss application
ESS_JOB_NAME VARCHAR2 200 Yes Job Name as defined in the CrmEss application.
FREQUENCY VARCHAR2 30 Yes MINUTE / HOUR / DAY / WEEK / MONTH / YEAR / FCST_HEADER_FREEZE_DATE
FREQUENCY_INTERVAL NUMBER 5 Yes Frequency Interval. Eg., HOUR with 2 will mean once every 2 hours.
RETRY_COUNT NUMBER 5 Yes Number of times the Autopilot Job should retry execution of this job if it results in an ERROR before giving up.
REFERENCE_DATE_TIME DATE Yes For Hourly jobs, the earliest MINUTE is used. For Daily jobs, only HH is used. For WEEKLY jobs, the WEEKDAY+HH is used. For MONTHLY jobs, the DAY+HH is used. For Yearly jobs, the DAY+MONTH+HH is used. For FCST_HEADER_FREEZE_DATE based jobs, only HH is used.
NOTIFY VARCHAR2 100 Yes One or more of ERROR/WARNING/SUCCESS (For ex., ERROR+WARNING)
PRIORITY NUMBER 2 Yes 1 to 99. 1 is the highest and 99 is the lowest.
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_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.
CONFLICT_ID NUMBER 18 Yes Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
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.
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
PARAM1 VARCHAR2 4000 Parameter to be passed to the job.
PARAM2 VARCHAR2 4000 Parameter to be passed to the job.
PARAM3 VARCHAR2 4000 Parameter to be passed to the job.
PARAM4 VARCHAR2 4000 Parameter to be passed to the job.
PARAM5 VARCHAR2 4000 Parameter to be passed to the job.
PARAM6 VARCHAR2 4000 Parameter to be passed to the job.
PARAM7 VARCHAR2 4000 Parameter to be passed to the job.
PARAM8 VARCHAR2 4000 Parameter to be passed to the job.
PARAM9 VARCHAR2 4000 Parameter to be passed to the job.
PARAM10 VARCHAR2 4000 Parameter to be passed to the job.
PARAM11 VARCHAR2 4000 Parameter to be passed to the job.
PARAM12 VARCHAR2 4000 Parameter to be passed to the job.
PARAM13 VARCHAR2 4000 Parameter to be passed to the job.
PARAM14 VARCHAR2 4000 Parameter to be passed to the job.
PARAM15 VARCHAR2 4000 Parameter to be passed to the job.
PARAM16 VARCHAR2 4000 Parameter to be passed to the job.
PARAM17 VARCHAR2 4000 Parameter to be passed to the job.
PARAM18 VARCHAR2 4000 Parameter to be passed to the job.
PARAM19 VARCHAR2 4000 Parameter to be passed to the job.
PARAM20 VARCHAR2 4000 Parameter to be passed to the job.

Indexes

Index Uniqueness Tablespace Columns
ZSF_FCST_AUTO_DEFN_PK Unique Default MANAGED_JOB_CODE