Oracle Cloud Fusion HCM Solutions

 Problem statement: How to identify when and who created an Absence Calculation Card.  SELECT DISTINCT     v.value_defn_id,     v.effective_start_date,     v.effective_end_date,     v.base_name,     v.value_group_id,     v.calc_type_id,     v.legislation_code,     v.legislative_data_group_id,     v.created_by,     v.creation_date,     v.last_update_date,     v.last_updated_by,     v.parent_value_defn_id,     v.source_id,     v.source_type,     v.dir_override_usage_id,     v.date_mode,     r.range_item_id,     r.effective_start_date range_item_eff_start_date,     r.effective_end_date   range_item_eff_end_date,     r.low_value,     r.high_value,     r.value1,     r.value2,     r.value3,     r.created_by  ...

Problem Statement: Costing information is not same as what is there in the element entry level. Element entry level is the lowest in costing hierarchy, which means if there is costing information at element entry level, calculate payroll process should reflect this information in costing details. It is not appearing. So, check the time when costing information was loaded in the system using below SQL: select sysdate,pcaa.cost_alloc_account_id ,pcaa.id_flex_num ,pcaa.cost_allocation_keyflex_id ,pcaa.proportion ,pcaa.segment1  ,pcaa.segment2  ,pcaa.segment3  ,pcaa.sub_type_sequence ,pcaf.source_id ,pcaa.creation_date ,pcaa.last_update_date ,pcaa.created_by ,pcaa.last_updated_by from pay_cost_alloc_accounts pcaa ,pay_cost_allocations_f pcaf where pcaa.cost_allocation_record_id=pcaf.cost_allocation_record_id and source_sub_type='COST' and pcaf.source_type='EE' and pcaf.source_id in (select pee.element_entry_id from per_all_people_f peo, pay_element_entries_f pee, pay_elemen...