Unable To Map Some Custom Pricing Attributes For 'ASO' To Use In iStore (Doc ID 427791.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle iStore - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Goal

Some mappings that work in Order Management do not work in iStore.
For example, attribute mappings based on a custom plsql package has following input parameters

OM Mapping (ONT):

XXXE_LIST_PRICE_MODIFIER_PVT.Get_XXXE_LIST_PRICE_MODIFIER(OE_ORDER_PUB.G_LINE.ship_to_org_id)

XXXE_QP_VARIANCE_PVT.Get_XXXE_QP_VARIANCE_VAL('VARIANCE J',OE_ORDER_PUB.G_LINE.inventory_item_id, OE_ORDER_PUB.G_LINE.header_id)



iStore Mapping (ASO):

XXXE_LIST_PRICE_MODIFIER_PVT.Get_XXXE_LIST_PRICE_MODIFIER(ASO_PRICING_INT.g_line_rec.ship_to_org_id)

XXXE_QP_VARIANCE_PVT.Get_XXXE_QP_VARIANCE_VAL('VARIANCE
J',ASO_PRICING_INT.g_line_rec.inventory_item_id, ASO_PRICING_INT.g_header_rec.header_id)

Build Attribute Mapping concurrent program errors out (see below) since ASO global variables
ASO_PRICING_INT.g_line_rec.ship_to_org_id and ASO_PRICING_INT.g_header_rec.header_id does not exists.

Error Message: ORA-06550: line 1, column 128:
PLS-00302: component 'SHIP_TO_ORG_ID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

What are the correct global variables to use from ASO_PRICING_INT.g_line_rec?

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