Sample Reports
Discussion List
-
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 21 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 142 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 13 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 97 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 25 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 -
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
-
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…Oriana L. 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 81 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
query to get deactivation date of userSummary: query to get deactivation date of user Content (required): May I know if any one know how to get deactivation date of user, I tried using end_date from per_user…Swati U 440 views 7 comments 0 points Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta…Andy Gough 920 views 10 comments 8 points Most recent by JLogan-EncoreGlobal Reporting and Analytics for ERP