BI Publisher
Discussion List
-
Report to fetch the timecard approver detailsSummary: Content (required): We have a client requirement to build a report to fetch the timecard approver details. Does anyone know whether it is possible to fetch the …Prajna Hegde 125 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Will RTF template support gif files?Summary: Will RTF template support gif files? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that su…GTS Narayanen 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Secure OTBI so user can see only 1 folderSummary: We are implementing EHS and want the safety managers to only see the EHS folder under the custom folder. Content (required): Do we need to apply permissions to … -
OTBI Subject Area or Query to retrieve Job Profile informationSummary: Content (required): Hello experts, is there an OTBI subject area to retrieve Job Profile information such as: ProfileItemId, ProfileId, ProfileCode, ContentType… -
Payroll Element QuestionnaireSummary: Looking for a query to Fetch the Payroll Element Questionnaire Details Can any body Please share a query to Fetch the Payroll Element Questionnaire details Cont…MilanMohanty 321 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BI Publisher - Bursting - Email Delivery Channel - HTML Message BodySummary BI Publisher - Bursting - Email Delivery Channel - HTML Message BodyContent All, Able to burst BI Publisher Reports and deliver them via email using: Email PARAM…User_2025-02-05-22-13-16-277 682 views 6 comments 3 points Most recent by M Tanatwi Reporting and Analytics for HCM -
Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationSummary Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationContent Hi All, Could you please suggest in which Subject Area/Attribute or BIP tab…
-
Remove White Spaces from RTF TemplateSummary: Hello All, Can any body please suggest on removing white spaces from RTF Template. In the the RTF template ->Right Click Paragraph ,We have tried to set the Par…MilanMohanty 1.6K views 1 comment 0 points Most recent by Natalia Rappleye-Support-Oracle Reporting and Analytics for HCM
-
Associate Roles with the FUNCTIONAL modules.Hi Experts, I have a question on the Roles defined in a Fusion Instance. Is there a way to associate a role with the module where it actually comes into play? I'm trying…Aloka Bhattacharya 22 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM -
Need inputs to use all secure views in the reportSummary: Need inputs to use all secure views in the report Content (required): If we want to display Core HR data like Person, Assignment, Position, Job, Department..etc…
-
How to use drilled down in BI Report when I use normal layoutSummary: How to use drilled down in BI Report when I use normal layout Content (required): I have graph in my BI report and what I want is - when we click on graph it sh…
-
User account data restriction issueSummary: Data Restriction issue. Content (required): Hi Team, Me and my HR using same admin user account. And in my organization we have one of the report called Leave B…
-
Transfer Dashboard's gear icon to the HCM UIHello, Our client has a requirement, in which he wants the user to have access to the page options (gear icon) of the dashboard in the HCM UI, in the exact same manner i…Ioannis Adamou 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to create multiple tabbed excel output using BI Publisher delivered layout (.xpt)Summary: Is it possible to create multiple tabbed excel output using BI Publisher delivered layout (.xpt) Content (required): Version (include the version you are using,…
-
How to get list of roles from systemSummary: Content (required): Hi Expert, We have a requirement to get all the roles we have in the system. So we just wanted to know how to get all the roles. Please sugg…Faizan Rashid 41 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Newer of two datesSummary: I'm looking for logic that will allow me to pull in two different types of hire dates (new hire date, re-hire date) and return the most recent date. Would I do …Scott Conaway 31 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
OTBI report agent is not sending emails to multiple employeesSummary: Created an OTBI report to pull Work Email of the employees and send a pre-set communication. It works when tested for one/two employees, but it does not send th…
-
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 12 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num… -
FND_SESSIONS recording delay?Summary: Is there a delay in the data recording for FND_SESSIONS Content (required): We created a report to get the user count of accesses, using FND_SESSIONS. We ran it…User_2025-02-12-18-16-11-815 32 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM
-
Oracle HCM Cloud: Where can I see the seeded Packages for BIP?Summary: Does Oracle have a list of DB packages that we can use for BIP? I saw this one "pay_balance_view_pkg" but I wanted to know if Oracle have a full list of package…
-
Provide Deep Link for a Performance Document inside a BI Publisher ReportSummary Refer to the direct Deep Link for Performance Document for Manager's feedbackContent Hi All, We are building a custom BI Publisher report that will generate Emai…Kalyan Amaravathi 144 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 698 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Restricting report access to read only using Application RoleHi, In HCM (Reports and Analytics), We are trying to restrict reports access to read only for particular users using Application role. For that created a new role assign…
-
Custom Data Model - ProfileApprovalNotificationSummary: How to custom the seeded data model in order to add flexfields Content (required): Hi, I need to add flexfields from one Profiles section (Honor and Awards) in …Alice Gouzy 132 views 3 comments 2 points Most recent by Alice Gouzy Reporting and Analytics for HCM
-
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 12 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
Provide Participant Feedback" link text needs to be changed in BI notification templateSummary Provide Participant Feedback" link text needs to be changed in BI notification templateContent We need to change link text in notification however unable to find…
-
OTBI Agent Email From, Reply-to, CCSummary OTBI Agent Email From, Reply-to, CCContent Hi all: Using an Agent, is it possible to alter the "From" email address and add "CC" and "BCC" email addresses? The c…User_2025-02-04-23-32-05-891 140 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
BIP table for pending approval assignees?Summary: We want to be able to get the list of assignees from an approval process/transaction, before it is completed. Content (required): If an approval process is stil…User_2025-02-12-18-16-11-815 43 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM