BI Publisher
Discussion List
-
Where Close date is stored in tables?Summary: Hello, do you know where Close date is stored in tables? See image Content (required): Payroll Version (include the version you are using, if applicable): N/A C…Nicola Petri 21 views 3 comments 0 points Most recent by Tim Hopkins Reporting and Analytics for HCM -
BI Publisher Solution ? - Start Excel Preview only open: falseSummary: Hello R&A forum: Start Excel Preview only open: false mTemplate: C:\Users\john.white\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls mT…User_2025-02-12-15-41-59-245 1.7K views 0 comments 0 points Started by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM -
BI Publisher Excel Template preview failsSummary BI Publisher Excel Template preview failsContent I am new to the use of BI Publisher Desktop in Word and Excel to create templates for BI reporting. I have a rep…Dena Swanson 205 views 7 comments 0 points Most recent by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM -
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…Meenakshi K 601 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fusion 22A/22B : Post P2T Issues in BISummary: Oracle has brought a big change in OTBI/BIP configurations during P2T where configurations will be copied to the Non-Prod instances from the Prod instances. Thi…User423246 71 views 3 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Termination Headcount causing errorSummary: Reporting Experts - We are trying to build a simple OTBI that should list the managers (Any level: Level 1 or level 2) with the direct and indirect reports. Whe…Vijay Rajendran 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Resume/CV extract from work history fields Using BI PublisherSummary: Has any one created a formatted resume report using BI publisher? I have a request to extracted work history entered by our employees who do not have resumes in…Charles Egegbara 1 view 0 comments 0 points Started by Charles Egegbara Reporting and Analytics for HCM -
Parameter based on list of values is not working in BIP reportSummary: Hi All, I have total 10 parameters based on list of values in the BIP report on which 5 are working perfectly fine but 5 are not giving any data in the drop dow…Arti P 203 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Issue when creating a BI report on Investigation QuestionnairesSummary: When creating an BI report on investigation questionnaires we are running into an issue where it is not possible to limit the investigation questionnaire to the…
-
Turnover report with custom column filterSummary: Hi Experts, our requirement is to create a turnover report with Active employees on the 1st of every month and the last date of every month, no of hires and Ter…Naveen setti 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
URL inserted into browser window allows access to report without securitySummary: Users able to run reports using direct URL access Content (required): We have identified an issue where our users can enter a report specific URL into a browser…Ruthie 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue in weekly schedule Bi report with effective date parameterSummary: Issue in weekly schedule Bi report with effective date parameter Content (required): Hi Team, Recently I was schedule a report which is weakly basis and it cont…
-
Candidate Pool Ownership TypeSummary: Content (required): Hello Guys, We would extract the Candidate Pool Ownership Type information from BI, but we don't find the correct table and field, someone c…Giuseppe Iacono 21 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Succession Plan BIP Report based on Job RoleSummary: Hello Experts, I have to create a Succession Plan BIP Report based on Job Role. Please help with a sample SQL/Report if you have worked on a similar requirement…Abhishek Premchandra-Oracle 81 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 930 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to split by page break with the date rangeSummary: Can we apply split by page break with in the date range? For example if we pass date parameters with in the 3 weeks date range, then report should pull 1st week…User_YPR68 21 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 21 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
How to split excel template into multiple sheets for each employeeSummary: We need to split the excel template into multiple tabs for each employee. For Example if any excel template has 3 employees in the output, then we need to split…User_YPR68 1.1K views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f…User720640-Oracle 330 views 4 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
in RTF how to use a parent attribute for comparison inside a child repeating group while summingSummary: In a rtf template we are trying to compare the value of child attribute to a parent attribute if the value matches then the sum of an child repeating attribute …Gadigeppa Boragalli 441 views 0 comments 0 points Started by Gadigeppa Boragalli Reporting and Analytics for HCM
-
Any way to find that scheduled BI report is running or got struckSummary:Any way to find that scheduled BI report is running or got struck Content (required): Hi All, We have scheduled a Custom BI Report to pull some payroll related d…Charan Kollipara 21 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
How to change path color for a node path in Hierarchy TreeSummary: Change color of the node path in Hierarchy Tree. Content (required): Hi All, We are creating a manager hierarchy tree report, our client wants to change the col…User_GFPRZ 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
List of All reports in BI PublisherHi Experts, Do we have any table or web service that can list out all reports present in a BI Publisher instance? So far we have used: XXXXX.oraclecloud.com:443/xmlpserv…Aloka Bhattacharya 541 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …Ridma Karunanathan 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H…MandeepGupta 12 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 145 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
BIP - Talent RatingsSummary: Hello, Good day! I'm running a report in BIP but facing performance issue when I'm trying to create multiple data sets. One data set for employee details and on…Hazel De Castro 31 views 0 comments 0 points Started by Hazel De Castro Reporting and Analytics for HCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (10 August 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM between 15 June and 10 August 2015: * Address Changes After Date * Marital St…Julian Challenger-Oracle 344 views 5 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 361 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Training, Documentation, FAQs and moreContent Just a reminder that there is a knowledge article on My Oracle Support that provides a wealth of information on HCM Cloud OTBI (and also some on BI Publisher). Y…Julian Challenger-Oracle 538 views 6 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM