Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM CloudSummary Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM Cloud – A Worked ExampleContent The business requirement is to cre…
-
I am looking for the field.Summary: Hi, I am looking for the column/field of "Does not meet the required criteria for the role" in ORC. Content (please ensure you mask any confidential information…
-
Query to get Requisition Template name in ORCHi, I have requirement to get Requisition Template name from Basic Information. navigation --> My Client Group - Hiring - Requisition (number) - Details - Basic Informat…
-
Analysis of employees assigned performance goals and not assigned performance goals for a goal plan?I have created an analysis using the Workforce Goals - Goals Status Overview Real Time subject area. I have selected the following subject areas and applied filters (scr…
-
How to default the Location of Logged In User in Dashboard PromptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…
-
Running an AOR report that includes who is assigned to the AORSummary: Is there a way to run an AOR report of who is assigned to each AOR and include whether the assignee is included or excluded from contacts. Content (please ensur…
-
FMLA Qualified Entitlement Balance ReportSummary Does anyone have a report that pulls balances on qualified entitlements?Content I am able to pull reports of absences but not entitlements. Since some absences a…
-
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Protecting Sensitive Data in Custom ReportsWhat is the most effective way to provide managers with access to custom reports without exposing sensitive employee data, such as ethnicity, date of birth, home address…
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …
-
Is there a way to fetch the schema of the HCM database ?Summary: I'm looking for ways to pull the sql schema of the Fusion database, so that I can utilize that data to give me autocomplete suggestions for building sql query r…
-
Public Holiday Report in BI PublisherSummary: Anyone has a sample SQL Code for the Public Holiday Report using BIP? I am currently having trouble connecting the PER_CALENDAR_EVENTS_VL to Node IDs to get the…
-
HCM Seniority Date v1 to v3We're currently in the process of migrating Seniority date from v1 to v3 and attempting to migrate all of our reports to these new fields. From what I'm seeing, legal em…
-
In which Table we can find the Safety Coordinator Name in Health and Safety ModuleSummary: 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 for Learning Plans and ProgramsSummary: Hello I need a query that gives the following attributes in the Learning module: Program Name Plan Name Plan Profile Name Plan Profile Creation Date Content (pl…
-
SCORM ReportingContent Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. Many thanks Melissa
-
Element Entries Subject Areas Not Working since Patch 24cSummary: We are patch testing 24c and a few of the subject areas are not producing any data. They are functioning correctly in Production, but not where the patch has be…
-
Report showing all ElementsSummary Need a report to show all element entries that have been created (Recurring and Non-Recurring)Content HI All, I hope this is a simple ask but I can't seem to fin…
-
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…
-
Report for Screening Services on Requisition TemplateWe are trying to report on screening services (Assessment and Tax Credit) on job requisition templates but when we output fields from Job Requisition Template - Screenin…
-
OTBI subject area for Document of Records descriptive flexfieldsSummary: Content (please ensure you mask any confidential information): Hello experts, we created custom fields within document type and we mapped them in OTBI. Where ca…
-
SQL to Show Which Pay Frequency is Associated to Which Legal EntitySummary: I am tasked with producing a mapping document of which Pay Frequencies are associated to each legal entity. I can find the Legal entities in "HR_LEGAL_ENTITIES"…
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat…
-
Table name for Assign As column in learning pageHi Experts, Can someone please help me with the table name for 'Assign As' column. Thanks & Regards, Dinesh
-
Person Seniority Real Time not showing resultsSummary: The "Person Seniority Real Time" subject area is not returning any results, even though we're currently using the Seniority Dates V3. Does anyone have a solutio…
-
Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Summary Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Content Hi AllWe have a requirement to build Employment letter, letter is in …
-
Query to get users deleted rolesContent Hi All, I am trying to fetch details of roles assigned to a user including the one deleted in the past. In ebiz we only had option to end date a responsibility b…
-
BIP notification sender nameSummary: Hello Experts, We have a requirement where we need to update the Sender name of the notifications being sent thru BIP, for example, Payslip notifications or not…