Fusion HCM – Getting HR Data in Fast Formula
Introduction This Post illustrates the steps required to get the hr data in fast formula-Fusion HCM Script to get the hr data in fast formula-Fusion HCM To get HR Data in…
Read MoreFusion HCM – Query for Absence Accrual Balance
Introduction This Post illustrates the steps required to Absence Accrual Balance-Fusion Application Script to Absence Accrual Balance-Fusion HCM SELECT peo.person_number emp_id, aapft.NAME absence_plan_name, acc_ent.end_bal balance FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name,…
Read MoreFusion HCM – Query for OTL Time Entries Details
Introduction This Post illustrates the steps required to OTL Time Entries Details in Fusion Application Script to OTL Time Entries Details – Fusion HCM SELECT papf.person_number emp_id, TO_DATE (TO_CHAR (sh21.start_time, ‘DD/MM/YYYY’),…
Read MoreAPI to Check Item On-hand Quantity for Specific Inventory Organization
Introduction This Post is about to Check on hand Quantity For Specific Inventory Organization in Oracle EBS R12. Script to Check on hand Quantity for specific inventory Organization API…
Read MoreFusion HCM – Query for Personal Payment Method Details
Introduction: This Post illustrates the steps required to get Personal Payment Method Details in Fusion HCM Script to Personal Payment Method Details in Fusion HCM SELECT per_pay.* FROM per_all_people_f peo,…
Read MoreQuery to Element Entry Details in Fusion Application(HCM)
Introduction This Post illustrates the steps required to Element Entry Details in fusion Application Script to Element Entry Details in Fusion Application SELECT * FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service…
Read MoreSales Order Dispatch details (Link between Material Transactions and Invoice)
Introduction This Post is about to Sales Order Dispatch details (Link between Material Transactions and Invoice) in Oracle EBS R12. Script to Sales Order Dispatch details (Link between Material…
Read MoreOpen Purchase Order Details(Standard Po)
Introduction This post is about to Open Purchase Order Details(Standard Po) in Oracle EBS R12. Script to Open Purchase Open Details (Standard PO) SELECT poh.type_lookup_code source_type, prh.segment1 pr_number,…
Read MoreQuery to Calling a Value Set in Fast Formula-fusion HCM
Below is a Sample Formula shows How to Call a Value set in Fast Formula : Inputs are hr_id (number), eff_st_date(text), eff_end_date(text), mode (text) l_hr_per_id = hr_id l_eff_st_date =…
Read MoreHow to Extract All the Asset Categories Book Wise with all Code combinations.
Introduction This post is about How to Extract All the Asset Categories Book Wise with all Code Combinations in Oracle EBS R12. Script to Extract All the Asset Categories…
Read More