Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi… -
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for… -
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H… -
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new … -
Does the person with delegated role get access to the additional data via reportingContent (please ensure you mask any confidential information): If a Manager has delegated (say) their Line Manager role to their Exec. Assistant (EA), then does the EA s… -
Load HMRC XML File Fails When P6 P9 Audit Report Output Format Is Changed to CSVSummary: We are using the UK Payroll flow pattern "Load HMRC XML File". The flow generates the "Inbound Data Audit Report", which uses the layout "P6 P9 Audit Report". W… -
How can I get the original column header in the CSV output of a BI report without underscoreSummary: How can I get the original column header in the CSV output of a BI report without underscore Content (please ensure you mask any confidential information): How …
-
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…
-
A query to find person id,role name and associated security profile in Fusion HCMSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to Join FND_BPM_TASK_HISTORY_B with HCM Tables to Retrieve Employee Conversion DateSummary: Hi Everyone, I have an existing Oracle HCM report that retrieves employee Hire and Rehire information. There is now an additional requirement to include the Emp…
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…
-
Error Codes: OAMP2OPY:U9KP7Q94 - OTBI AnalysisSummary: We have a weekly Analysis that runs via Agent. After running many times without issue each week, we are getting these errors: OAMP2OPY:U9KP7Q94 - "An Unexpected…
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, Nivya -
Can we customize the report 'Employee Vacation and Delegation Rules Report'Summary: Since there is no possibility to restrict employees who they can delegate approvals to we need to be able to control/report on creates approval delegation rules… -
OTBI Report - need to fetch the Worker Historic informationSummary: we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Man…
-
How to Merge row cells if having same data in RTF templateSummary: I want to merge same row cells in excel data in RTF template. Person Number ,Person Name and License Number should come as single row like merge. Can anyone hel…
-
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…
-
Can you use the Oracle Fusion Third-Party Tax Filing Extract to create SSA and state filing file?Summary: For the year-end filing with the SSA and appropriate regional authorities, can you use the Oracle Fusion Third-Party Tax Filing Extract to create the file? Has … -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
Creating a quick analysis for employee terminate information with legal employerI am creating a quick analysis for a bulk worker termination but when adding the legal employer name column that is needed in the criteria, it breaks the results. When I…
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…
-
HR Help Desk queue resource subject area not giving correct resultsSummary: I have an OTBI report using the above subject area which is not returning the correct results. I want a list of Queues and the Agents assigned to those queues. …
-
BI Publishing: bursting without attachmentsSummary Bursting to selected people, without attachmentContent Hi all, I am trying to use BI Publishing to burst an email to colleagues who have handed in their notice. …
-
Correct Employment Transactions ReportSummary: Does anyone have a report for track native 'correct employment' HR transactions that they use? Content (please ensure you mask any confidential information): Ve…
-
Certified Payroll Report - Fusion PayrollSummary Need to create custom balance for Certified Payroll ReportContent Hi All, Business Requirements :- We have a requirement where they want to have a custom Report …
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o… -
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne…
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
Re-hire employee HDL templateSummary: Hi Expert, We are looking for an HDL template to rehire terminated employees. The requirement is to rehire employees with the same assignment information they h…