Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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
Comments
-
Data elements need to be added to PVO in BICC to enable access via ADW reporting
0 -
Data elements need to be added to PVO in BICC to enable access via ADW reporting
0 -
OTBI reporting for pricing setup is on our roadmap but not scheduled. Can you please provide some use cases and functional details on the types of reports that you wish to build.
0 -
Hi there,
Thank you for your idea. I am relocating it to our Transactional Reporting (OTBI) Idea Lab for proper review: https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary
Best,
Brendan J. Doyle
0 -
Good idea.
0 -
facing the same issue and looking for a solution, please.
0 -
Unfortunately, the page is not available
1 -
Is anybody from development looking at this Idea? It has been created almost 2 years ago.
Thanks
0 -
We have similar requirement to fetch price list information
0 -
Is there any update on this issue, please?
0
