Reports
Discussion List
-
EPM financial planningSummary: Pull all the comments available in EPM financial planning form into web report Content (please ensure you mask any confidential information): Hi all, I want to … -
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c…
-
how to fix conditional format in NR from Converted FR reportsSummary: I converted reports from FR to NR and over 200 plus conditional format was created - is there a way to fix the conditional format or do i manually need to delet…
-
How to connect General Ledger Tables to AR Cash Receipts Tables?I'm trying to build a report that includes GL data and AR Cash Receipts data. I've figured out how to connect the GL_JE_BATCHES table to the XLA_DISTRIBUTION_LINKS table…Steven Woods 51 views 4 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
SQL query to get the manager of a particular department in bip report in fusionI need to get a BIP report that should contains person information and department , Department hierarchy till level 3 including top department and the manager's name of …Anjali_Kumari4121 67 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Is there a notification that alerts IDCS users to expiring passwords? I cannot find the setting.Summary: In IDCS, is there functionality that sends out notifications when a period of time before a user's password is set to expire? How can we control this and the nu…
-
Filter OTBI prompts to only certain criteriaI created a Dashboard for our Learning team, which includes a Course tab, as well as a Specialization tab. The analyses used in each tab filter for the appropriate Learn…
-
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se… -
User Preferences in OTBISummary: Is there a subject area to report on user preferences under "My Account" in OTBI? Would this area report the same data as the user's "Correspondence Language" u…
-
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 69 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 324 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 32 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…