BI Publisher
Discussion List
-
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 23 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 156 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] 12 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 19 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 -
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL …user10645928 5 views 1 comment 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
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 -
Budget Vs Actual in GL Account Group & SmartViewContent We have received requirement from user that need to generate a report through smart view tool to see the Budget Vs Actual under Fusion COA instance. Note: we got… -
AR Cash Receipt ReportingSummary: AR Cash Receipt Reporting Content (required): I am looking for information on when cash receipts are applied (and the application timestamp). Is there a subject… -
BPM expense tablesSummary: BPM expense tables, I need to know which tables are stored BPM screen information. I found only the approval rules for the procurement Content (required): Hi, c… -
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 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
GL Audit Data export from SAASContent We are in the process of GL Auditing with Audit agency, Any body could share the template of DM and REPORT from Oracle SAAS environment to EY. Version 21CNarenInova 25 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA General Ledger & Intercompany
-
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 36 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fixed Assets: Bifurcating Transaction Types for an Asset Facility by Major-Minor CategoriesSummary Fixed Assets: Bifurcating Transaction Types for an Asset Facility by Major-Minor CategoriesContent Hello All, We are working on a BIP report for Fixed Assets whe…
-
Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you…Lucky Sharma 52 views 3 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
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
-
21C Content counts are duplicatingSummary 21C Content counts are duplicatingContent Dear Experts, Please advise why the content counts seem to be duplicated. The course has only 4 contents after I update… -
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 …