My Oracle Support Banner

No Record Is Inserted in DSD Table After the ASNIn Message Is Processed (Doc ID 2420856.1)

Last updated on NOVEMBER 01, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.1 and later
Information in this document applies to any platform.


In Oracle Retail Store Inventory Management (SIM), Direct Store Delivery (DSD) ASNIn messages are marked as processed in the MPS_STAGED_MESSAGE table, but no record is inserted into DSD table.

Steps to Recreate:

1. Create a valid ASNIn message for a DSD Purchase Order (PO).
2. Check MPS_STAGED_MESSAGE table and make sure that the message was processed.
2. Query DSD table for the ASN. Note that there is no record for the ASN in the DSD table.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.