EBS To OPSM Lot Sync Through AIA/PIP Errors (Doc ID 1585741.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Pedigree and Serialization Manager - Version 1.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 1.1.0 version

When attempting to perform a Lot Sync from the EBS Suite to Oracle Pedigree and Serialization Manager (OPSM) via AIA, the following error occurs. The Location.xml file was edited and placed under $PIP_HOME/DVM_XMLS.


ERROR
-----------------------
DVM Value is not found in LOCATION.dvm table

The XML Output shows the following:
The transaction was rolled back. The work performed for bpel instance "30029" was rolled back, but the audit trail has been saved for this instance.If this is a sync request, please resubmit the request from the client. If it is an async request, please recover from the recovery console by resubmitting the invoke message.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
• Create a lot.
• Login to SOA server and check for the instance of SyncItemLotListEbizReqABCSImpl BPEL component for the newly created lot.
• Verify the details in Audit trail. The error message can be seen in the invoke activity. Attached in the raw XML for the transaction.


Cause

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 hundreds of Community platforms