BI Publisher
Discussion List
-
Reset the sequence in etext template when I have only one level where data residesExperts, I have to generate a sequence that resets after printing details for every person. The Cost_ID tag makes sure every record that is needed is fetched on the repo…Aloka Bhattacharya 52 views 2 comments 0 points Most recent by R Ravichandran Reporting and Analytics for HCM -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 94 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM -
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 194 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi…Christian Suarez 32 views 3 comments 0 points Most recent by Christian Suarez Reporting and Analytics for HCM -
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be… -
EEO Reporting for Federal, State and LocalHi all, Is there any document which tells us more about "Submit EEO-4 State and Local Government Report for US". Thanks, Sathish -
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated…
-
How to restrict performance data access in BIP report when having Frontend accessSummary: How can we exclude employees from a BIP report for performance, where the HR User has access to the employee information over the frontend but not to the perfor…Franziska Reichel 13 views 0 comments 0 points Started by Franziska Reichel Reporting and Analytics for HCM
-
Create a BI Publisher report to spool users whose password is expiring in next 14 daysHi Experts, I want to create a BI Publisher report to spool users whose password is expiring in next 14 days. Has anyone created something in these lines. Any inputs wou…Aloka Bhattacharya 21 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM
-
Find list of reports using a particular subject areaWe have 100s of custom reports. We are making some security changes at the moment and performing impact analysis at the moment. We want to find the list of reports that …Pradeep T U 102 views 2 comments 0 points Most recent by Pradeep T U Reporting and Analytics for HCM -
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 129 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 22 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 354 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 803 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.7K 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 25 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 13 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 42 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 33 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