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
-
How to report Open Requisitions with AS OF DATE parameterSummary: Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022. Content (required): I have an… -
Report shows no results for certain usersHello, We are facing an issue regarding the ability to view a report of the subject Area of Workforce Management - Checklist Real Time. Here is the report that we have c… -
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre… -
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j… -
Can we create a Reporting Tile as a shortcut to access OTBI reports?Summary: In OTBI, is it possible to create a Reports Tile or link for managers and HR staff so there is a shortcut to access reports? It is a lot to sort through and has… -
Worker Termination Alert fetching all termination dates (Older ones also)Summary: Hello Everyone, We have developed an alert using alert composer for triggering notifications when termination transaction occurs. But the issue is, we are getti… -
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. … -
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh… -
Is there another SOAP call that we can use to trigger BIP without exposing the Username & Password?Summary: We are currently using the SOAP wsdl below to trigger BIP report. Unfortunately client wants the username/password to be hidden in the SOAP envelope. Is there a… -
Subject areas to make analysis of BPM Transactions in OTBISummary: Subject areas to make analysis of BPM Transactions in OTBI Content (required): I need to make an OTBI Report to show the detail of BPM Transactions, including t… -
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I… -
Is there a way to monitor the performance of an environment via a dashboard somewhere?We would like to be able to monitor the performance of, in particular, our live environment and I cannot find anyway to be able to do this without needing to raise an SR… -
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… -
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 … -
Is there a seeded skills and qualifications report?Summary: Content (required): Is there a standard qualifications report? Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe… -
Requisition creation "use", which subject area is this data housed in?Summary: Trying to report on the requisition "use" field; see screenshot below, but unsure of which subject area this may be housed in? Content (required): Using the sub… -
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual… -
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio… -
User Role Membership Report SQL Query / TablesSummary: Hi Team, for audit purposes customer is requesting to know which tables/views at db level are being used to extract the seeded report "User Role Membership Repo… -
We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle DocsSummary: Hi Team, We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle Docs. Any one help me on ? Thanks, Ajay Content (required)… -
Risk/Impact columns pulls in one value and one blank value causing duplicate rows in OTBI?Summary: Subject Area: Workforce Profiles - Person Profile Real Time Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss" Content (required): Hi A… -
How to get the Top-Down Manager Hierarchy in OTBI expect CEO,remining Top down 3 Manager hierarchy.Summary: Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports like from CEO to employee Top level manager hierarchy to fetch in to the… -
1How to upload BICC extract files to UCM custom foldersSummary: We have a requirement to upload BICC extracts to UCM custom folder. By default, the files are getting uploaded to OBIAImport security group. Please help us in s… -
Is there any way to fetch real updated absence records via BIP Report?Summary: - Content (required): Background: Absence Management Module We currently need to capture the real updated absence records, distinguish which records are newly c… -
Do we get any performance issues by enabling BIP Audit reportsSummary: Do we get any performance issues while running any BIP reports after enabling BIP Audit reports access. Any suggestions please? Content (required): Version (inc… -
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I… -
How to Display DFF Attribute Date value to the Alert TemplateSummary: We have document of record DFF where the value is stored in table HR_DOCUMENTS_OF_RECORD column DEI_ATTRIBUTE_DATE2 , and we dont know how to display this value… -
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl… -
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep… -
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…