Preparing Legacy Data Extract for Upload
The legacy data mapping and extract will vary from one customer to another. The files created as a result of the extract process should conform to the specifications generated above. The resulting data extract files should be:
- Created according to the specifications
- Named according to the naming convention (see the online help and the specifications for more details)
- Optionally, the file might be compressed with gzip or zip (see the online help for details)
Special Data Considerations:
Oracle Utilities Cloud Services provide support for Information Lifecycle Management (ILM) and Data Archiving.
All ILM-enabled objects contain the following fields:
- ILM Date (ILM_DT)
- ILM Archive Switch (ILM_ARCH_SW).
The ILM and Data Archiving functionality is controlled by the combination of these two fields.
- The ILM Date field is used in conjunction with partitioning to group data by age.
- The ILM Archive Switch is set by a background process when a record meets the business rules specific to the record’s Maintenance Object that indicates the record is eligible to be purged.
See Information Lifecycle Management in the application’s Administrative User Guide
for more information about how these fields are used.
When preparing the legacy data extract for a target table, perform the following steps:
- Access the Oracle Utilities application, search for a Conversion Instructions Conversion Task Type (see Conversion Task Types in the Oracle Utilities Cloud Service Foundation Administrative User Guide) for the target table or maintenance object and review the input data specifications. Determine if the field list contains the fields named ILM_DT and ILM_ARCH_SW.
- In the data extract, populate the ILM_ARCH_SW field as follows:
- Set the field with a value of "Y" for high-volume tables. In specific, the ILM_ARCH_SW field MUST be set to "Y" for the following tables used with Oracle Utilities Customer Cloud Service and Oracle Utilities Meter Solution Cloud Service:
- D1_DVC_EVT (Device Event)
- D1_INIT_MSRMT_DATA (Initial Measurement Data)
- D1_USAGE (Usage Transaction)
- Set the field with a value of "N" for all other tables
- Set the field with a value of "Y" for high-volume tables. In specific, the ILM_ARCH_SW field MUST be set to "Y" for the following tables used with Oracle Utilities Customer Cloud Service and Oracle Utilities Meter Solution Cloud Service:
- For the ILM_DT field, the ILM Date Fields table below lists the recommended column whose value should be used to populate the ILM _DT for conversion data upload.
- Locate your target table name in the list and determine how the ILM_DT field should be populated
- If the table is not listed, please contact Oracle Utilities support.
ILM Date Fields
| Table Name | ILM DT Initial Load |
|---|---|
| CI_TD_ENTRY | CI_TD_ENTRY.CRE_DTTM |
| F1_SYNC_REQ_IN | F1_SYNC_REQ_IN.CRE_DTTM |
| F1_OUTMSG | F1_OUTMSG.CRE_DTTM |
| F1_SVC_TASK | F1_SVC_TASK.CRE_DTTM |
| F1_OBJ_REV | F1_OBJ_REV.STATUS_UPD_DTTM |
| F1_BUS_FLG | F1_BUS_FLG.CRE_DTTM |
| F1_REMOTE_MSG | F1_REMOTE_MSG.CRE_DTTM |
| F1_STATS_SNPSHT | F1_STATS_SNPSHT.CRE_DTTM |
| F1_ERASURE_SCHED | F1_ERASURE_SCHED.STATUS_UPD_DTTM |
| F1_PROC_STORE | F1_PROC_STORE.STATUS_UPD_DTTM |
| F1_GNRL_AUDIT | F1_GNRL_AUDIT.CRE_DTTM |
| D1_ACTIVITY | D1_ACTIVITY.CRE_DTTM |
| D1_COMM_IN | D1_COMM_IN.CRE_DTTM |
| D1_COMM_OUT | D1_COMM_OUT.CRE_DTTM |
| D1_DVC_EVT | D1_DVC_EVT.CRE_DTTM |
| D1_COMPL_EVT | D1_COMPL_EVT.CRE_DTTM |
| D1_INIT_MSRMT_DATA | D1_INIT_MSRMT_DATA.CRE_DTTM |
| D1_USAGE | D1_USAGE.CRE_DTTM |
| D1_USAGE_EXCP | D1_USAGE_EXCP.CRE_DTTM |
| D1_VEE_EXCP | D1_VEE_EXCP.CRE_DTTM |
| D1_ACTIVITY | D1_ACTIVITY.CRE_DTTM |
| CI_ADJ | CI_ADJ.CRE_DT |
| CI_APPR_REQ | MIN(LOG_DTTM) on CI_APPR_REQ_LOG for given APPR_REQ_ID |
| CI_BILL | CI_BILL.CRE_DTTM |
| CI_BSEG | CI_BSEG.CRE_DTTM |
| CI_STM | CI_STM.STM_DT |
| C1_OFFCYC_BGEN | C1_OFFCYC_BGEN.STATUS_UPD_DTTM |
| CI_BILL_CHG | CI_BILL_CHG.START_DT |
| CI_CASE | MIN(LOG_DTTM) on CI_CASE_LOG table for given CASE_ID |
| CI_FA | CI_FA.CRE_DTTM |
| CI_ENRL | CI_ENRL.START_DT |
| CI_PAY_EVENT | CI_PAY_EVENT.PAY_DT |
| CI_PAY | CI_PAY_EVENT.PAY_DT |
| CI_MATCH_EVT | CI_MATCH_EVT.CREATE_DT |
| C1_USAGE | C1_USAGE.CRE_DTTM |
| C1_CUST_REL_REQ | C1_CUST_REL_REQ.CRE_DTTM |
| CI_CC | CI_CC.CC_DTTM or CI_CC.LETTER_PRINT_DTTM |
| CI_MR | CI_MR.READ_DTTM |
| C1_PA_RQST | C1_PA_RQST.CRE_DTTM |
| C1_CS_RQST | C1_CS_RQST.CRE_DTTM |
| C1_CS_REQ_ACCT | C1_CS_REQ_ACCT.CRE_DTTM |
| C1_CS_REQ_CONT | C1_CS_REQ_CONT.CRE_DTTM |
| C1_CS_RQST_CONT_PROD | C1_CS_RQST_CONT_PROD.CRE_DTTM |
| C1_CS_REQ_PER | C1_CS_REQ_PER.CRE_DTTM |
| C1_CS_REQ_CVS_LOC | C1_CS_REQ_CVS_LOC.CRE_DTTM |
| C1_CS_REQ_PREM | C1_CS_REQ_PREM.CRE_DTTM |
| C1_MKTMSG_CHG | C1_MKTMSG_CHG.MKT_CHG_DT |
| C1_MKTMSG_PAY | C1_MKTMSG_PAY.MKT_PAY_DT |
| C1_MKTMSG_USG | C1_MKTMSG_USG.MKT_USG_DT |
| CI_FT | CI_FT.CRE_DTTM |
| CI_APPR_REQ | CI_ADJ.ILM_DT only when CI_ADJ.ILM_ARCH_SW='Y' |