Retail Merchandising System (MOSC)

MOSC Banner

Why since RMS v16 is not possible to create a receipt for a reconciled item?

in Retail Merchandising System (MOSC) 2 commentsAnswered

Previous versions (14,15) allowed the creation of a receipt for an item reconciled. RMS creates the records in tran_Data to reverse the reconciliation and adds the code 44.

Since v16, in the same scenario, the error: SHIP_ITEM_RECONCILED is raised by the program: RMSSUB_STKORD_RECEIPT_VALIDATE; nothing happens into TRAN_DATA table, but shipment.status_code changes to R-received.

v19 cursor:

cursor C_CHECK_RECEIPT is

select sh.shipment
from shipment sh,
shipsku sk
where sh.shipment = sk.shipment
and sh.bol_no = I_rib_receipt_rec.asn_nbr
and sk.item = I_rib_receiptdtl_rec.item_id
and sk.distro_no = I_rib_receipt_rec.po_nbr

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center