How To Create Custom Function Accepting The Po_advanced_price_pvt.g_hdr.shipment_header_id
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.
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.
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