Oracle Business Intelligence Applications

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

Time Card Status

Received Response
21
Views
1
Comments
Rank 1 - Community Starter

Hi everyone,

I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying to add the BEFORE CHANGE and AFTER CHANGE status. However, I cannot find any table which has the columns I need. I am currently using the tables HWM_TM_STATUSES, HWM_TM_STATUS_DEF_B, HWM_TM_STATUS_DEF_TL but none of them consists the BEFORE CHANGE and AFTER CHANGE COLUMN statuses. Here is the screenshot of the front-end value of I am trying to code in BIP. Navigation is MY CLIENT GROUPS>TEAM TIME CARDS


If anyone has worked on the same BIP report, please share your input here. Thank you so much.

Regards,

Candy Miles

Tagged:

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.