How Can One Obtain the Price List Name Based on the Price_List_Id Value Shown in a Debug File ? (Doc ID 2880584.1)

Last updated on JULY 05, 2022

Applies to:

Oracle iStore - Version 11.5.10.2 and later
Oracle Advanced Pricing - Version 11.5.10.2 and later
Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

Provide a query that will give the price list name from the price_list_id obtained from a debug file.

ASO Debug File Shows:

ASO validate cust_acct:p_cust_account_id 888045
ASO validate cust_acct:x_return_status S
18-MAY-2022 12:13:30 ASO Create_Quote: After call to validate_custaccount: x_return_status: S
18-MAY-2022 12:13:30 ASO Create_Quote: After call to Validate_Quote_Exp_date: x_return_status: S
ASO Validate_PriceList Begin: p_price_list_id: 19195285 <--------------------------------------------------------------------Price_list_id
ASO Validate_PriceList :mo_global.get_current_org_id 763
18-MAY-2022 12:13:30 ASO Create_Quote: After call to Validate_PriceList: x_return_status: E

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

How Can One Obtain the Price List Name Based on the Price_List_Id Value Shown in a Debug File ? (Doc ID 2880584.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!