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
-
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl… -
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr… -
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…
-
P60 reprint blank in document records but showing in flow correctlySummary: An employee had set their document delivery preferences to not have an online copy for a P60 produced. This resulted in the employee not having a P60 created in… -
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?… -
How to link Person Real Time Subject Area with Workforce Management - Worker Assignment Event Real TSummary Is it possible to do this using logical SQL?Content Hi, I'm new to OTBI and I'm experiencing a lot of frustration regarding the Person Real Time Subject Area not… -
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours … -
Blank line at the end of etext template output fileBlank line at the end of etext template output file.
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t… -
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna…
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…
-
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…
-
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages…
-
Sickness balances by proration periodSummary: I am trying to export the person number, minimum date and maximum date for all staff who between September 24 and March 26 had received "Statutory Sick Pay" whi…
-
ORC report to show the most progressed candidate phase for every open requisitionHello - We want to create a report to provide recruiters a list of all open requisitions and the phase of the most progressed candidate for the respective requisition. W… -
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…
-
Detailed requisition information is not visible for any usersSummary: The approval transaction page is displaying only the approval timeline, and detailed requisition information is not visible for any users. Content (please ensur…
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
trying to edit a BPM location for change location approval but no option enabled for thisSummary: I am trying to edit a BPM location for change location approval. I have created and entered into the sandbox, then when i am trying to enter the BPM worklist pa…
-
How can I safely handle cases where GET_VALUE_SET returns null, and default the value to 0Summary: When the value set returns null (i.e., no leave has been taken), the formula either fails or doesn't return the expected accrual. Even though I am checking for … -
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…
-
OTBI Conditionl FormatingI’m facing an issue while building a formula in OTBI (Subject Area: General Ledger - Journals Real Time). Requirement: I want to calculate a value that combines: Journal… -
How to test Enhanced BIP Notifications to Display Assignment Notes in Redwood Employment ProcessesHi Team, Has anyone tested Feature 26A: Enhanced BIP Notifications to Display Assignment Notes in Redwood Employment Processes? Oracle’s release notes say this change “a…
-
OTBI New Calculated Measure Formula for Age at End of the Month from report run dateI need a formula that would provide me with the dependents age as of the end of the month from the report run date. If the report is scheduled to run on the 1st day of t…
-
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What… -
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…
-
Need PVO name to fetch additional attributes from Assignment DFFSummary:We have additional attributes populated in Assignments and they are visible in Fusion OTBI BIP table per_all_assignments_f can you please let us know from which …