Category 81
Discussion List
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…Rashmi M-Oracle 18.6K views 21 comments 11 points Most recent by Lauren B. Reporting and Analytics for HCM -
pass parameter in formula in otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…lbodeddula 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to obtain the history of when a role is assigned and revoked to a userSummary: Hello All, As an Audit Requirement we need the complete history of when access is provisioned to a role and it is revoked. The following table ASE_USER_ROLE_MBR…Dharma_Reddy 345 views 4 comments 0 points Most recent by Matt Sinclair Reporting and Analytics for HCM
-
Standard payroll reportsSummary: Hi All, Please share all the payroll standard reports list. Best Regards, SateeshSateesh Kumar M 16 views 4 comments 0 points Most recent by Sateesh Kumar M Reporting and Analytics for HCM
-
How to fetch custom attribute of Legal Entity in BIP?Summary: How to fetch custom attribute of Legal Entity in BIP? Content (please ensure you mask any confidential information): I have this custom field: I cannot see it i…Stefano_Mazzocca 2 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How to print data from different levels in the same line in Etext templateHi All, I am using EText template for HCM Extract which results in Employee having Multiple Balances. The Requriement is to display the employee record along with all th…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…
-
How to display a BIP Report in multiple excel sheetsSummary: How to display a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we would like to display the output of a…Barile Alberto 23 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Table FND_SESSIONS, columns FIRST_CONNECT and LAST_CONNECT, what do they mean?Summary: Content (please ensure you mask any confidential information): Can someone explain what FIRST_CONNECT and LAST_CONNECT columns in table FND_SESSIONS represent? …Stefano_Mazzocca 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we create custom views in Oracle fusion?Summary: Can we create custom views in Oracle fusion? We need to create the view to use it in a value set.
-
Unable to find Job Requisition & Offer DFFs in PVOsSummary: We are looking for the PVO(s) that shows the Job Requisition and Job Offer DFFs (IRC_REQUISITIONS_DFF & IRC_OFFERS_DFF). We have been unsuccessful viewing this …
-
How to list all locked users?Summary: How to list all locked users in BI Publisher? Content (please ensure you mask any confidential information): Table PER_USERS and PER_LDAP_USERS are related to u…Stefano_Mazzocca 2 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Which BIP table stores the attachments under Talent Profile?Summary: Which table stores the attachments under Talent Profile? Content (please ensure you mask any confidential information): I'm trying to fetch this attachment unde…Stefano_Mazzocca 13 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
About OTBI, BI and EXTRACTSummary: Use cases for OTBI, BI and EXTRACT. When we use Extract, when we use BI and when we use OTBI Content (please ensure you mask any confidential information): Hi T…
-
how to delete status processing rule using hdlSummary:How to delete status processing rule using hdl Content (please ensure you mask any confidential information): Version (include the version you are using, if appl…
-
Display date in a pivot table (both for OTBI and BI Publisher)Summary: Display a date in a pivot table (OTBI and BI Publisher) Content (please ensure you mask any confidential information): Hi, I wish to create a pivot table like s…
-
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…Azhar SIDDIQUI 1 view 1 comment 0 points Most recent by Azhar SIDDIQUI Reporting and Analytics for HCM
-
Certain talent dashboard is unable to fetch data for talent admin role in Redwood 25B InstanceSummary: In one of the 25B Redwood non-prod instances(eg. instance A) ,the below issue is encountered. There are multiple Talent reports and all are working as expected …
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
How to set a display order for the columns of a BIP Report (csv output)Summary: How to set a display order for the columns of a BIP Report (csv output) Content (please ensure you mask any confidential information): Hi, we created a BIP repo…Barile Alberto 39 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Career StatementsSummary: Creating a Career Development's analysis report and I am unable to locate Career Statement in the subject area. Content (required): Looking to add Career Statem…
-
How can we report on click tracking for all emails sent as part of a recruitment campaign?Problem Description: Our recruitment campaign includes two emails: Email A: Contains buttons such as "Option A" and "Option B," linked to campaign goals. The goal respon…GraemeHarper 15 views 1 comment 0 points Most recent by Joey O-Oracle Recruiting, Opportunity Marketplace
-
Unable to see terminated employee's View Compensation HistorySummary: I am unable to view the compensation history for terminated employees. Is this standard functionality and behavior in Oracle HCM Cloud? Could anyone help clarif… -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 161 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Report does not show Person Legislative information DetailsSummary: Our business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming b…AbhishekLahoti 97 views 11 comments 0 points Most recent by Ilmars K. Reporting and Analytics for HCM
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one…AjayKumar Maddipati 167 views 5 comments 0 points Most recent by Ilmars K. Reporting and Analytics for HCM -
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 954 views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
More details in the access Log in Oracle HCMAs administrators, we regularly download access logs to monitor user activity in Oracle. These logs provide a basic summary of successful and failed login attempts While…Annapia Penta 31 views 2 comments 1 point Most recent by Annapia Penta Reporting and Analytics for HCM