Using Depot Repair Global Variables for Advanced Pricing (Doc ID 1409827.1)

Last updated on MAY 15, 2023

Applies to:

Oracle Depot Repair - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:CSDREPLN.FMB - Repairs

Purpose

For 12.2+ and 12.1.3+ Users

The details of this note are now incorporated in the Release 12.2+ code and also backported to Release 12.1.3+. Select and set the “CSD: Use Global Variables For Advanced Pricing” profile option to yes to use global variables for Oracle Advanced Pricing.

For 11.5.10 Users

Refer to this document and follow the steps given in the sections, including the “Create new profile option” and the “Modify the Depot Repair Package that Retrieves the Price” sections.

'Out of the box' Depot Repair supports a limited number of pricing qualifiers to calculate the price through Advanced Pricing for items on logistics lines, Estimates and Actuals. These are implemented in the code specifically. These qualifiers can be used in the pricing modifier definition without the need to do any customization.

The seeded qualifiers are

Context	Attribute	Description in Depot
Customer	Customer Name	Customer Account Id
Customer	Party ID	Party ID
Customer	Customer Class	Customer Class
Order	Order Type	Order Type
Order	Line Type	Line Type
Order	Line Category Code	Line Category Code
Party Information	Sales Organization	Operating Unit

Additionally, Depot Repair APIs also populate a number of what are known as Global Variables. These are attribute values that will have a value within the pl/sql session that is trying to retrieve the price (i.e. when the user is entering the record in the form). They are not visible to the user, but they can be used in the advanced pricing setup.

The following attributes can be referenced as CSD_REPAIRS_PUB.G_LINE.<attribute name>.
For example, to access incident_id in the PLSQL code use CSD_REPAIRS_PUB.G_LINE.incident_id

Variable Name	Description
incident_id (Service Request ID)	Incident Id
repair_line_id	Repair Line Id
inventory_item_id	Inventory Item Id
unit_of_measure_code	Unit of Measure
quantity	Quantity
currency_code	Currency Code
account_id	Account Id
party_id	Party Id
bill_to_site_use_id	Bill to Site Use Id
ship_to_site_use_id	Ship to Site Use Id
customer_class	Customer Class
org_id	Operating Unit
order_type_id	Order Type Id
line_type_id	Line Type Id
line_category_code	Line Category Code
txn_billing_type_id	Transaction Billing Type Id
price_list_header_id	Price List Header Id
pricing_context	Pricing Context
pricing_attribute1 through pricing_attribute100	Attributes (1 to 100)

Though the APIs do populate these global variables, using them in the application so that they actually have impact on the price in Depot Repair cannot be done without some customizations.
This document describes the required setup (through a real business case), including customizations that have to be built.

This functionality using Global Variables is currently available on the latest patch levels as the global variables need to be declared in API CSD_REPAIRS_PUB (csdpdras.pls) and populated in CSD_PROCESS_UTILget_charge_selling_price (csdvutlb.pls)

for 11.5.10: Patch 7553775 ROLLUP PATCH FOR BUG FIXES BETWEEN DATES 07-OCT-2008 TO 15-DEC-2008
(<Patch 7356794> - ROLLUP PATCH FOR BUG FIXES BETWEEN DATES 01-OCT-2008 TO 15-OCT-2008 contained the original fix, but this patch has been superseded)
Check to ensure the following (or later) file versions are in use:
csdprdras.pls 115.21.11510.6
csdvutlb.pls 115.71.11510.30
for 12.1.3: Patch 19989456:R12.CSD.B ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (02-DEC-14)
(<Patch 19835304:R12.CSD.B> - ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (07-NOV-14) contained the original fix, but this patch has been superseded)
Check to ensure the following (or later) file versions are in use:
csdpdras.pls 120.22.12010000.10
csdvutlb.pls 120.33.12010000.36
for 12.2.3+: Patch 19906663:R12.CSD.C - ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (17-NOV-14)
csdpdras.pls 120.27.12020000.4
csdvutlb.pls 120.48.12020000.11

Scope

The information in this document assumes advanced knowledge of setting up e-Business Suite and additionally using tools to implement PL/SQL.

The information, software, products and services contained in this article may be out of date or include omissions, inaccuracies or other errors. The information, software products and services contained on this web site, including the materials, are provided "as is" and without warranty. Oracle does not warrant that the information in the materials is up to date or error free, nor does it provide any other warranties, whether expressed or implied in law, including the implied warranties of merchantability or fitness for a particular purpose. The materials are not a program or documentation under the terms of your license agreement(s) with Oracle.

In no event shall Oracle be liable for any direct, indirect, incidental, special or consequential damages, or damages for loss of profits, revenue, data or use, incurred by you or any third party, whether in an action in contract or tort, arising from your access to, or use of, this web site or any other hyperlinked web site.

Oracle reserves the right to make changes or updates to this article or the products or programs described in this web site at any time without notice.