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
-
Help with Case Statement using Payroll - Payroll Run Results Real Time OTBI Subject AreaSummary: I'm looking for help with a Case Statement using Payroll - Payroll Run Results Real Time OTBI Subject Area. Content (please ensure you mask any confidential inf… -
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… -
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…
-
Report Hours Worked/Processed by PayrollSummary: I need to be able to report hours processed by payroll from beginning of the year to current. I cannot use the timecards. I thought it would be in the payroll r…
-
Learning Records Real Time - Reporting on RecommendationsSummary: Trying to report on recommendations using the Learning Records Real Time subject area. It appears that a recommendation is an event which doesn't appear in the … -
Cost centres report in OTBISummary: Hi, I am wondering if anyone has a way of reporting on cost centres along with HR employee data in the same report. So far i have seen that Payroll costing setu…
-
Learning - Reporting on Penetration RateSummary: We would like to be able to report on the penetration rate of our learning module. I think the idea is to report the percentage of people assigned to a learning…
-
OTBI Report Source System Item Real TimeSummary: When i join Item Number and one of my EFF attribute in Product table i am getting one extra row in EFF table which is all blank. Do you know what might be the i…
-
Act as Proxy Manager for Line Manager DashboardSummary: As an HR user with view all, I am unable to proxy the line manager view what they can see in their own dashboard. In Workforce Compensation, there is Act as Pro… -
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
How to get the PTD & YTD Balance values from the "Payroll Balances Real Time" Subject AreaWe need to create an OTBI report with the balance PTD and YTD values. In the "Payroll Balances Real Time" Subject Area, Assignment-Period to Date, and Assignment- Tax Ye… -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; … -
How can I create multiple records in a single payload from Postman?Hi, I can create them one by one as follows, but I get the following error when creating more than one record in a single payload. Can you correct my mistake? Thanks { "… -
Need to export Cost Center info using FiveTran. Does anyone know which object this exists on?Summary: I think it should be in an object called assignmentDFF (that is where it is found using Rest API), but I don't see a corresponding table. Content (please ensure…
-
Retrieve payroll elements amount increasesSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve the payroll element amount increases? For salary basis,… -
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…
-
LSQL - Connect Job Applicant and Employee AssignmentHello All, I am writing an LSQL analysis in OTBI which requires us to add the Hire Date for applicants who are hired. We're familiar with the Projected Start Date and ev… -
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …
-
How do we control Grant/Restrict access to OTBI > Jobs > Report Job HistorySummary: Hello All, We Would like to understand how can can we grant or restrict access to "OTBI > Jobs > Report Job History". Do we have a role or Privilege with contro…
-
BIP FAILED_TO_EXECUTE_TRIGGERSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Where can I find the table for phase and state submission date?Summary: Table for phase and state submission date. Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
Bypass self-evaluation reporting in Performance ManagementSummary: Bypass self-evaluation reporting in Performance Management Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for… -
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app… -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…
-
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…
-
Duplicate record in analysisSummary: Duplicate record appears when pulling data from Workforce Management - Document of Record Real Time Content (please ensure you mask any confidential information…