Invalid Cost/retail Combination Passed To Function STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT Creating a Transfer
(Doc ID 2984273.1)
Last updated on OCTOBER 31, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and laterInformation in this document applies to any platform.
Symptoms
Invalid cost/retail combination passed to function STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT in TSF
When approving a transfer with 2 legs and using the functionality of packing in the transfer, it not possible to approve the transfer due to this error message:
ERROR
-----------------------
Invalid cost/retail combination passed to function STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT. Notify System Administrator.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create 2 regular items, orderable, sellable in approved status
2. Create a buyer complex pack with these 2 items (1 qty per component)
3. Add stock on the components
4. Create a tsf from WH to WH with an internal finisher.
5. In the detail tsf, you add these 2 components with the same qty.
6. Go in the menu packing and you populate the 2 components and the result is the complex pack
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |