BI Publisher
Discussion List
-
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without … -
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…
-
Why does the Oracle ISO20022SEPAV7_0 not convert characters that are not allowed by SEPA?Summary: Why does the Oracle ISO20022SEPAV7_0 seeded payment format not convert characters that are not allowed by SEPA? -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.3K views 7 comments 1 point Most recent by User_GMBW9 Reporting and Analytics for ERP
-
There is time delay to display requested absence information in the tables.Summary: There is time delay to display requested absence information in the tables ‘ANC_PER_ABS_ENTRIES’ and ‘FND_BPM_TASK_B’, Is there any other tables can be used to …AntonyD 7 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…Rakesh Viswam-Oracle 42 views 6 comments 0 points Most recent by Rakesh Viswam-Oracle Reporting and Analytics for ERP
-
Link to Linkedin CourseHi, we need to send the Oracle Course Catalog to an external system, for Linkedin Courses we want that users of external system will access direclty to Linkedin wihout p… -
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 527 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
How to convert column into HTML format in BIP datamodelSummary: OTBI column output: Here how same column appears in SQL Datamodel in BIP So, could you kindly help on how we can convert this Comment column to be displayed as …
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 32 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can we remove or hide the destination from Scheduling BIP ReportsSummary: We have users who run scheduled reports in BIP but we do not wish for them to be able reports using the email selector or send anywhere else. Is there a way to … -
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.4K views 9 comments 4 points Most recent by PranjulG Reporting and Analytics for SCM -
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 52 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…User_2025-02-11-06-12-35-024 903 views 12 comments 0 points Most recent by SurendraPB Reporting and Analytics for ERP -
delete value set valuesSummary: Good Morning Can I delete value set values (account values ) in the account segment took the wrong hierarchy by mistakeEsraa Yousef 25 views 6 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany
-
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaGupta 6.3K views 5 comments 2 points Most recent by Rakesh Sreenivasa Payables, Payments & Cash Management
-
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO… -
Where to store and print specific text on customer Accounts Receivable (AR) invoices?Summary: I’m using Oracle 25D, we have a business requirement to print supplier–customer specific text on Accounts Receivable invoices. The text should vary depending on…
-
Job Requisition Approval Workflow Template – Approval Comments Not VisibleSummary: Hi Oracle Community, I am working on the seeded Job Requisition Approval Workflow Notification Template in Oracle Fusion HCM and have run into an issue with app…Vishal Purohit 7 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
How to use the GL1025 File without having Oracle ExpenseSummary: I need to understand how to use the GL1025 File without having Oracle Expense . I cannot see the XLM behind that report to be able to modify this rtf correctly …
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
How to bind effective date parameter of HCM Extract to BIP Report's parameter and load HDL ?Summary: How to bind effective date parameter of HCM Extract to BIP Report's parameter and load the HDL file generated by BIP Report ? Content (please ensure you mask an…
-
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…yokokawa 71 views 2 comments 0 points Most recent by Takaomi_Kamakura-Oracle Reporting and Analytics for ERP
-
Custom Fonts Not Reflected in PDF Output – BI Publisher RTF Template (OLC Certification)Hi All, In the OLC module, our client provides certifications with text styled in custom fonts. I have uploaded an RTF template in BI Publisher and exported it to PDF fo…
-
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t…Valerio Curzi 43 views 2 comments 1 point Most recent by Diane Stuart Reporting and Analytics for HCM -
CIP asset AdjustmentSummary: Hello, Could you please suggest the correct approach to adjust or remove the cost for a CIP asset in Oracle Fusion Assets? We are encountering the following err…
-
What are the criteria for an AR invoice to appear on the Manage Revenue Adjustments screen in FusionHi All, We are planning to develop a BI Publisher (BIP) report based on the invoices that appear on the Manage Revenue Adjustments screen in Oracle Fusion Cloud. Could s…