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
-
on Redwood page using Guided Journey- BI report bind parametersSummary: To show/embed BI report link on the redwood page and pass the assignment id of the logged in employee as a bind parameter to the path , tried using below &_xmod… -
Sql Table to get the details of BIP Data model QueryContent Hi, Is there any database tables available to fetch the details(Query) used in a BIP Report. We would like to see the list of reports using a particular field sa… -
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether… -
Which table stores the geography data on the recruiting side in Geography Hierarchies Task?Summary: I need to identify which table stores the geography data used specifically on the recruiting side within the Geography Hierarchies Task. The existing tables I h…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…
-
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…
-
How Can We Identify Whether The User Is Logged In Via SSO OR Native LoginHi Team, We have enabled both SSO and Native login for our pod and wanted to know how the users are logging into the system. Is it by SSO or Native login. Please suggest…
-
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…
-
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…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you …
-
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…