Source Type Code Custom Qualifier Suggestion
Business Requirements:....................................................................................................................... 2
Set profile values at user level: ........................................................................................................ 2
Create Qualifier for Source Type Code (Of the internal sales order line) ........................................... 2
Add the qualifier to the modifier(s) .................................................................................................. 7
Run QP: Maintains the denormalized data in QP Qualifiers for the modifier. .................................... 8
Retest the issue. .............................................................................................................................. 8
Business Requirements:
Need a method to apply specific modifiers to drop ship orders only
then have other modifiers only applied to the other orders/intercompany transactions.
Set profile values at user level:
QP: Pricing Transaction Entity = Intercompany Transaction
QP: Source System Code = Oracle Inventory
Create Qualifier for Source Type Code (Of the internal sales order line)
Responsibility: Oracle Pricing Manager
Navigate to: Setup > Attribute Management > Attribute Linking and Mapping
Do a Find on: Pricing Transaction Entity = Intercompany Transaction and Context Type: Qualifier Context
Place cursor on Code = ORDER and click on Contexts (button).
It should show a record for code = SOURCE_TYPE
Exit this form, to return to the previous form.
With cursor on Code = ORDER, Click on link attributes (button)
Add a record as follows:
click on attribute mapping (button)
under request type: IC, application name = Inventory
Save
Under request type: INTORG, application name = Inventory
add a record as follows:
Save.
Run build attribute mapping rules
From the tools menu, select build attribute mapping rules.
Add the qualifier to the modifier(s)
Query the modifier(s), click on the other tab
It should show pricing entity = INTCOM and source system code = INV
Click on the line qualifiers button to add the qualifier.
For Drop Ship:
For other orders:
Click OK (b). Save.
Run QP: Maintains the denormalized data in QP Qualifiers for the modifier.
Responsibility = Oracle Pricing Manager
Navigate: Reports
Select ‘single request’ then ‘OK’
Name: QP: Maintains the denormalized data in QP Qualifiers
Parameters:
Pick the modifer from the List of Values (LOV) as the low number
Pick the modifer from the List of Values (LOV) as the high number.
Update Type = ALL
Submit Request
Retest the issue.
KwS – Oracle 09-MAR-18