Sample Reports
Discussion List
-
SQL query to fetch employees holiday applied on during employees is on maternitySQL query to fetch employees holiday applied on during employees is on maternityManikanth Kumar 34 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Bhavani Rikkula 31 views 2 comments 2 points Most recent by Nagaraju Upputuri Reporting and Analytics for ERP
-
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
How to report on data from Workforce Assignment Event Real Time and Workforce Assignment Real TimeSummary: We have a requirement to report historical employee headcount based off values stored in an Assignment DFF. We get accurate historical data only when an action …David Boudreau 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
GL Drill Down to Work OrderNeed a query to drill down from GL to Work Order. We need details of PO, Work Order Number, Quantity, Amount when starting from Journals. We are using Source = 'Cost Acc…Sharmava 81 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Organization name need to be replaced with department name.Summary: Hi All, Can some one help me on changing the Organization name instead of Department name in below query Content (required): In the query its is fetching old or…RamkumarKadhiravan 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le…Satyam Roy 24 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
BI Report for Receipt Accounting BU, Commodit Code as input parameter an get PR,PO,Receipt detailsHi Experts, Can someone please help in below requirement. I am looking for sample query and relevant table information where I need to pass date range,BU,LE and Commodit…Revathi I 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get the element entries and the pay period datesHello, Requesting your help to get the sql query to fecth element entry details and the associated pay period start dates and end dates. The elements are recurring eleme…Regunanthan 1.3K views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to convert primary ledger currency balances to USD currency balance in Oracle FRS reports?Need to get the primary ledger currency balances to USD currency balance, based on 'Period Average Rate.'Fredrick Ignatius 23 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Report to identify terminated employees in BPM workflowSummary: Content (please ensure you mask any confidential information): Hi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle wo…Nidhi Chhajed 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Is there way we can get the "Import Asset and Assignments Process" import errors detailswhen we run the "Import Asset and Assignments Process" to import the Capital assets the load interface file import success and errored at import job and we are trying to…Saadiq 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Payables UI Creation Date is different from the QueryHi everyone, Does anyone know why is the Creation Date on UI (Payables) shows different from the Query? Here is the sample. And here's the query. SELECT INVOICE_NUM , CR…Christian Nicole Cristobal 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBISummary: How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBI Content (please ensure you mask any confidential information): Versio…
-
OTBI Asset Depreciation Report with Pivoted Accounting DateI'm trying to create an asset depreciation report in OTBI using a pivot table. My goal is to have the accounting date itself be a pivoted column (displaying depreciation…
-
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 141 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I am getting exception error for one of scheduled report through bursting.Summary: I am getting exception error for one of scheduled report through bursting. Does anyone know what should be the reason. Content (required): Job Priority: Normal …
-
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Audit eventSummary: Event type and Attributes required to audit Role/Priv creation and maintenance Content (please ensure you mask any confidential information): We would like to r…User_2025-12-05-00-49-06-629 21 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
BIP Output delivery Details to SAAS and UCM detailsHello All, Could you please help us with details on following points if you have any inputs regarding BI reports delivery: 1. BIP output shown in report history is hoste…Pooja K 21 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…Sai Shyam 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 11 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
Authentication issueDear All, I am currently utilizing basic authentication (username, password) to invoke a report and retrieve data from Visual Builder through the SOAP API. However, we h…George Mattar 11 views 3 comments 0 points Most recent by Narendra More-Support-Oracle Reporting & Analytics for Fusion Service
-
Arabic text not displaying properly when generating pdf outputSummary: Arabic text not displaying properly when generating pdf output Content (please ensure you mask any confidential information): Hi Experts, In Invoice Print Templ…Venkatesan 91 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Need payload and api to get a person course number in response for a particular coursewe know the person number and course name how can we get the "assignmentRecordNumber": "OLC12345678", using below api. /hcmRestApi/resources/11.13.18.05/learnerLearningR…
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…JayK 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 21 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM