Modifier Using INV_IC_ORDER_PUB.G_LINE.FROM_ORGANIZATION_ID Is Not Being Applied For Intercompany Invoicing

(Doc ID 1630526.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Advanced Pricing - Version 12.0.0 and later
Oracle Inventory Management - Version 12.0.0 and later
Information in this document applies to any platform.
INCIAR - Intercompany Invoicing
WSHINTERFACE module: Interface Trip Stop

Symptoms

On : 12.1.3 version, Pricing Engine

ACTUAL BEHAVIOR
---------------
Finds that when using a custom product attribute on a modifier, it does not apply on intercompany transfer price

The custom product attribute is setup under product context = Inventory Level
  with attribute mapping for Request type: IC: Inter Company Invoicing and application name: Inventory
  as user source type: PL/SQL
  and user value string: XXST_COMMON.GET_INV_LEVEL(INV_IC_ORDER_PUB.G_LINE.INVENTORY_ITEM_ID,INV_IC_ORDER_PUB.G_LINE.FROM_ORGANIZATION_ID)

EXPECTED BEHAVIOR
-----------------------
Expects this modifier to apply on the intercompany transfer price

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.) Create internal requisition
2.) Run create internal orders
3.) Run order import
4.) Pick release internal order
5.) Ship confirm internal order
6.) Run Interface Trip Stop to calculate intercompany transfer price

Modifier Additional Notes
=====================

1) uses a custom product attribute defined for intercompany invoicing.
  the inventory item and "from_organization_id are passed in as parameters
  the custom function returns the type of product (either RAW or FG or Sub Assy)
  Assigned to Inventory_Items Pricing_attribute40

2) Modifier is setup with this product attribute and qualified by the Shipping OU and Selling OU

3) Price List uses formula (GET_CUSTOM_PRICE = formula name)
  formula: NVL(1,2)*3
  step 1 function GET CUSTOM PRICE
  step 2 numeric constant = 0
  step 3 numeric constant = 1


4) Modifier that does not have the custom product attribute and do work fine:
  MX_US

5) Modifiers that do have the custom product attribute and do NOT work fine:
  MX_NL
  MX_NL_RAW

6) Modifiers only have line qualifiers
  Even though the Modifier details report tends to indicate multiple qualifiers for selling OU / Shipping OU in grouping number = -1
  this is not the case shown live. Only one in grouping nbr -1 (Shipping OU) and one in grouping number = 1 (Selling OU).




BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Client is not able to distinguish between finished and raw materials when applying the intercompany price mark-up.
They price based on how the product is transferred as it can be a markup (surcharge) or a discount.
The determining factor is the value for the Shipping Operating Unit (OU) and the value for the OU sold to (Selling Operating Unit).
Now they wish to add one more condition to how products are priced.
They wish to markup differently based on whether the item is a finished good (FG), raw material (RAW) or a sub assembly (Sub Assy).

Cause

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