Reports
Discussion List
-
How to embed/display the DOR attachments/images (blob data) in BIP reportWe have a requirement where employees signature needs to be captured in BIP template/report. So we are thinking of loading the employee signatures as an image via DOR ag… -
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…Jahnavi Konduru 31 views 4 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
Need API for User module name , Module key and module type under manage value setsSummary: Hi Team, We need a API to get User module name , Module key and module type under create value set as shown in below screenshot. Content (please ensure you mask…
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 17 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …Gurvinder Singh Gill 907 views 3 comments 0 points Most recent by Sravani Budde Reporting and Analytics for ERP
-
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident…
-
How to attach custom bi report to document of recordsSummary: How to attach custom bi report to document of records Content (please ensure you mask any confidential information): Hi All, We got a requirement to attach bi r…
-
Leases pending in version status 'report generation in progress'Summary: Hi, We have converted > 12000 leases in February. Now when closing the first month it looks like most of the are pending in version status 'report generation in… -
How to display in a Report a Document of Records (DoR) Image AttachmentSummary: is it possible to achieve the following requirement? 1. Update an image to a DoR as attachment 2. In a report enter a DoR ID as a parameter and then print/displ…
-
User Entities used in the seeded Extracts are not available to use in newly custom created extractsI am creating a Payroll Costing related HCM Extract. I referred the oracle seeded HCM extracts, there is one named 'Payroll Costing Report', this extract has all my requ…
-
New report book will only accept one data sourceHi All About to raise an SR - but thought would check others first. Can anyone create a report book and include a report with two data sources, we have existing books th… -
Failed to execute member query due to unexpected failure from the data sourceSummary: Failed to execute member query due to unexpected failure from the data source Content (please ensure you mask any confidential information): Hi - I am getting t…
-
In what Subject will I find Vacation Service Date?Summary: I am looking for pull the Vacation Service Date for all EEs, however, this does not appear in the analysis listing and I cannot find the specific subject that t…Kelly_at_D&R 61 views 4 comments 0 points Most recent by Mohammad Afghanul Payroll and Global Payroll Interface (GPI) -
How do I get current status of previously terminated employees onto a report?Summary: I have a termination report with all prior terminations on it. However, for rehires, I want it to show that they terminated but I need to know that they are cur…
-
Report - Unable to communicate with the datasourceSummary: 2 ( / 5 on application) databases are not available for report Content (required): Hello, On Thurday September 1st, I have created a report in my test environne… -
Table with the worker number field of the HCM module in Oracle Cloud FusionKind regards, Please help me to identify the table that has the worker_number field, it is not the person_number of the HCM module in Oracle Cloud Fusion. Thank you for …Jhonattan Diaz 52 views 2 comments 0 points Most recent by Jhonattan Diaz Reporting and Analytics for HCM
-
Is there any way to expand the current limitation in Reports for only sending emails up to 10 MB?Summary: In Reports, when executing a bursting definition there is a size restriction of only 10 MB. Is there any way this can be expanded? Content (please ensure you ma…
-
FCC Financial Report to Report Migration ErrorsHello, hopefully someone can help me here. We are trying to migrate our FCC Financial Report to Report however, we got some errors in migrating the reports one by one. I…Vera04 31 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
License Count IssueSummary Identifying Authorized Hosted Named Users (Doc ID 2512770.1) does not Provide the Correct ResultsContent Hi, We are using the Oracle License count report to get …Sahil_Makhiza 1.1K views 10 comments 2 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Filter Criteria Changed in OTBI report when i run the schedule processIn OTBI Report ,few DFFs were missing from subject area and also the filter criteria changed to "Assignment Status Type is not equal to / is not in INACTIVE; INACTIVE_PA…Global Support Desk 22 views 2 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
Is it possible to export a report in excel same as we export the financial report?Summary: I have migrated my FR report to Reports. Is it possible to extract that in excel like we can export the FR report in excel report format? Content (please ensure…
-
How to show the "Not Started" in graph even if its 0 count?Summary I have this graph of Document Status (Not Started, In Progress, Completed). I want to show the "Not Started" even if its 0 count. How can I do it? Content (pleas…
-
Using Case Statement on Performance Document StatusSummary: Hello everyone, I need help on my case statement. Can you please check if this is correct. There are errors when I use the statement. I want to only have 3 stat…
-
Facing issue with FRS report after migrating to another instance.Facing issue with FRS report after migrating to another instance. Getting "Unknown Member Issue" even when the hierarchy and account existsLakshmiVanarasi 51 views 10 comments 0 points Most recent by LakshmiVanarasi Reporting and Analytics for ERP
-
In BIP report, how to call an image stored in Catalog pathHi Team, Company Logo is uploaded in Catalog path (/shared/Custom/Logo/image.gif). I need to call this image in rtf template. I used below syntax but it did not work. Ca…Praveen Kumar Ponnusamy 41 views 1 comment 0 points Most recent by Praveen Kumar Ponnusamy BI Publisher Learning Center
-
How to call fast formula using procedure call sql typeHow to call fast formula using procedure call sql type such that i can use for the remaining calculation to build BI report.
-
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…Jahnavi Konduru 41 views 2 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
requisition approval tree not generted how to write BIP queryCreate notification like when requisition approval tree not generated trigger notification.SivaRamaKrishna-Oracle 1 view 0 comments 0 points Started by SivaRamaKrishna-Oracle BI Publisher Learning Center
-
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 141 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.