Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
| Task | Task Description |
|---|---|
| GATHER_DATABASE_STATS | This task gathers the DB statistics. This should not be executed when a conversion is under process as it may impact the performance of an ongoing data conversion run and vice versa. This can be used as an alternate to running the GATHER_STATS job from POM. Input Format: Not required |
| KILL_SESSION | This task kills a data conversion session in the conversion schema. It will not impact uses in the Merchandising schema. You can get the session information by querying the V_DC_SESSION_INFO view using the APEX Data Viewer by prefixing the data conversion schema name. Input Format: All three values are to be provided separated by semicolon, for example: 1;1;1 |
| PURGE_TABLE | This task truncates data conversion or Merchandising tables which are not seed tables. You should ensure tables are truncated as per their dependencies (that is, the child tables are truncated before the parent). Input Format: Input is the table name prefixed with the schema name. For example, RMS01.ITEM_LOC can be given as input to truncate ITEM_LOC table of Merchandising schema RMS01. |
| BACKUP _TABLE | This can be used to backup any Merchandising or data conversion table if you wish to save a copy for lookup before you truncate/purge. The table is saved in the conversion schema with a generated name prefixed with ”BKPDC”. The generated table name would be available in the Log Message in the Task Run History section of the System Administration screen. You can query the generated table’s data using the APEX Data Viewer by prefixing the data conversion schema name. Input format: <SCHEMA_NAME>.TABLE_NAME Multiple tables can be given as input with comma as separator, for example: RMS01.ITEM_MASTER, RMS01_DC. SVC_ITEM_MASTER |
| ENABLE_TRIGGER | This can be used to enable one or more triggers. You can also choose to enable all triggers by passing ’ALL’ as the input parameter. The trigger names are to be provided as input. Input Format: <TRIGGER_NAME1>,<TRIGGER_NAME2> Multiple triggers can be given as input with comma as separator. |
| For example, EC_TABLE_UIF_AIUDR,EC_TABLE_UIL_AIDR,EC_TAB LE_VI_AIUDR,EC_TABLE_ISU_AIUDR |
| Task | Task Description |
|---|---|
| DISABLE_TRIGGER | This can be used to disable one or more triggers. The trigger names are to be provided as input. Input Format: <TRIGGER_NAME1>,<TRIGGER_NAME2> |
| Multiple triggers can be given as input with comma as separator. | |
| For example, EC_TABLE_UIF_AIUDR, EC_TABLE_UIL_AIDR, EC_TABLE_VI_AIUDR, EC_TABLE_ISU_AIUDR | |
| HALT_DBMS_SCHEDULER_JOBS | This task will stop scheduled jobs that are currently running for data conversion. To view details of a scheduled job whether it is running or already completed, query the view V_DC_DBMS_SCHD_JOB_RUN_DETAILS using the APEX Data Viewer by prefixing the data conversion schema name. |
| Input Format:<JOB_NAME> Multiple jobs can be given as input with comma as separator. | |
| For example, DC_ITEM_LOC_11, DC_ITEM_LOC_12, DC_ITEM_LOC_13 | |
| DROP_BACKEDUP_TABLE | This task will drop backup tables previously backed up into the data conversion schema through the BACKUP_TABLE task. |
| Input Format: <TABLE_NAME> Multiple tables can be given as input with comma as separator. | |
| For example, BKPDC_113224_091120200259, BKPDC_113224_091120200319 | |
| DELETE TABLE STATS | This works similar to Merchandising DELETE_TAB_STATS.KSH batch. This truncates temporary tables and locks stats for performance.Input Format: Not required |
| DISABLE_PUBLISHING_TRIGGERS | This task disables all MFQUEUE publishing triggers. This should be run prior to the start of data conversion. To enable required publishing triggers post data conversion, execute ENABLE_TRIGGER task. Input Format: Not required |
| INIT_PUBLISHING | This task initializes the merchandising publishing tables. It clears MFQUEUE tables (if any data), populates PUB_INFO tables as needed and sets the published indicator to Y for the converted data. |
| This task should be run after completing conversion of data, prior to lift and shift. Input Format: Not required |
| Task | Task Description |
|---|---|
| STOCKLEDGER_PROCESSING | This task initializes the starting inventory totals in the stock ledger tables based on the stock on hand conversion. |
| Verify and align data in the following tables before you execute the task: • Period | |
| • System Variable • Week Data, Month Data and Half Data • Half Data Budget | |
| Input Format: <NO_OF_THREADS>;<RECALC_OPTION> | |
| It accepts two input parameters, | |
| • No of threads- This indicates the count of threads for parallel execution. | |
| • Recalc option- When set to ‘N’, it will process only records with non-zero stock on hand. This should be ’N’ when the task is executed for the first time. It should be set to ‘Y’, if you would like to recalculate the starting inventory totals after updating the stock on-hand to zero. | |
| UPDATE_DC_SYSTEM_OPTIONS | This task updates values in the DC_SYSTEM_OPTIONS table. The following fields can be updated using this task: • MASTER_PROCESS_ID • USE_RPM_DURING_MERCH_CONV • AUTO_GATHER_STATS • RECALCULATE_EXPENSES All these fields except MASTER_PROCESS_ID can be set ‘Y’ or ‘N’. For the MASTER_PROCESS_ID column, the allowed value is NULL and should be used when a mass upload process is terminated using a kill session option. In this case, DC_SYSTEM_OPTIONS.MASTER_PROCESS_ID would still have the old process id and this needs to be cleaned up before starting a new mass upload process. Input Format: < FIELD_NAME>;< FIELD_VALUE > Input is field name and value separated by semicolon, for example, MASTER_PROCESS_ID; NULL |
| DC_RPM_SEED_FUTURE_RETAIL | This task seeds the future retail values in Pricing for all active item/locations in the system at the time the process is run. Verify and align item/locations be-fore you execute the task, Input Format: <NO_OF_THREAD> |
| It requires total number of threads for parallel ex-ecution as the input parameter. |
Important Notes
-
The operations covered here should be invoked with caution by users with higher privileges. Some of these tasks might impact an on-going conversion run and should not be triggered when a data conversion is in progress. Similarly, conversions should not be run while these tasks are under execution.
-
Avoid any spaces in the input string to these tasks.
-
Maximum data length for the input string can up to 1000 characters. If required, break the activity into multiple calls to required tasks.
In this guide
- Guide: Merchandising Cloud Services Data Conversion Implementation Guide
- Previous: 7 Mock Conversions
- Next: A Appendix: Entity Sequence List
Related chapters
- I Appendix: Frequently Asked Questions — Merchandising Cloud Services Data Conversion Implementation Guide · shares
DC_SYSTEM_OPTIONS,MASTER_PROCESS_ID,UPDATE_DC_SYSTEM_OPTIONS,V_DC_DBMS_SCHD_JOB_RUN_DETAILS - 4 Prepare for Conversion — Merchandising Cloud Services Data Conversion Implementation Guide · shares
DISABLE_PUBLISHING_TRIGGERS,ENABLE_TRIGGER,INIT_PUBLISHING,PUB_INFO