BI Publisher
Discussion List
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 344 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Custom data model for Invoice PrintSummary: We want to print invoices for bundle items, means display only the bundle price in the invoice print. Can we have custom data model? Content (required): Version… -
Dashboard Performance for performance document reating distribution no resultSummary: when open Dashboard Performance for standard line manager Dashboard , the result for performance document reating distribution not showing . Content (please ens…Mohammed Alharbi 21 views 1 comment 0 points Most recent by Mohammed Alharbi Reporting and Analytics for HCM -
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…Nidhi Chhajed 31 views 3 comments 0 points Most recent by Lakshmanji Karupalli Reporting and Analytics for ERP -
Can HCM OTBI output file be password protected like BI Publisher ReportSummary Can HCM OTBI output file be password protected like BI Publisher ReportContent Hi, We know how to BI Publisher report output file can be password protected with …User_2025-02-05-22-36-27-300 91 views 11 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Course completion certificate template is not available for selectionHi All, After going through following link I understand that to configure the Completion Certificate we first need to copy the seeded templates and move them to custom f… -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
Alternative ways to Schedule Reports, Agents and Report Bursting as opposed to using a Generic userSummary: We currently use a generic user which is against our IT internal controls (so have an open Risk we track). We are looking to establish if other customers have t… -
What are the control reports to be run on the fresh instanceSummary: We are going to start testing and want to run the control reports in the fresh instance. Could you let me know what are the control reports to be run. The modul…Lal11 31 views 3 comments 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 151 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …SSS Song 99 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec… -
how to change the hyperlink text in the workflow checklist tasks notificationSummary: I am trying to change the "More details" hyperlink to "Click Here". attached is the data model, xml output and rtf template screenshots any idea ? Content (plea…Shlomo Elnekave 11 views 1 comment 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
hi all, by any chance can you point me to the join between per_person_names_f and CMP_PLANS_BSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 31 views 2 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 81 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f… -
how to give user access to view invoices image from receivables UISummary: Business users are not able to see invoice image from receivables UI. But IF BI Administrator role is provided, then users are able to view image. We can't assi… -
How to fetch Level 1 department for a person via SQL codeWhats the sql code behind level 1 department in Worker assignment real time subject area? -
Create Accounting Execution Report Same as Accounting Automation?Summary: Our Accounting Automation report runs each night at 11:10pm and I am one of three who receive the email notification with the summary and the Automation Errors.… -
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 151 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM -
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 51 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
BI publisher PDF corrupted error after upgrading to Chrome browser to 119.0.6045.106Summary Content (please ensure you mask any confidential information): After upgrading the chrome browser, we encountered PDF corrupted error for BI publisher reports. W…Maria Inocentes 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Questions about Maintain Chart of Accounts Hierarchies processWe recently discovered we had an issue with a custom BIP report that was built for us by our implementation consultants. Long story short, we discovered that any new com…MDeming 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Not able to include file type attachments in Invoice Account Coding Email NotificationSummary: Trying to customize Invoice Account Coding Email Notification to include all invoice attachments hyperlinks in the notification, but we are not able to get hype…Chowdari Malapati Monika 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Trying to customize Receivables Aging by General Ledger Account ReportSummary: We want customized report output in excel format, where sheet1 should contain the parameters passed, sheet2 with detailed info in tabular format with customer a…Chowdari Malapati Monika 31 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Report for Changes OnlySummary: We are currently not able to pull out a report with the last change done for a person in the system. Content (required): We have multiple reports in Oracle base… -
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo…