My Oracle Support Banner

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 later
Information in this document applies to any platform.


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:

Invalid cost/retail combination passed to function STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT. Notify System Administrator.

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


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

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