BI Publisher
Discussion List
-
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…Yaniv 21 views 5 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…User_VR8E0 57 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 103 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include…
-
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 11 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 281 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
In a scheduled report send outcome only if the result of a specific query is 20Summary: In a scheduled report send outcome only if the result of a specific query is 20 Content (required): We need to count the number of extract run. If the result is…Nicola Petri 21 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 71 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Not able to view entire data in assignment and performance related subject areaSummary: I am using performance document status Real time/worker assignment real time subject areas but in the respective subject area I am able to see only my record. I…Kamini Kaushik-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
For how long the Job Run History of a BIP report is maintained in Oracle Fusion?Summary: Content (required): Hi Team, For how long, the report job history for a BIP report is available in Oracle Fusion? How often the history is purged? Is it configu…MandeepGupta 21 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Not able to view entire employees details in Subject area only able to view own recordSummary: I am using Assignment and performance related subject area to fetch details of employee but when I am using my subject area it is only displaying only my data. …Kamini Kaushik-Oracle 141 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to integrate data to our custom web site using data module build in Oracle BI PublisherWe are building intranet for our office and we want to use the data available with oracle BI publisher. We have already created data module in BI Publisher but currently…Kiran Kancherla 11 views 2 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
How to connect two data groups using number DBI and text DBI in HCM Extracts?Summary: In sql we can use to_char(HDOR.documents_of_record_id) = to_char(FAD.pk1_value) but in HCM Extracts is there any way to connect. Please help me on this. Content…User_2025-02-05-14-11-28-072 31 views 0 comments 0 points Started by User_2025-02-05-14-11-28-072 HCM Extract -
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Administration-->Bi Publisher/Manage BI Publisher-->Runtime Configuration/Properties Refreshed?Content Hi there, I searched My Oracle Support and the Community, but wasn't able to find any documentation regarding the following: Any knowledge/documentation regardin…Karen Long 18 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM -
PDF Template with XML tagsSummary PDF Template with XML tagsContent I have a requirement to upload a PDF template to the report. And the report should populate employee name, date to the PDF when…Prabhu Krishnamoorthy 19 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM -
Not able to generate csv file which has both English and ArabicContent Hi, I am not able to generate pipeline delimited csv file which contain both English and arabic values. Arabic text is replacing with some other characters in CS…Nivya Mathire 20 views 6 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 211 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Work structure reports for Oracle HCMSummary Work structure reports for Oracle HCMContent Do anyone have list of reports which can help pulling the work structure details from the configuration tables - JOB…Prabhu Krishnamoorthy 35 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…Padamatinti Varsha 20 views 4 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
How to read Planned Schedule informationSummary Which tables are involved?Content Hello, which tables do we need to use to read Planned Schedule information? Please see the attached image. Thanks, NicolaNicola Petri 18 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BIP Report Export Issue for Excel FormatSummary BIP Report Export Issue for Excel FormatContent Hi Experts, BI Publisher Report able to generate in PDF, where as if we try to export in to Excel, getting error … -
CR/LF values in rtf template issueSummary CR/LF values in rtf template issueContent Hello All, We developed an interface file and this file will be read by mainframe system. I am seeing a strange issue t…
-
RTF with more than 30MBSummary RTF with more than 30MB Content We have template a RTF template with more than 30MB file which is employee handbook have lots of images. Since its more than 30MB…Prabhu Krishnamoorthy 42 views 2 comments 1 point Most recent by Sandeep19rm Reporting and Analytics for HCM
-
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil_Makhiza 46 views 11 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac…Aloka Bhattacharya 18 views 2 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM