How To Create Custom Function Accepting The Po_advanced_price_pvt.g_hdr.shipment_header_id

(Doc ID 2032917.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Landed Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

LCM_As_a_Service
 
po_advanced_price_pvt.g_hdr.shipment_header_id contains the ship_line_group_id for LCM advance price

Using LCM as a Service and calling Advanced Pricing to calculate charges. Created custom function accepting the po_advanced_price_pvt.g_hdr.shipment_header_id to retrieve information out of the INL_SHIP_HEADERS_ALL table for use in qualifying the charge.  User writes the parameter being passed in to the FND_LOG_MESSAGES table. The value recorded is 375757 for the shipment_header_id. The shipment header id should be 365140. User found the id of 375757 in the INL_SHIP_LINE_GROUPS table for the shipment user is working on pricing.

Found in package INL_CHARGE_PVT.Prepare_AndGetChargesFromQP has the following line of code setting the shipment header if to the ship line group id.

l_ship_ln_group_rec.shipment_header_id := p_ship_ln_group_tbl(i).ship_line_group_id;

The version information for INL_CHARGE_PVT is as follows:
$Header: INLVCHGB.pls 120.2.12010000.23
 
 The problem seems to be with the LCM package passing the incorrect value for the shipment header id into advance pricing.
 
Customer applied Patch 17601310:R12.INL.B (to get INLVCHGB.pls 120.2.12010000.36, which is the latest file version)
Same result as before. The shipment header id contains the ship line group id.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms