You are browsing the archive for Oracle Advanced Pricing.

by oracleguru

Attribute Mapping Rules Error Report

ORACLE APPS COMMUNITY > Tutorial > Order Management > Oracle Advanced Pricing

Accrual Mapping Rules Error Report provides all the errors associated with pricing attributes.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘Attribute Mapping Rules Error Report’ -> Enter the parameters.

Attribute Mapping Rules Report

Report Parameters:

  • Request Type: Select any one from list of values or leave it blank to run the report for all values.

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the request output.

If no errors found then output shows a message ‘NO ATTRIBUTE MAPPING RULES ERROR(S) FOUND’. Other wise output shows the list of errors.

Tags: No Comments »

by oracleguru

Accrual Details Report

ORACLE APPS COMMUNITY > Tutorial > Order Management > Oracle Advanced Pricing

Accrual Details Report provides the details of all accruals for coupons issued through advanced pricing. Coupons are discounts issued to customers for a future purchases. This report helps us in tracking the coupons issued versus coupons reimbursed.

Navigation:

Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘Accrual Details Report’ -> Enter the parameters.

Accrual Details Report

Accrual Details Report

Report Parameters:

  • Modifier Name From:
  • Modifier Name To:
  • Start Date Active:
  • End Date Active:
  • Qualifier Context:
  • Qualifier Attribute Value From:
  • Qualifier Attribute Value To:

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the request output.

Accrual Details Report

Accrual Details Report

Tags: No Comments »

by oracleguru

Advanced Pricing Concurrent Programs

ORACLE APPS COMMUNITY > Tutorial > Order Management > Oracle Advanced Pricing

Oracle Advanced Pricing Concurrent Programs:

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
OECMWC Create dynamic where clauses
OEPAII Add inventory items to a price list
OEPCPL Copy/modify price lists
OEPMLP Maintain price lists
OEXOEAHR Agreement Report – Detail
OEXPRDIS QP_DISCOUNT_DETAIL_LISTING_OBS
OEXPRDPC Pricing Columns Listing
OEXPRITG Pricing Item Group Listing
OEXPRLST QP_PRICE_LIST_LISTING_OBS
OEXPEMCE Price List Impact – Configuration Edits
OEXPRPFC Pricing Formula Components Listing
OEXPRRUL QP_PRICING_RULE_LISTING_OBS
QPXVCPLB Copy Price List
QPXVAPLB Adjust Price List
QPXVURPB Update Rule Prices
ADDITEMS Add items to Price List
QPXPRRUL Pricing Rules Listings
QPXPRLST Price List Listings
QPXPRDIS Discount Detail Listings
QPXCRORD Cross Order Volume Report
QPXPSRCB Builds attribute mapping rules for attribute mapping
QPXVUFPB Update Formula Price
QPXPRQFS Qualifier Grouping Report For QP
QPXPRFOR Pricing Formulas Report For QP
QPXPRCST Price Lists Report For QP
QPXPRMLS Modifier Details Report for QP
QPXCOVLB Loads Cross Order Volume Data
QPXPACRL Accrual Details Report for QP
QPXDENOB Maintains the denormalized data in QP Qualifiers
QPXVCPMB Copy Modifiers
QPXTRANB Update Promotional Limit Balances
QPXDLDBB Purge Pricing Engine Requests
QPXPFORB Builds formula package that evaluates the formula.
QPXMCUPD Update Price Lists with Multi-Currency Conversion Criteria
OEXPRPRS Order Discount Summary Report
OEXPRPRD Order Discount Detail Report
OEXOEASR Agreement Activity Report
QPXPSRCB2 Concurrent program to produce an error report for attribute mapping rules
QPXPERFO Performance Analysis Script
QPXDEBUG List Line Detail Debug Script
QPXARCVB Archive Entity
QPXPURGB Purge Pricing Entity
QPXVATG Pattern Upgrade
QPXVBLK QP: Bulk import of Price List
QPXICNUP Java Pricing Engine Interface Tables Cleanup
QPXJCCWU QP: Java Pricing Engine Warm Up
QPXJCCDS QP: Java Pricing Engine Data Synchronization
QPXJCCVB-M QP: Java Pricing Engine Cache Manager
QP_BLK_LOAD_UPG_PA_WKR QP: Upgrade Pricing Attributes for Bulk Loader 12.0 (Secondary)
QP_BLK_LOAD_UPG_QUAL_WKR QP: Upgrade Price List Qualifiers for Bulk Loader 12.0 (Secondary)
QP_BLK_LOAD_UPG_LINE_WKR QP: Upgrade Price List Lines for Bulk Loader 12.0 (Secondary)
QP_BLK_LOAD_UPG_HDR_WKR QP: Upgrade Pricing Data Header for Bulk Loader 12.0 (Secondary)
QP_BLK_LOAD_UPG_PA_MGR QP: Upgrade Pricing Attributes for Bulk Loader 12.0
QP_BLK_LOAD_UPG_QUAL_MGR QP: Upgrade Price List Qualifiers for Bulk Loader 12.0
QP_BLK_LOAD_UPG_LINE_MGR QP: Upgrade Price List Lines for Bulk Loader
QP_BLK_LOAD_UPG_HDR_MGR QP: Upgrade Pricing Data for Bulk Loader
QPXSECCB Security Control to turn Pricing Security On/Off
QPXPRBKB Price Book Generate and Publish
QPXPRFCB Performance Control
QPXJPECB Switching Pricing Engine type between PL/SQL and Java
QPXPACRL_XML Accrual Details Report for QP
QPXPRCST_XML Price Lists Report For QP
QPXPRFOR_XML Pricing Formulas Report For QP
QPXPRMLS_XML Modifier Details Report for QP
QPXPRQFS_XML Qualifier Grouping Report For QP

Tags: No Comments »