Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Fetching duplicates in POST GL HCM extract
in HCM Extract
I am using the below user entities and build a Post GL extract. In this extract segments, Journal Credit and Debit details are used.
PAYROLL REL ACTIONS RANGE UE
ORA_PAY_COST_RESULT_UE
ORA_PAY_PAYMENT_COST_RESULT_UE
The extract is giving the duplicates. Filters should be added to restrict duplicates. Need suggestions in adding the extra filter to restrict duplicates
Below is the filter I am using.
1=1
and pep.person_number ='7385493'
and ppa.effective_date between PAY_REPORT_UTILS.GET_PARAMETER_VALUE_DATE('start_date') and PAY_REPORT_UTILS.GET_PARAMETER_VALUE_DATE('effective_date')
Tagged:
0