Introduction This Post illustrates the steps required to retrieve GL Journal Import in Oracle EBS R12. Script to retrieve GL Journal Import SELECT glc.segment1 || ‘-‘ || apps.gl_flexfields_pkg.get_description_sql (glc.chart_of_accounts_id,…
Read MoreIntroduction This Post is about Active Users/Employee Details and their Active responsibilities find Query Script to Active Users/Employee Details and their Active responsibilities find Query. SELECT fu.user_name, PAPF.FIRST_NAME||PAPF.LAST_NAME Employee_Name,…
Read MoreIntroduction This Post illustrates steps required to Load JSON File to Oracle table in Oracle EBS R12. For Example : 1) Sample JSON:- { “department”: { “department_number”: 10, “department_name”: “ACCOUNTING”, “employees”:…
Read MoreQuery to get employee details who are not submitted the iExpense details for approval Introduction This post is about to get employee details who are not submitted the iExpense…
Read MoreIntroduction This Post is about to Map Member Functions For Multiset Operations in Oracle EBS R12.MAP member functions are special functions used to compare objects. The MAP member functions are used…
Read MoreBelow is a Sample Formula showing How to Call a Fast Formula from another Formula : DEFAULT FOR ASG_HR_ASG_ID is 0 DEFAULT FOR PAY_EARN_PERIOD_END is ‘4712/12/31 00:00:00’ (date) SET_INPUT(‘HR_ASSIGNMENT_ID’,ASG_HR_ASG_ID) v_asg_id =…
Read MoreIntroduction This Post illustrates the steps required for Auto Apply given receipts to Invoices Script to Auto Apply given receipts to invoices. CREATE OR REPLACE PACKAGE BODY APPS.XX_RECEIPT_APPLICATION_PKG IS PROCEDURE MAIN( errbuf …
Read MoreIntroduction: This Post illustrates the steps required to Sales Order Loader API from Blanket Sales Agreement in Oracle EBS R12 Script to Sales Order Loader API from Blanket Sales Agreement CREATE OR…
Read MoreIntroduction 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 MoreIntroduction 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 More