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
-
Seeking documentation to code for HR Org hierarchySummary: Hello All, I see that Fusion utilizes the following tables to manage HR organizations and their hierarchies: - HR_ALL_ORGANIZATION_UNITS_F (internal CDEE_FSCM_O… -
OTBI Analysis Columns displayed by prompt valuesHi Experts, We have a balance report that works well. However, we would like to display in it some context based assignment DFF's. We would like to keep 1 report for eac… -
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…
-
Can we burst XPT templateSummary: We have an Report created with XPT template (Normal report creation). Can we use this template and burst the report in excel format? Content (please ensure you …
-
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…
-
How is Business_Group_Id in PER_ALL_PEOPLE_F a foreign key to HR_ORGANIZATION_UNITS which is a view?How does the BUSINESS_GROUP_ID column in the PER_ALL_PEOPLE_F table function as a foreign key to the HR_ORGANIZATION_UNITS view, given that the view is not a physical ta… -
How to show only specific folders in Reports and Analytics Catalog?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
In BI Publisher scheduled report how to disallow using Email Destination while retaining burstingSummary: Can BI Publisher scheduled reports be setup to disallow using Email Destination (either enterprise wise or certain user roles) while at the same time retaining …
-
Payroll - Element Entries History Real Time Assignment ManagerSummary: Payroll - Element Entries History Real Time assignment manager subject area - what to find assignment manager to class employee as direct or Indirect staff Cont…
-
Log details about user account lockSummary: Log details about user account lock Content (please ensure you mask any confidential information): Hello, is there any way to check why the account gets locked?…
-
PER_PERSON_SECURED_LIST_V View Does not Retrirve all RecordsSummary: PER_PERSON_SECURED_LIST_V View Does not Retrieve all Records. It fetches the data of only the Current logged in user. Please advise Content (please ensure you m… -
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.
-
Query to get all approval transactions pending with terminated line managersSummary: How to get all approval transactions pending with terminated line mangers. I need a query to get all details including approver's person number/username. Conten…
-
Where is 'Last Updated Date' in OTBI for Licenses and Certifications?I am trying to pull a report for all licensure in our organization. I see every field listed on the licenses and certifications UI except 'Last Updated Date'. Where woul…
-
How to create a custom report in BIP with calendar .ics as attachmentSummary: If we need to create a BIP report which has calendar invite .ics as attachment along with other content in email, how can we do that? The requirement is the ema… -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…
-
OTBI analysis for consolidated manager viewSummary: I am creating a manager dashboard comprises of performance, goals, feedback, check-ins and performance booster report. We need to apply a filter for manager whi…
-
unable to get the assignment details for pending worker from checklist real time subject areaHello Team, while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment …
-
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
OTBI-How to combine Requisition other locations into one fieldSummary: I have created an OTBI report ( Subject Area :Recruiting -Recruiting Real Time) , and the Requisition Other Locations are displayed in multiple lines in output …
-
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
Active Candidate Pools OTBISummary: Dear Community, We would like to create an indicator that counts all active candidate pools within our system. However, while exploring the Recruiting - Recruit…
-
Can someone please help, on where to find this value in oracle Tables?Hello can someone please help on where to find this field on HCM Table and Views? UI Navigation is Benefit Administration> Plan Configuration> Rates and Coverages> Varia…
-
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …
-
Need sample query to fetch list of document records for dependentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get rid of a trailing space CHR(32) at the end of a OTBI folder name or in a directory path.Summary: The site at: https://community.oracle.com/products/oracleanalytics/categories/otbi where this probably should go is defunct, so I am posting this here. I have f…
-
if we can run an OTBI report that shows when a password has been reset as well as an email updated?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…
-
How can we report on Users Last Login Date and Time?Summary: We often has scenarios where workers are terminated in the system after their actual finish date. This means that there is a window where users can access our s…