Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Pricing VOs missing in BICC & OTBI - QP Pricing tables mapping not avail

Organization Name
Archrock Services LP
Description
Looks like the pricing tables do not have the related VOs mapping in OTBI. It really helps for creating pricing reports with VOs.
QP_CHARGE_DEFINITIONS_TL
QP_CUST_PRICING_PROFILES
QP_DENORM_MATRIX_RULES_VL
QP_DISCOUNT_LIST_ITEMS
QP_DISCOUNT_LISTS_ALL_B
QP_DISCOUNT_LISTS_TL
QP_MATRIX_DIMENSIONS_VL
QP_MATRIX_RULES
QP_PRICE_LIST_CHARGES
QP_PRICE_LIST_ITEMS
QP_PRICE_LISTS_ALL_B
QP_PRICE_LISTS_TL
QP_PRICING_STRATEGY_DETAILS
QP_PRICING_TERMS_VL
QP_STRATEGY_ASSIGNMENTS
Use Case and Business Need
Business Case:
Our business have few standard Price List reports written on current EBS database that uses below tables and also we have reports on the Price discounts and qualifiers information where business uses for PL Setup.
Additional Notes :
We are working on a project of converting our EBS reports and data warehouse reports to cloud with ADW & BICC. In order to create reports on pricing, we are unable to find the Pricing VOs in 20 C or 20 D.
HCM https://cloudcustomerconnect.oracle.com/posts/925646a5f0
FSCM https://cloudcustomerconnect.oracle.com/posts/c6614f9d47
CX https://cloudcustomerconnect.oracle.com/posts/3f1cae5e32
More details
Since VOs are not available in OTBI or BICC, we cannot build the reports and so it is painful as we have UAT starting soon.
Original Idea Number: 435ff2bc46