In order to load XML requests from flat sequential files, comma separated value (CSV) files and from database tables, you need to create a staging control record. The name of this table is CI_XML_STG_CTL. The following table describes each column on this table.
Column Name | Length | Req'd | Data Type | Comments |
---|---|---|---|---|
XML_STG_CTL_ID | 10 | Y | N | This is the unique identifier of the record. This value does NOT have to be a random number, but it does need to be unique. |
RUN_DTTM | 26 | N | Date/Time | Date and time this record was executed. |
XAI_IN_SVC_ID | 10 | Y | A/N | This is the XAI service associated with this record. This service should have an adapter of CISStagingUpload. |
XML_STG_FILE_NAME | 250 | N | A/N | This is the location and name of the file containing the data to be uploaded. This is used for comma delimited files and flat sequential files. |
XML_INTFC_NAME | 30 | N | A/N | The name of the interface used to populate this table. This is simply information and is not used by the system. |
XML_STG_STATUS_FLG | 2 | Y | A/N | Must be set to P (Pending). |
NT_XID_CD | 30 | N | A/N | This field is not in use. |
NT_UP_XTYPE_CD | 30 | N | A/N | This field is not in use. |
USER_ID | 8 | Y | A/N | The ID of the user who created this record. |
COMMENTS | 254 | N | A/N | Use the free format comments, if necessary. |
NBR_RECORD_UPLD | 10 | N | A/N | Leave this blank. This will be populated by the process which creates upload staging records for this control record. |
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]