1. Integration Playbooks for SCM
  2. Reconcile External On-Hand Balances

Reconcile External On-Hand Balances

The external system uses the inventory snapshot to compare balances and identify mismatches.

Here are the steps involved:

  1. Retrieve and import the generated ZIP file from WebCenter Content.

    Oracle Integration Cloud identifies and downloads the correct ZIP file from WebCenter Content for the reconciliation cycle and the selected external system. The external system then imports the published on-hand balance snapshot generated by Oracle Inventory Management for the selected organization and item population.

  2. Extract, validate, and prepare the pipe-separated values file.

    Oracle Integration Cloud extracts the snapshot file from the ZIP archive and validates that it is present, readable, and formatted as expected.

  3. Transform and deliver the data to the external system.

    Oracle Integration Cloud transforms the published inventory on-hand data into the format required by the external system, then delivers it through the agreed mechanism, such as an API call, staged file, or downstream reconciliation process trigger.

  4. Reconcile external balances against Oracle Inventory Management.

    The external system compares its local balances with the Oracle Inventory Management snapshot.

  5. Identify and resolve discrepancies.

    The external system presents the mismatches, interface errors, and unprocessed records to users for review. Users investigate and resolve differences through the agreed customer-defined operational process. Oracle Inventory Management acts as the source for the published on-hand balance snapshot.

  6. Handle errors and prevent duplicate processing.

    Capture failures for the WebCenter Content file download, ZIP extraction, file validation, transformation, delivery, import, and reconciliation. Include the scheduled process request, WebCenter Content file details, external system identifier, and reconciliation cycle in operational logs. Record processed file metadata or archive completed files so the same snapshot is not processed more than once.

  7. Track reconciliation status.

    Maintain status for each reconciliation cycle, including imported records, matched records, discrepancies, errors, unprocessed records, and completion status.