Introduction 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 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 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 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 MoreIntroduction: 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 MoreIntroduction 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 MoreIntroduction 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 MoreBelow 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 More