Category 81
Discussion List
-
How to insert an report dashbaord on a redwood page?How to include or embed an OTBI report/dashboard on a Redwood pageVaishnavi Phulsay 49 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is There a Delivered Bonus Statement Feature in Oracle Incentive Compensation?Summary: Is there a similar feature or functionality in Oracle Incentive Compensation for generating a Bonus Details Statement? Currently, we are using a BI Publisher (B… -
How to load employee into object group through HDLSummary: Client is asking bulk load of employee into payroll object Group any HDL simple .dat file Content (please ensure you mask any confidential information): Version…Ratan Nahak-Oracle 90 views 4 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM -
Is there a way to limit access to the worker assignment real time subject area?Summary: Hello, We have a "Learning Course Owner View All" data role that is essentially a learning admin. They have access to view all learning data including courses, …Tommy Sullivan 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba… -
Is the Ranking field in a workforce compensation plan available for reporting (OTBI)?Summary: I don't see this field but wanted to confirm if the Ranking field in a workforce compensation plan is available in OTBI or not? And if not, anyone know why it h…Cathy 18 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Does anyone have a Leadership Hierarchy prompt or guidance on how to create one?Hello Does anyone have a leadership hierarchy prompt? If so can you share some guidance on how it was created? I want to be able to add a leadership hierarchy onto our d… -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheethttps://us.v-cdn.net/6034893/uploads/XTAY0TAIX14K/rel13-24-x-bicc-hcm-database-mapping-with-viewobjects-xlsx.zip Summary This posting includes R13 HCM BI Cloud Adapter B…Rashmi M-Oracle 20.3K views 21 comments 11 points Most recent by Lauren K. 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 4 views 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 614 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 18 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 5 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 69 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 28 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 17 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 15 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
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 5 views 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 133 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 17 views 1 comment 0 points Most recent by Joey O-Oracle Recruiting, Opportunity Marketplace