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
-
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work… -
which subject area contains the name column of transaction console of oracle hcmSummary: which subject area contains the name column of transaction console of oracle hcmContent (please ensure you mask any confidential information): Version (include …
-
Table(s) contain POD Version and Last Refreshed DateContent Hi... I am looking for a SQL query to derive the last refresh date for a POD and latest patch level (ie 12A, 12C, etc). Thanks in advance for any tips. JR
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are … -
Can we call external application from BIP ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Total Compensation Statement - AnalyticsSummary: Hi All, We have completed generating the Total Compensation Statements for our employees. However; we would like to know if is there any way to get the analytic… -
ActivityAttemptNumber - QuestionsSummary: We are loading Learning Record V3 business object where we have ORA_COURSE and ORA_SPECIALIZATION as the Learning Item Type. We ran the query and found that the…
-
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as… -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…
-
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc…
-
When we select Other as a disability category, a text box should appear in UISummary: When we select Other as a disability category, a text box should appear in UI. How to configure this requirement? Content (please ensure you mask any confidenti…
-
Restriction of DOR to dependents only and not employeesSummary: Restriction of DOR to dependents only and not employees. Eg: Birth certificate is required for birth of the children not employee. Only dependents Content (plea…
-
How to limit values prompt values when using choice list values from SQL ResultsSummary How to limit values prompt values when using choice list values from SQL ResultsContent Hi All, In a dashboard Prompt we are using column prompts we want to limi…
-
how to fetch the direct report of the manager in otbiSummary: I am creating a journey and performance report in OTBI in which if a manger logs in then he need to see only his direct reporties. Content (please ensure you ma…
-
Attach the record attachments(documents) in Custom ReportsSummary create a link in a custom reports to download the document recordContent Hi everyone, I have a simple custom report with a list of document record and I would li…
-
Strange OTBI Error:[nQSError: 27046] Inaccessible columnSummary: Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screensh…
-
How to Create a OTBI Analysis Based on Simple Logical SQLSummary How to Create a OTBI Analysis Based on Simple Logical SQLContent Hi Experts, I was trying to 'Create a OTBI Analysis based on simple logical SQL' While I was hop… -
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisition
-
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi… -
Convert Rows to Columns in OTBI from multiple subject areasSummary: Hi All, We recently went live with oracle HCM implementation. I have a OTBI report requirement where I need to convert fields containing multiple rows to separa… -
In case of termination, there is a requirement to show last payment date.Summary: In case of termination, there is a requirement to show last payment date. Can anyone please guide on which oracle delivered field its captured? Content (please …
-
Payroll Transfer statusContent Hi All, We are trying to display "Payroll Transfer Status" in OTBI and we are referring "Workforce Management - processed Time Cards Real Time" "Processed Time E…
-
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
Calendar Quarter column formatSummary: Hello, Could you please let me know how to change the format of column "Time"."Calendar Quarter" in OTBI subject area "Workforce Management - Workforce Trend Re… -
Column Formula to get bi-weekly salarySummary: I need to get the bi-weekly salary of the employees, dividing the annual salary by 26 ( pay periods). Content (please ensure you mask any confidential informati…
-
Table that stores BIP error detailsSummary: Which table stores BIP error details text? Content (required): We are trying to build a custom BIP report to summarize all BIP job errors into a notification em…
-
Unable to fetch Resignation Transaction approval rules data in the reportWe have a requirement to fetch the approval rules data in the BI report. But we are not able to get the full approval flow from the tables.
-
Unable to Upload PGP key Post 24A UpgradeI'm Unable to Upload PGP key Post 24A Upgrade in BI Publisher using Administrator. It is giving 'Generating BI Publisher kaypair failed: reason = gpg --gen-key command f…
-
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…