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
-
query that fetch failed transactionSummary: SELECT * FROM ( SELECT DISTINCT HTCE.TRANSACTION_ID, HTCE.PROCESS_CATEGORY, HTCE.OBJECaT_NAME, HTCE.CREATED_BY, papf.PERSON_NUMBER, ppnf.FULL_NAME, TO_CHAR(HTCE… -
Restrict line manager access to report on direct reports DOB and Address InformationSummary: Hello, We don't want our line managers to report on their direct reports DOB and Address information. We tried to use data security profiles to restrict access …
-
Candidate Extensible Flexfields recruiting for Job Application specific candidate profileSummary: Hello - 26A release the ability to report off Candidate Extensible Flexfields in OTBI subject area - Recruiting - Recruiting Real Time under the Candidate > Can… -
Sql query to get reporting unit hcm information data - tax reporting unit -French Establishment InfoSummary: Hello, We need to extract data in BIP for the reporting unit hcm information data - tax reporting unit -French Establishment Info. Does anyone have more details…
-
dashboard for CXOSummary: is there any dashboard available by delivered for HR basis of AOR, they can data trends for all modules including core HR , Absence , Talent including learning … -
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…
-
Strategy to keep users from accidentally moving folders/reports on the Catalog pageHello. Asking if anyone has a proven strategy to address the risk of a report user, on the Catalog page, accidentally moving folders or reports from their original locat…
-
How to add custom archival data to the GTN report?Summary: A customer needs to add custom deductions to the Gross to Net summary report, just as they can in the Payslip, which include this feature. The XML does not cont…
-
FDI attributes without Start & End date includedWhen creating reports in FDI, we find attributes that are present in the subject area but the attributes Effective Start Date and Effective End Date (and sometimes other…
-
Interaction tab information is not being stored in retained candidate profile after merge processSummary: I am facing an issue related to candidate merge behavior in Oracle Recruiting and would like to confirm whether this is expected functionality or a limitation. … -
OTBI Historical Talent RatingsHow do we report on Historical Talent Scores (Potential) in OTBI? I see that Workforce Talent Review - Talent Review Meeting Real Time subject area can be used to report…
-
OTBI Report Access Issue – “Workforce Management - Processed Time Cards Real Time” Subject AreaHi Team, We are encountering the attached error when a user attempts to run an OTBI report developed using the subject area “Workforce Management - Processed Time Cards …
-
FDI - Custom Security Context LOV returns row-level values instead of value-based valuesHi, We are currently implementing the security configuration in Oracle Fusion Data Intelligence (FDI). In addition to the 5 standard Security Contexts available, we need… -
Annualized TurnoverSummary: Does anyone have a report for annualized turnover? I see questions from the past on this same topic and have not found one in the shared reports. The seeded fie…
-
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ…
-
Unable to change the End Date of an element entry via HSDLSummary: We have created an HSDL template to Create/Update element entries. The template is working in all scenarios, except where we are trying to change the end date o…
-
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… -
Adding Prescreening Questions to QuestionnairesSummary: We have been trying to add prescreening questions to Questionnaire template for an external application flow and getting Rest error. Upon analyzing we got to kn…
-
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?… -
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea… -
Could you please provide information on where I can access the standard Time and Labor reports?Summary: Time and Labor Reports. Could you please provide information on where I can access the standard Time and Labor reports? I am specifically looking for reports th…
-
Blank line at the end of etext template output fileBlank line at the end of etext template output file.
-
How to Trigger Bursting Email to Employee with 2 Attachments Along with Email BodySummary: Hi, We have developed a custom bursting report which has Email body configured in Parameter5 and single pdf attachement is generated based on rtf template. We g…
-
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…
-
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…
-
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…
-
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… -
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 …
-
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… -
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…