Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVO
Summary:
We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVO for default column list, the extract data file has duplicate data set.
This PVO has two Primary key column , which are mentioned below
Primary Key Column
>> TimeEntryTimeRecordVersion
>> TimeEntryTimeRecordId
We have found the same information in Rel13_22.x_BICC_HCM_Database_Mapping_with_ViewObjects (https://community.oracle.com/customerconnect/discussion/47653/r13-x-hcm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping-spreadsheet) document.
Content (required):
Version (include the version you are using, if applicable):
22A
Code Snippet (add any code snippets that support your topic, if applicable):
0