Processes/Central Order Processing Agent

Step 1 · Oracle extract

Oracle NetSuitemore context needed

Extract delivery and pick details

Export PO, LPN, NDC, lot, quantity, and pack-confirm status for targeted deliveries.

Step 2 · TraceLink extract

TraceLinkmore context needed

Extract serialized outbound details

Retrieve serialized delivery data needed for reconciliation against Oracle extracts.

Step 3 · Readiness check

TraceLinkmore context needed

Validate pack-confirm prerequisites

Block reconciliation for deliveries containing unconfirmed LPNs.

Step 4 · Condition 1

TraceLinkmore context needed

Compare LPN and pallet serial parity

Identify missing and extra LPNs across systems and classify mismatch type.

Step 5 · Condition 2

TraceLinkmore context needed

Validate NDC + lot + LPN quantity match

Reconcile quantity aggregation at LPN granularity and capture overage/shortage deltas.

Step 6 · Reporting

TraceLinkmore context needed

Publish reconciliation report and exception queue

Export summary metrics and line-level mismatch details for COP and serialization follow-up.