Reports
Discussion List
-
Intercompany Payable and Receivable representation in FRS reportsHi, Currently we are maintaining only one natural account for Intercompany Receivable and Payable. In other terms, if the account has a positive balance, it will be cons… -
Need SQL Query to Extract Seeded and Custom Audit Report DetailsHi Team, I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the follow…Karthikeyan s-Oracle 71 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Narrative Reporting - Drill to Content Prompt Carry OverSummary: Looking for feedback when it comes to the construction Oracle Narrative Web Based Reports. I have included “Drill to Content” enabling users to click on a dimen…
-
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using…Pritha 11 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
List of users using HCM Mobile app reportSummary: We need a list of users who are using HCM Mobile app as a report with BI or OTBI . where this information is stored in SaaS? Content (please ensure you mask any…Akshitha Vyas 1 view 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How can I put a dynamic time series in column in Reports?Summary: Content (please ensure you mask any confidential information): I would like to add the dynamic time series to a report, but I don't see that option. I would nee… -
How to get shift name start time, end time for certain date after manually change the workSummary: I need to retrieve the shift name, start time, and end time for a specific date after manually updating the work schedule calendar. How can I get these updated …Sanduni Pathirathne 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…
-
RVIE Report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) Not Showing Any InvoicesHello everyone, I’m currently facing an issue with the RVIE report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) in OTBI. When executing the report for… -
Query to fetch data entered by employee in an ICP requestI am looking to build a query on the ICP request raised by an employee. This should include submitted and approved transactions. However, there are certain fields for wh…SHRUTI PRIYA 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
When did Oracle update the UI of Report?Hello everyone, For a long time, I have not used the Report in PBCS. However, when I have to create a new report today, I found some weird updates from Oracle. For examp… -
Model Documentation Report accessIs there a way that users can access the Model Documentation Report WITHOUT the ability to Edit Allocation Rules? So previously I had a thread where users had full acces…Peter Joelson 21 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
NR Reports - How to set the display order for the dimension search sectionWe are using a BS report that shows performance by company and accoutning period. When we open the report, there is a search section that specify company and accouting p…
-
xls template compatibilty errorSummary: Hi Team, I am currently using an Excel template in the Microsoft Excel 97-2003 format, which has been working well in production. However, I need to implement a…
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 325 views 6 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Need Help Identifying Tables for Custom Oracle Audit Report with Product, Business Object TypeSummary: Hello Oracle Community, I'm trying to build a custom audit report similar to Oracle's standard audit output with the following columns: User Product Event Type …Vishal Purohit 41 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Oracle will be replacing FR with Reports, requiring all FR reports to be migrated.Summary: We recently received a notification on the EPM Cloud interface regarding the removal of Financial Reports (FR) in June 2025. Oracle will be replacing FR with Re…
-
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…
-
How to find Standard Working Hours for a DepartmentSummary Need to report the Standard Working Hours for a department on employee reportContent On an existing report that contains the employee's standard working hours, I…Greg Wissler 88 views 6 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
How to fetch the calculation card association details TRU for a specific assignmentSummary: I am currently working on fetching the TRU for Tax withholding calculation card. The calculation card has association and association details. It uses US taxati…
-
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
How to gather data of update interest tab from all employees?Summary: We need to create a report which shows all the data user has entered in Update interest page. Basically we want to gather employee interest so that recruiter ca…Vaidehi Desai 21 views 2 comments 0 points Most recent by Vaidehi Desai Reporting and Analytics for HCM
-
Etext Templates do not process an XML tag prefixed with underscoreSummary: XML Fields with underscore prefix are ignored in EText template e.g GB Statutory Deductions /PAYE/ Pay as you earn/ _TAX_CODE, _TAX_DISPLAY, _ISSUE_DATE etc Con… -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Is there a way to replace Oracle logo at the platform level for all seeded reports?Summary: How can we replace Oracle logo with customer logo (white labeling) for all seeded reports? Content (please ensure you mask any confidential information): We hav… -
Can you insert Financial Reports into DashboardsSummary: I'm trying to insert Financial reports created in EPM into Dashboards. However it doesn't seem like this option exists. Only options are either to add forms int…
-
FCCS reports show approval status/ calculation statusSummary: Client migrating from HFM to FCCS. When reviewing report contents, users want to know the current location/approval status. Functions were available in HFM to s…
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe…