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 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 MoreIntroduction 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 MoreIntroduction This Post illustrates the steps required to update the profile value –SSO to LOCAL through API in Oracle EBS R12 Script to through API Update Profile Value – SSO to…
Read MoreIntroduction This Post Is About How to Delete Stuckked/corrupted Lock Box Transmission format. Script to Delete Stuckked/corrupted Lock Box Transmission format :- select * from APPS.AR_TRANSMISSIONS_ALL where TRANSMISSION_NAME=’IMCC161107′;…
Read MoreIntroduction This Post illustrates the steps required to get Profile Option Values at Responsibility level in Oracle EBS R12 Script to get Profile Option Values at Responsibility level SELECT frv.responsibility_name, fpo.profile_option_name, fpot.user_profile_option_name,…
Read MoreIntroduction This Post is about to Convert Comma Separated Values into Table using WITH CSV’ REGEXP_SUBSTR.’ AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD,MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char…
Read MoreIntroduction This Post is about to Update Customer Account in TCA R12. Script to Update Customer account in TCA R12. DECLARE p_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; p_object_version_number NUMBER; x_return_status …
Read More