BI Publisher
Discussion List
-
BIP email's font appear diffrent within gmail than outlookSummary: Customized email's fonts appears diffrent Content (required): I'm designing a BIP template with the kind of rtf format. I'm designing one of the journeys OOB re…Peleg Puzaylov-Oracle 21 views 5 comments 0 points Most recent by Peleg Puzaylov-Oracle Reporting and Analytics for HCM -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 203 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 16 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_…Ankit_Bhadja 981 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Oracle functions to calculate third quartileSummary: Content (required): Hello experts, we need to calculate THIRD QUARTILE for a set of employee salary amounts. The calculation should work in this way: For employ…Valerio Curzi 148 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to get Projected End Date?Summary: How to get Projected End Date? Content (required): Hello, we wrote the follow piece of SQL select pc.* --to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY') from PER_ALL…Nicola Petri 371 views 10 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 193 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
Question related to Knowledge base ArticleSummary: We have a subject area "Article Summary Historical Subject Area" in that we are looking at a attribute "Article View" where it related to the number of times us…
-
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 12 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
Is it possible to build custom reports retrieving data in more active workforce plans?Summary: Content (required): Hello experts, we need to build custom reports retrieving compensation components values and making analysis based on data loaded in several…Valerio Curzi 12 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…Venkatesan 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Application Composer tableHow to query custom objects in database - currently hitting HZ_REF_ENTITIES table which seems to store some of the record data, however not finding what table to join to…Michael A. Marthe 245 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Need information of HCM table which store multiple choice answers for any questioners?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Praveen D 58 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 122 views 3 comments 0 points Most recent by User_Sathishkumar Sundaresan Reporting and Analytics for HCM
-
BI Publisher Emergency Contact ReportSummary Building Emergency Contact Report in BI PublisherContent Hi Everyone, I am currently struggling in producing a BI Publisher report for emergency contacts, i know…User_2025-01-29-21-02-12-466 515 views 15 comments 0 points Most recent by Alexsky Reporting and Analytics for HCM -
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 23 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
tables for state tax and local tax setup in hcm cloudSummary: looking the tax class,tax_type,max_gross based on the tax class Content (required): Version (include the version you are using, if applicable): Code Snippet (ad…
-
BI tables to extract Contract attributesSummary: Content (required): Hello experts, which table allows me to extract PER_CONTRACT_LEG_DDF attributes; Italy Context? We need to retrieve the highlighted fields f…Valerio Curzi 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Position Vacancy ReportHello, does anyone know how I could report on vacant positions in HCM? I need to be able to report on both positions that are currently vacant, and positions that were v…User_2025-02-07-03-52-39-913 675 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 860 views 11 comments 2 points Most recent by ahmed alsharief Reporting and Analytics for HCM
-
Does anyone know which database table is used to report on Performance > Process Flow NameSummary: Creating a Data Model to report on Process Flows in relation to Performance Management. Does anyone know which database table is used to store/report on the Pro…Nigel Wiltshire-Oracle 51 views 10 comments 0 points Most recent by Ravi Tilekar Reporting and Analytics for HCM
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …
-
If you think you do OTBI really well and have a large portfolio - Can we connect?Summary: We are fairly new to OTBI (just implemented HCM) and struggling a bit with how to best govern scheduling, enhance performance of OTBI reports which at this time…Luke.esh 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need 'Work Order Number' details of Background check page Under Screening section In BIp ReportSummary: Need 'Work Order Number' details of Background check page Under Screening section In BIp Report Content (required): Hello Experts, I Need the Work Order Number …
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (Payroll-> Review Journal Entries) For An Employee Columns are: Accountin…Manoharan 48 views 1 comment 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Employee Missing PPM detailsSummary: Hi everyone, I need a query for those employees whose bank details are missing(PPM), If anyone has this query. Please share with me. Thank you.Saher 11 views 3 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM
-
LISTAGG Function Not workingSummary: Hi Team, Please help me debugging or optimize the below query. Content (required): The result: The result I want: Version (include the version you are using, if…Robinson Ng 36 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI create/edit/view accesshi, We have a requirement to give OTBI access to business users. business user should be able to create/edit/view report for all the subject areas Should not have access…Nivya Mathire 52 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM