Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need BICC PVO to extract data for billing reports

21
Views
1
Comments

Organization Name

KPMG Belgium

Description

Please provide PVO's for following tables : 

PJF_RATE_SCHEDULE_LINES (not only RateScheduleID and RateScheduleName, but columns like RATE, START_DATE_ACTIVE, END_DATE_ACTIVE, PRVDR_ORGANIZATION_ID, RECVR_ORGANIZATION_ID, NL_PERCENTAGE _APPLIED, TP_AMT_TYPE_CODE,...)
PJF_RATE_SCHEDULES_TL
PJB_BILL_RATE_OVRRDS
PJB_BILL_PLANS_TL (BILL_PLAN_DESC
PJB_BILL_PLANS_B (BILL_TYPE_CLASS_CODE, EMP_BILL_RATE_SCH_ID, NL_BILL_RATE_SCH_ID, JOB_BILL_RATE_SCH_ID, ....

Use Case and Business Need

We really need these PVOs to extract data for our external data warehouse. We are blocked because of it.

Original Idea Number: 9fbbf7e7dc

3
3 votes

Submitted · Last Updated

Comments