Reports
Discussion List
-
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 81 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 21 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.Nalsoft Pvt Ltd 21 views 3 comments 0 points Most recent by Adnan_Rashid-Oracle BI Publisher Learning Center
-
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 Most recent 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.
-
No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: Hello, I'm trying to create a learning report showing employee's division, branch, department. I get results I need except from the 3 criteria. I have both HR A…
-
BIP | SFTP issuesSummary: In which table holds the FTP failure error messages. Content (please ensure you mask any confidential information): Assume that BIP report unable to place the f…
-
How to rearrange row in OTBI report?Summary: Hello, I need some help. I want to rearrange the performance tasks according to the order below per employee but every time I sort, the entire column sorts. Wor…
-
Conditional Suppression in EPM ReportsSummary:Cannot get Conditional Suppression to work in EPM Report Content (please ensure you mask any confidential information): I have migrated a FRS Report to Reports. …
-
How do I query Administrator Profile Options?We often find that there are Administrator Profile Options that are enabled or disabled during upgrades that we are unaware of and are not part of the release notes. Bec… -
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 181 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.5K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Scheduled Report taking the extract in UTCSummary: Hello, The query is that if we are scheduling a custom report in IST time zone like 2.45 AM IST BUT the scheduled report is extracting the data from form 9.15 P…Awadhendra Tripathi 11 views 1 comment 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
how to suppress 0 data in FCCS reportsWe have two test environments and when I open the same report it shows different row counts. In test environment A, there are some entities that are not visible in Test …Patrick Pontillas 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…
-
Need help in creating new Talent Profile printable versionSummary: How to create new Talent Profile printable versionRavindr-Oracle 11 views 2 comments 0 points Most recent by Christine Yokoi-Oracle Reporting and Analytics for HCM