Reports
Discussion List
-
How to extract a report or excel for "ApprovePlanVersion" Project budget Approval RulesWe have set up hundreds of rules for "ApprovePlanVersion" (project budget related) in BPM worklist. Business would like to see those rules in an excel format or a report…Oracle-Pai-Oracle 21 views 3 comments 0 points Most recent by Preda Silviu-Oracle Project Management -
Disability status of My Contacts (People to Cover)Summary: Hi Experts, We have requirment to send email notification to employees when Employee added Contact Relationship (Me→Benefits→Before you enroll→My Contacts) with…Murugaganesh 31 views 2 comments 0 points Most recent by Murugaganesh Reporting and Analytics for HCM -
Payroll administrator is unable to see records updated by Fusion HCMWe have an analysis created using subject area Payroll - Personal Payment Details Real Time. I can see all records having been updated by any user but our Payroll Admini…Deana Wittman 23 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu…TerryM01 102 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…