ORACLE TECH CENTER
Oracle Apps/Fusion Technical
Thursday, 19 December 2024
Query for Intercompany Imbalance Report
›
SELECT A.*, A.US_Ledger_amount + A.CA_Ledger_amount Imbalance FROM ( SELECT --LEDGER , Comp_Inter_acct , SUM(US_L...
Monday, 9 December 2024
Query for Absence and Overlapping employees of Absence
›
WITH Main_Q as (SELECT distinct * FROM( SELECT papf.person_id, papf.person_number, ppnf.display_name employee_name, ...
Monday, 2 December 2024
Generate Empty File in BI Publisher Bursting sql returns no data
›
Currently there is no supported method for that. The workaround is to make sure that your sql will always return at least one record. You ...
Sunday, 24 November 2024
Query For Payroll Run Balances In Oracle Fusion
›
SELECT /*+ MATERIALIZE */ main.person_id ,main.Employer_Contribution ,main.Member_contribution ,main.org_information6 as Nest...
Friday, 8 November 2024
Query for Oracle Fusion Payroll Balances
›
WITH Employer_con AS ( SELECT /*+ MATERIALIZE */ SUM(bal.balance_value) as amount, pprd.person_id, p...
Rest Api Testing for Oracle Time and Labor (OTL)
›
Oracle Time and Labor Rest Api: Rest Api: hcmRestApi/resources/11.13.18.05/timeRecordEventRequests Method: Post Payload: { ...
›
Home
View web version
