SIOCS POS TRANSACTION - Stock Of Packs Non-inv Does Not Change When The Sale Is Processed (Doc ID 3059897.1)

Last updated on NOVEMBER 25, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When a pack item that is non-inventoriable is part of a sale transaction, SIOCS does not update the SOH of its component items.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Pack: 208045022007

INVENTORIABLE = N


Stock of component before sale:

1. Perform a Sale transaction via RestWS

"transactions": [
{
"storeId": 405,
"transactionId": "405_208045022007_1",
"transactionTimestamp": "2024-11-16T16:00:00",
"externalUser": "Sample_User",
"items": [
{
"itemId": "208045022007",
"transactionCode": 1,
"quantity": 5,
"unitOfMeasure": "EA"
}
]
}
]
}

select * from pos_transaction where item_id = '208045022007' and store_id = 405 and EXTERNAL_ID = '405_208045022007_1';

-- PROCESSING_STATUS is 1 stock after sale integration


Stock after sale integration:

select item_id, store_id,  QUANTITY_TOTAL from store_item_stock where store_id = 405 and item_id in ( select COMPONENT_ITEM_ID from item_component where item_id = 208045022007);

Cause

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