Yearly Archives: 2021

Fusion HCM Query to Fetch Payroll Details

SELECT papf.payroll_name, papf.period_type, pcs.consolidation_set_name, ptp.period_name, to_char(ptp.start_date, ‘YYYY/MM/DD’) start_date, to_char(ptp.end_date, ‘YYYY/MM/DD’) end_date, to_char(ptp.cut_off_date, ‘YYYY/MM/DD’) cut_off_date, to_char(ptp.regular_earn_date, ‘YYYY/MM/DD’) date_earned, to_char(ptp.regular_process_date, ‘YYYY/MM/DD’) payroll_run_date, to_char(ptp.default_paydate, ‘YYYY/MM/DD’) date_paid FROM pay_all_payrolls_f papf, pay_time_periods ptp, pay_consolidation_sets pcs…

Read More

Fusion HCM Query to Fetch Assignment Details

SELECT papf.person_number, ppnf.full_name employee_full_name, ppnf.first_name, ppnf.last_name, to_char(ppos.date_start, ‘MM/DD/YYYY’) date_start, paam.assignment_number, paam.primary_flag, paam.assignment_status_type active_status, paam.bargaining_unit_code, aapf.payroll_name, PAAM.ASS_ATTRIBUTE6 attribute_value FROM per_all_people_f papf, per_all_assignments_m paam, per_person_names_f ppnf, per_periods_of_service ppos, pay_payroll_assignments ppa, pay_pay_relationships_dn pprd,…

Read More

Fusion HCM Query to fetch HDL Load Error Details

SELECT hddsb.data_file_name, hdds.ucm_content_id, hdds.creation_date, hdds.data_set_name, hdds.imported_status, hdds.loaded_status, hdds.import_lines_success_count, hdds.import_lines_error_count, hdds.import_lines_total_count, hdds.import_success_count, hdds.import_error_count, hdds.loaded_count, hdds.error_count, hdpl.pval018 assignment_number, hdpl.pval008 element_name, hdpl.pval010 ldg, hdpl.imported_status import_status, hdll.validated_loaded_status validation_status, CASE WHEN hdll.validated_loaded_status = ‘UNPROCESSED’ THEN…

Read More

AP Open invoice extract in EBS

Introduction: This script will extract the AP open invoices select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,’Partial Paid’,’Y’,’PAID’) PAYMENT_STATUS_FLAG , aia.invoice_date, aps.vendor_name, apss.vendor_site_code, aila.line_number, aia.invoice_amount, aila.amount line_amount, pha.segment1 po_number, aila.line_type_lookup_code, apt.name Term_name, gcc.concatenated_segments distributed_code_combinations,…

Read More

Drag and Down Using Oracle Apex

1.        Overview This document explains how to create a Drag and Down the rows using Oracle APEX. 2.        Technologies and Tools Used The following technologies has been used to achieve…

Read More

Allow Only Number and Decimals Using Jquery in Oracle Apex

1.        Overview This document explains how to Allow only Numbers and Decimal Using Jquery in Oracle APEX. 2.        Technologies and Tools Used The following technologies has been used to achieve…

Read More

Table Function to return look up value for LOV’s In Oracle Apex

1. Overview This document is about table function to return lookup values For LOV’s in oracle apex. 2. Technologies and Tools Used The following technologies have been used for table…

Read More

Sales Order Warranty Item Setup

SALES ORDER Warranty Item Setup STEP BY STEP Process STEP1: Create Warranty Item Navigation : Inventory -> Item -> Master Item CREATE A NEW WARRANT ITEM CODE HS-T7PSWAR-03 ITEM MASTER…

Read More

How To Add row from another report in Interactive Grid using JavaScript

1.  Overview This document is about Interactive Grid – Add row from another report using JavaScript in oracle apex. 2. Technologies and Tools Used The following technologies have been used…

Read More

Oracle Apex Detect Multiple Browser Tabs

1. Overview This document is about to detect multiple browser tabs in oracle apex. 2. Technologies and Tools Used The following technologies have been used to detect multiple browser tabs.…

Read More