HCM VOs missing in BICC & OTBI - HCM/Pay Cost tables mapping not available

User_0NZKD

Organization Name

Archrock Services LP

Description

Looks like the pay cost tables do not have the related VOs mapping in OTBI. These tables need the related VOs for some of critical HCM reports.

HR_OPERATING_UNITS 
pay_cost_allocation_keyflex
pay_cost_allocations_f

 

Use Case and Business Need

Business Case :

We have some of our Operations reports in Field service and service contracts uses the below EBS tables and columns today for the reporting/data modelling. 

From HR_OPERATING_UNITS  we need below columns.

 

   BUSINESS_GROUP_ID,

   ORGANIZATION_ID,

   SHORT_CODE,

   SET_OF_BOOKS_ID,

 

From pay_cost_allocations_f we need below columns

   COST_ALLOCATION_ID,

   EFFECTIVE_START_DATE,

   EFFECTIVE_END_DATE,

   BUSINESS_GROUP_ID,

   COST_ALLOCATION_KEYFLEX_ID,

   ASSIGNMENT_ID,

 

From pay_cost_allocation_keyflex we need below columns

   COST_ALLOCATION_KEYFLEX_ID,

   CONCATENATED_SEGMENTS,

   ID_FLEX_NUM,

   SUMMARY_FLAG,

   ENABLED_FLAG,

   START_DATE_ACTIVE,

   END_DATE_ACTIVE,

   SEGMENT1,

   SEGMENT2,

   SEGMENT3,

   SEGMENT4,

   SEGMENT5,

   SEGMENT6,

   SEGMENT7,

   SEGMENT8,

   SEGMENT9,

   SEGMENT10 

Additional Notes:

We are working on a project of converting our HR reports reports to cloud with ADW & BICC. In order to create reports on HCM, we are unable to find the HCM VOs in 20 C or 20 D as mentioned above.

 

 

More details

Current BICC 20 D document missing the above mentioned tables.

HCM https://cloudcustomerconnect.oracle.com/posts/925646a5f0

 

Original Idea Number: fd45b77b9a

Christine Mink-189236

Data elements need to be added to PVO in BICC to enable access via ADW reporting

Brendan Doyle - Oracle

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