BI Publisher
Discussion List
-
Accounts Payable Trial Balance Report - no detailsSummary: Why do I only see a summarized amount, when running Accounts Payable Trial Balance Report? How do I get details per supplier? Content (required): Version (inclu…Bo Tøpgaard 91 views 2 comments 1 point Most recent by Bo Tøpgaard Payables, Payments & Cash Management -
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …User_2025-01-23-23-03-09-078 177 views 15 comments 4 points Most recent by TarunAggarwal Reporting and Analytics for HCM -
AZA: Consecutive Absence ReportSummary: Hi team, We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater tha…Ahmed AZA 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42…Brad Kirschner 844 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Unallocated AORI've got sql to extract those who have an AOR allocated to them but im looking to do a cleanse on active AOR where a colleague isn't allocated. Does anybody have any tho…
-
BI Publisher - Can you FULL outer join?Summary: Full outer join in a BI Publisher is not behaving how I expect a full outer join should. Content (required): I need to do a full outer join on two sets of data … -
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 215 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 291 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 208 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 614 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 161 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