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
-
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti… -
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…
-
Common Question: In what particular subject area can I find these columns?https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet Typical Symptoms: you see columns on an appl…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content… -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
Requirement to Add Print / Approval Printout Action in BPM Worklist Approval PageSummary: Hello Oracle Team, We have a business requirement to provide a Print / Approval Printout functionality directly from the BPM Worklist approval page in Oracle Fu… -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…
-
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co… -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…
-
Retrieve User ListSummary: I would like to create a BIP report to retrieve a list of user information. Content (please ensure you mask any confidential information): Please let me know wh…
-
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…
-
OTBI issue issue,Workforce Management – Absence Real Time subject area.Summary: Hi , OTBI issue issue, calculated absence duration when using the Workforce Management – Absence Real Time subject area. Example: Employee submitted three conse…
-
Getting error while uploading PGP key in BI AdminstrationSummary: Getting below error while trying to upload the PGP key. Importing public key file xxxx_public.asc failed: reason = Key file could not be imported: exit value=2 …
-
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…
-
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…
-
Date changes by1 day while formattingSummary: Hi, I am using Oracle template builder for one of my reports which has date column, when I apply date formatting date changes by one day (example: 4712-12-31 ch…
-
Anytime Feedback Report template - need helpSummary: Need help on this: When I use the Subject Are: Work Profiles - Feedback Notes by Recipient Real Time, the report is fetching all data from feedback and meeting …
-
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.… -
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header…
-
Are there User Entity for Individual Compensation Plan In HCM ExtractSummary: Are there User Entity for Individual Compensation Plan In HCM Extract Content (please ensure you mask any confidential information): Version (include the versio… -
How to report on the due date for Journey tasks in OTBI?Summary: We are looking to create an analysis in OTBI to pull a list of individuals who have overdue tasks from their onboarding journey. We are using the Workforce Mana… -
Element Entries Real Time - Retroactive Payement DateSummary Within Element Entries Real Time - I have Retroactive payements made to employees however in OTBI i cannot locate 'Orginal Date Earned'Content Overview: For Empl… -
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…
-
BIP report to get the approval status with history and attachments for Leave encashment, salary trasSummary: Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for DOR requests like Leave encashment, salary transfer lett…
-
Query to fetch "Issue Description" and "Resolution" for failed transactions.We had a requirement to display issue description and resolution for failed transaction. When we use table hrc_console_fault_details_vl hcfdv(for description and resolut…
-
Need table information to get below fields from journey template pageSummary: we need table information to get below fields. Restrict assigning journey if its in progress Use assignment identifier associated with assigned journey Navigati…
-
Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or TablesSummary: Hi There, looking for Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or Tables Content (please ensure you mask any confide…
-
OTBI report is generating single row output when language preference is changedSummary: OTBI report is generating single row output when language preference is changed and when language preference is set to English, then output looks good and otbi …
-
Error while copying the Payment HCM extract.Summary: We have a requirement to add some additional information under standard Paycheque report.For this purpose,I am trying to customize the "Payment" HCM extract def…
-
OTBI – Workforce Profiles: Person Profile Real Time pulling deleted competenciesSummary: I have a reporting requirement to identify the competencies workers have entered on their Person Profile, including workers who have not entered any competencie…
-
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h… -
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a… -
missing national identifierSummary: Technical user cannot extract National Identifier (Codice Fiscale) from PER_NATIONAL_IDENTIFIERS despite ORA_FND_INTEGRATION_SPECIALIST_JOB + custom role duties…
-
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…
-
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …