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
-
In OTBI analysis, how can I gather the periodic accrual value for the accrual balance column?23C (11.13.23.07.0) Hi all, We are unable to find the periodic accrual value in our monthly PL report. I'm attaching one screenshot, where the periodic value and absence… -
Need an help for SQL queryHello Experts, I need some quick help in for my Bi Report which is for Payroll module - The report shows data for some departments without any issue and for some months …
-
Total Salary by Division for the first of each month - OTBISummary: I feel like maybe this is very obvious and I'm overlooking it. But here it goes: We want a report that total salary for a given division on the first of each mo…
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…
-
BI Publisher Emergency Contact ReportSummary Building Emergency Contact Report in BI PublisherContent Hi Everyone, I am currently struggling in producing a BI Publisher report for emergency contacts, i know… -
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
"Selected Performance Goals Report" does not display the correct goal plan end dateSummary: I believe there may be a bug with this report, where the SQL is selecting the wrong Goal Plan End Date. While the OTBI subject areas (i.e. Workforce Goals - Goa… -
Is there any OTBI Subject area to generate the Delegation Details - Delegate Role,Delegate and ProxySummary How to create one OTBI report for Delegate and Proxy User and the Delegation DetailsContent Hi All, Could you please let me know if there is any way to create OT…
-
ORA-01830: date format picture ends before converting entire input stringSummary: Getting above error while running query with date parameter instead of parameter if i give sysdate it is working fine Content (required): Version (include the v…
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…
-
Deep link for a reportI have created a new page entry under "My Team" and i want a report to be triggered when someone clicks on that. Screenshot attached. How can i obtain the link to a repo… -
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal … -
Sample Payload for Update customer account via SOAP UI.Summary: Want to change the status of customer account from Active to Inactive. Content (required): Version (include the version you are using, if applicable): Code Snip…
-
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…
-
tables for state tax and local tax setup in hcm cloudSummary: looking the tax class,tax_type,max_gross based on the tax class Content (required): Version (include the version you are using, if applicable): Code Snippet (ad…
-
Change Assignment without Salary update included in the compensation salary audit reportSummary: Change Assignment without Salary update included in the compensation audit report. Why would this be included in the compensation salary audit report if salary …
-
BI tables to extract Contract attributesSummary: Content (required): Hello experts, which table allows me to extract PER_CONTRACT_LEG_DDF attributes; Italy Context? We need to retrieve the highlighted fields f… -
Are any specific role or privilege or job is required to access service infolets.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Audit ReportHi Experts, Can we have an audit report in the system on employee details change which included any change relevant to employee assignment, DOR and personal info etc.
-
Job Code Usage ReportIs there a report shows the last time an associate was in a given job code. We have a number of job codes with no one in the title. It would be helpful to know if the jo… -
Emergency Contact and Employment Info ReportSummary: Hi all. I've reviewed the documentation shared in other posts, but I'm still not getting there, for some reason (likely user error!). I need to create a report …
-
Matrix Manager - Why does OTBI return multiple matrix managers for each employeeSummary: We use Line Manager and Compensation Manager when creating or updating an employee assignment. Our reports should return no more than two managers for the curre…
-
OTBI analytic: Populate a value in a column based on another columnHi ! In my OTBI analysis I want to have column formula where I check if an employee have any value in column A. If a value in present in column A for an emoloyee, I want…
-
Position Vacancy ReportHello, does anyone know how I could report on vacant positions in HCM? I need to be able to report on both positions that are currently vacant, and positions that were v…
-
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…
-
Does anyone know which database table is used to report on Performance > Process Flow NameSummary: Creating a Data Model to report on Process Flows in relation to Performance Management. Does anyone know which database table is used to store/report on the Pro…
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …