BI Publisher
Discussion List
-
Customize the CourseCompletion Certificate in LearningSummary: Looking for steps to customize the CourseCompletion Certificate report. Content (required): I have a requirement to customize the CourseCompletion Certificate r… -
OTBI report Timing outSummary: Content (required): I am pulling some payroll data using an OTBI but it keeps timing out- How do I increase the time? I can't schedule since I created a DM usin…Riti Malhotra 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Bursting - Multiple Templates - Multiple DestinationsSummary: Bursting Query for sending email notifications to an employee and line manager, each with their own template. Content (required): Hello, We have a requirement w… -
BIP Query to pull unapproved/pending absences from last 10 daysHi Team, Could you please help me with the BIP Query to pull unapproved/pending absences from the last 10 days? It would be great if you can share DM or query for the sa… -
Performance Issue in OTL BI reportSummary: Performance Issue in OTL report Content (required): We have existing report on OTL which is taking 3-4 minutes for generating data. Is there anyway that we can …Priyanka More-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
FAH to GL reconciliation reportSummary: FAH to GL reconciliation report Content (required): Hi All, I am looking to prepare FAH to GL reconciliation report. This report should provide the details of a…Mayank Patni 151 views 1 comment 0 points Most recent by Harshad N Godbole Subledger Accounting & Accounting Hub -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,… -
BIP Report to read file from UCMSummary Need to read file in UCM using BIP ReportContent Hi Team, Could you please let us know whether it is possible to read file from UCM via BIP report ? If anyone ha…Uvaraja-Oracle 213 views 7 comments 0 points Most recent by Rory Mullin Reporting and Analytics for ERP -
Read a file from UCM via Web Service as Private Data SourceSummary: Read File from UCM Web Service BI Publisher Content (required): We need to be able to read a file from UCM utilizing a data model in BI Publisher. We were able … -
PPR Disbursement Payment File Format - Error importing Custom TemplateSummary We used to import Custom Template in a Standard Oracle Report (Disbursement Payment File Format for PPR) but now it's not allowing or erroring outContent Hi, We …
-
OTBI in Sales InfoletHi Please help to understand how to add OTBI report in Sales infolet ThanksMohammed Rafi 11 views 4 comments 5 points Most recent by Mohammed Rafi Reporting & Analytics for Sales -
OTBI Publisher Report Job Skips even if there is data in the trigger and modelSummary: Oracle BI Publisher Report Job which is scheduled every 30 minutes gets skipped even if data is returned by the trigger Content (required): I have a scheduled r…User_2025-02-07-06-48-53-251 431 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
Changing Font color dynamically in rtf template is not workingSummary: Changing Font color dynamically in rtf template is not working Content (required): I am trying to change text font color dynamically. but it is not working. For…Manoj_Singh 295 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
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 215 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 612 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
PGP Payment File Encryption and Decryption of MT940Summary Need to sign payment files generated via BI Report with Oracle PGP private key and encrypt the payment file using Bank public PGP keyContent We have this require…Christian9-Oracle 160 views 1 comment 1 point Most recent by User_5XX7A Payables, Payments & Cash Management -
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 -
We have a requirement to send an encrypted payment file to bank from oracle system.We have a requirement to send an encrypted payment file to bank from oracle system. Bank is not willing to provide any encryption keys. How can the above requirement be …Kanika Mahajan 31 views 1 comment 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management -
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 -
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 201 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
Custom Course Completion Certificate for Specific BusinessSummary: Business is looking to have course completion certificate for their learners. Content (required): One of the businesses is looking to have a specific course com… -
GL Trial Balance Report Custom TemplateSummary:We've created custom template for TrialBalalnce.xdo, But still ESS job is taking standard template.Is there are changes required in configuration to pick custom … -
How can we do a bulk update of Expense Report Status via SOAP UISummary: We need to change the status of some 1000+ Expense Report numbers to "MGR_REJECTED". We know how to do this via SOAP UI one by one. But since there are so many …