RESA Revisions Sales Fails With An Error In SIM "Unable To Find Valid Processed Transaction" (Doc ID 3022814.1)

Last updated on MAY 15, 2024

Applies to:

Symptoms

Issue when processing sales revisions from RESA into SIM.

when we have a sale sent by POS with an item that later stays in error in SIM and RESA with "Invalid Unit of Measure" and after fixing the problem in RESA, revision is sent to SIM but the revision transaction stays in error with 'Unable to find valid processed transaction"

The same occures when POS Sents a sale with an invalid ITEM that is later changed or corrected in RESA, The transaction revision arrives SIM and does not take in consideration the new item that came to replace the wrong one and transaction stays in ERROR with 'Unable to find valid processed transaction"

ERROR
-----------------------
 'Unable to find valid processed transaction"




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 - Create a sale in POS for an item with invalid UOM (UOM different than the one defined in SIM and RMS)
2 - Send the sale to SIM via Webservice
3 - Send the sale to RESA via RTLOG
4 - Note that sale stays in error in SIM and RESA with Invalid UOM message error
5 - Fix the sale in RESA and correct the UOM of the item in the sale
6 - Note that Transaction is ok in RESA and ready to be exported do RMS
7 - Export to RMS, note TRAN_DATA and stock is updated
8 - Revision was sent to SIM and is now on POS_TRANSACTION
9 - Note that revision transaction is in error (processing_Status = 2) with the error Unable to find valid processed transaction'


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process sales revisions from RESA into SIM.

Cause

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