Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Data Augmentation for contract history
Hello,
Both of these PVO don't give the history of a contract for a data augmentation :
HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVO
HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVOViewAll
I need to have in the adw the history of the contract, especially the field ContractPEOType.
I checked in HCM though BI Publisher and I can see the history in PER_CONTRACTS_F.
1 - Is there a way to get the history from any PVO or what is the best solution for me to get the history from PER_CONTRACTS_F ?
2 - Is it possible to create a data augmentation directly on PER_CONTRACTS_F ?
Thanks by advance
Answers
-
Hi @User_HLD1R have you enabled the Employment Contracts subject area ?
Raghu
0 -
Hi @Raghavendra Raghunath-Oracle
Thank for your answer.
Yes I enabled Employment Contracts subject area and I checked following tables but still don't see any history :DW_WRKFRC_CONTRACT_EVENT_EF
DW_WRKFRC_CONTRACT_DURATION_D_TL
DW_WRKFRC_CONTRACT_TYPE_D_TLThat's the reason why I am trying to do a data augmentation.
Is it normal ?
0 -
@User_HLD1R , you are right these PVOs are exposing the current contract rows and does not show history.
HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVO
HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVOViewAll
You should explore full extract using custom BICC extract on PER_CONTRACTS_F. Hope it helps!
0 -
Hi @User_HLD1R The subject area HCM - Employment Contracts is designed to fetch history records. Can you build a report like this and test?
Raghu
0
