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
-
OTBI Report in Workforce Goals - Goal Status Overview Real Time, Unable to add Organization LevelsI am building an OTBI report in a single subject area (Workforce Goals - Goal Status Overview Real Time). I am able to add Development Goals details from the "Developmen… -
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…
-
Are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables?Summary: Content (required): Hello experts, are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables? If so, could you share t… -
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…
-
OTBI - Pivot with multiple information types (Email Type, Phone Type)Content Hi, We have a report with some personal information on it. Among other columns in report we do have Email (incl. Email Type) , Address ( incl. Adress Type) and P… -
when i try to schedule the report through agent in condtion section when test its show false why?Summary: Hi Team, when i try to schedule theOTB report through agent in condtion section when test the condtion its show false why? Please help me on ? Thanks, Ajay Cont… -
What subject area to use to return result for requisition "use" fieldSummary: Trying to report on the requisition "use" field; see screenshot below, but unsure of which subject area this may be housed in? Content (required): Trying to rep… -
BI Report or OTBI report - create Bell Icon Notification via BI Publisher scheduler or AgentSummary: How can one trigger the creation of a notification in the Bell Icon, so a BI Publisher BI report or OTBI appear there? Content (required): Want BI to be able to… -
Does exist a way to know which database tables gets modified when user inserts data from UI?Summary: Does exist a way to know which database tables gets modified when user inserts data from UI? Content (required): Does exist a way to know which database tables … -
Need help connecting Transaction Data to Workforce Management DataSummary: I need to create a report connecting the following subject areas: Human Capital Management - Approval Notification Archive Real Time to Workforce Management - W… -
Audit on Termination DataSummary: Audit on Termination Data Content (required): Hi All, Greetings! Is there any report available based on audit for termination data for the employees? We'd need … -
Mail notification sending and limitHi, Can a special mail extension be used in notifications prepared as bursting and sent via email? For example, it should only go to people whose e-mail is @aaa.com.tr ?… -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…
-
Reporting on Holiday Entitlement and Remaining BalanceHi all, Is it possible to report on total holiday entitlement as one combined field (factoring in employees carry over, annual accrual and other adjustments) within OTBI…
-
Audit ability for OTBI fields and BIPSummary: Is there any ability to audit on who has created and run a BIP report or OTBI analysis that include specific folders/fields such as from Workforce Management - … -
'Seniority Day' field is having incorrect data in new V3 subject area.Summary: Steps to replicate the issue - We created the OTBI report to fetch 'Seniority dates' and 'Seniority days' from V3 subject area ‘Workforce Management - Person Se…
-
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
Data Secuirty in BI using different data secuitry on role configurationsHello, Am having this case here, Am using Secure View in my query (PER_ASSIGNMENT_SECURED_LIST_V) and am having 2 different data security on roles 1st Person Security Pr… -
seeded CheckReport USCheckwriterTemplate.rtfSummary: Somehow, the seeded template (US) for CheckReport.xdo appears to be overwritten in the Oracle Fusion HCM BI cloud, trying to find a seeded version for USCheckWr…
-
Query to extract Candidate Attachments URLSummary: Content (required): Hello experts, please, could you provide the SQL Query to extract Candidate Attachments URL? Our customer should retrieve Candidate Curricul…
-
Can somebody assist. on how to get the "Seniority Date" calculation date in OTBI subject report?Summary: How to include Seniority Date calculation date in OTBI subject area report (Please refer the screenshot 1 for reference)? How to include Seniority Date transact…
-
Time zone in BIP .xpt templateSummary: How can we add the user preferred time zone along with Date and time in the BIP .XPT template? I am aware of the tags for RTF template but the requirement is to…
-
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli… -
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
SQL Query to extract Skill and Qualification Attachment URL?Summary: Content (required): Hello experts, please, could you provide the SQL Query to extract the attachment URL loaded in Skill and Qualification page? Is it possible …
-
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…
-
Not Able pull the Latest Location from "Workforce Management - Worker Assignment Real Time" subjectSummary: Hi, We created the new location and running the OTBI to get the data from subject area "Workforce Management - Worker Assignment Real Time" and has employee det…
-
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …
-
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…