Reports
Discussion List
-
How to find out who/when edited BPM Worklist about Access ActionsSummary: What are the tables/views enable us to find out some audit info that who and when have edited the BPM worklist, e.g. ApprovePerformanceGoal, about the Access > …Hellen Zhao-5941 52 views 2 comments 1 point Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Require User Account Status update history.Summary: Dear Oracle Community, We got an issue regarding the Users Account status. There's statuses turned to Inactive. We want to know who has made changes to the acco…Muzammil_789 11 views 2 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
How to identify records in ASSIGNMENTNODE PVO that do not appear in Employee's History?Summary: When using the ASSIGNMENTNODEPVO, I see records for employees that I do not see in their history in HCM. For example, an employee resigned and this was entered … -
i need query for approved by nameSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Duplicated records on OTBI Report linked to different assignments on Person dataSummary Duplicated records on OTBI Report linked to different assignments on Person dataContent Duplicated records on OTBI Report linked to different assignments on Pers… -
write a sql query to fetch average cycle time for each compensation planSummary: write a sql query to fetch average cycle time for each compensation plan Content (please ensure you mask any confidential information): write a sql query to fet…Pritha 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch average percentage of budget utilizationSummary: write a sql query to fetch average percentage of budget utilization Content (please ensure you mask any confidential information): write a sql query to fetch av…Pritha 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
'Same As' column function in reports no longer workingSummary: I am no longer to use the 'Same as' function for columns in Reports. I have followed the steps from Oracle.docs below. There is no longer a Members tab but a dr…
-
Need to skip HTML tags while displaying in the outputContent Hi All, We are facing an issue in Performance Management in Fusion Cloud. In the back end database table in one of the column (HRA_EVAL_RATINGS -- COMMENTS) whic…
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
Is there a way to Summarized Comments in NR report submitted in a memberSummary: I'm pulling Comments submitted in a form into a NR report and I would like to use Gen AI to summarized the comments. I have tried a few different options but I'…
-
Is there a way to add timestamp for EPM booksSummary: Is there a way to add time stamp for EPM books when downloaded. I am looking for timestamp on file name. The problem is when user tries to open current and prev…Divya_Masoodi 41 views 9 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
Certified payroll - Has Oracle provided delivered reports for certified payrollSummary: Has Oracle provided delivered reports for certified payroll? Can someone, please share any leads to achieve the requirement? Content (please ensure you mask any…Suppu 51 views 2 comments 0 points Most recent by Trisha Hastings Payroll and Global Payroll Interface (GPI)
-
Need Approval Group Details in GeneralLedgerHi all, I am working on a GL Manual workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments in GL. P…
-
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 21 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 101 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 73 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…