Bulk Load JSON Configuration

The Bulk Load JSON configuration drives the bulk load process. You get an indication for various load configurations, location of the CSV files, field names in the CSV files, and so on.

The configuration contains a main section defining the following parameters:

oracleDirectoryName Logical directory name for oracle. The name will be FSI_BULK_DIR.
timeStampFormat Timestamp format that will be used by the CSV exported data. Timestamps follows the oracle notation. Sample format is "DD-MON-YYYY HH12.MI.SS PM". Example value: "01-JAN-2014 05.40.12 PM
commitSize Frequency of commits when performing creation.
entities List of entities to load.

Each entity to load is a configuration object containing:

type The type of entity to load. Options are:
  • FSI_PARTY
  • FSI_PARTY_CHARACTERISTIC
  • FSI_ITEM
  • FSI_ITEM_CHARACTERISTIC
  • FSI_ITEM_RELATIONSHIP
  • FSI_ITEM_ORDER
  • FSI_ITEM_ORDER_COMMENT
dataSourceName The name of the CSV file relative to the inside of the FSI_BULK_DIR directory
dataSourceColumnList The names of the columns in the CSV file. The possible values depend on the type of entity to load. Some columns are mandatory, some are optional.
Entity Type Mandatory Columns Optional Columns
FSI_PARTY ID(VARCHAR2), PARTY_TYPE(VARCHAR2), STATUS(VARCHAR2), OWNED_BY(VARCHAR2), CREATED_BY(VARCHAR2), CREATED_ON(TIMESTAMP(6)), VERSION(NUMBER), DELETED(NUMBER) (0 for not deleted, 1 for deleted) PARTY_REF(VARCHAR2), NAME(VARCHAR2), SUB_TYPE(VARCHAR2), PARENT_PARTY_ID(VARCHAR2), UPDATED_BY(VARCHAR2), UPDATED_ON(TIMESTAMP(6))
PARTY_CHARACTERISTIC ID(VARCHAR2), PARTY_ID(VARCHAR2) (the party to relate to), CHARACTERISTIC_NAME(VARCHAR2), CHARACTERISTIC_VALUE(VARCHAR2),
ITEM ID(VARCHAR2), PRODUCT_ID(VARCHAR2), ITEM_TYPE(VARCHAR2), STATUS(VARCHAR2), PARTY_ID(VARCHAR2), START_DATE(TIMESTAMP(6)), OWNED_BY(VARCHAR2), CREATED_BY(VARCHAR2), CREATED_ON(TIMESTAMP(6)), VERSION(NUMBER), DELETED(NUMBER) (0 for not deleted, 1 for deleted) ITEM_REF(VARCHAR2), PRODUCT_VERSION(VARCHAR2), NAME(VARCHAR2), SUB_TYPE(VARCHAR2), END_DATE(TIMESTAMP(6)), UPDATED_BY(VARCHAR2), UPDATED_ON(TIMESTAMP(6))
ITEM_CHARACTERISTIC ID(VARCHAR2), ITEM_ID(VARCHAR2) (the item to relate to), CHARACTERISTIC_NAME(VARCHAR2), CHARACTERISTIC_VALUE(VARCHAR2)
ITEM_RELATIONSHIP ID(VARCHAR2), ITEM_ID(VARCHAR2) (the item to relate to), FORWARD_TYPE(VARCHAR2), REVERSE_TYPE(VARCHAR2), CHILD_ITEM_ID(NUMBER) (the child item to relate to),
ITEM_ORDER ITEM_ID(VARCHAR2) (the item to relate to), ID(VARCHAR2), ORDER_REF(VARCHAR2), ORDER_DATE(TIMESTAMP(6)), LINE_NUMBER(VARCHAR2), LINE_ACTION(VARCHAR2) LINE_ACTION_MODE(VARCHAR2), PLAN_ITEM_ID(VARCHAR2), PLAN_ITEM_ACTION(VARCHAR2)
ITEM_ORDER_COMMENTS ORDER_ID, COMMENT_DETAIL