BI Publisher
Discussion List
-
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 19 views 5 comments 0 points Most recent by Chandra MAdasi Reporting and Analytics for ERP -
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 47 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 23 views 6 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
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… -
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 6 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 41 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… -
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe… -
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…Sreekanth Kandula 35 views 7 comments 0 points Most recent by Sreekanth Kandula Reporting and Analytics for HCM -
Fusion BIP Print Receivables Transactions with swiss QR bill / swiss QR codeSummary: We are searching for a Oracle Fusion Cloud working process on how to create and include a swiss QR bill (payment and receipt part) into the Print Receivables Tr… -
Fixed Asset approval status datasource in OTBISummary: Do we have OTBI subject area to create list of unapproved assets? A customer is creating OTBI report to extract unapproval asset list. If not is there any equiv… -
Retrieve User ListSummary: I would like to create a BIP report to retrieve a list of user information. Content (please ensure you mask any confidential information): Please let me know wh…higuchi 22 views 8 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us… -
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '… -
bi publisher with xml parameterSummary: Hello community, I have the following requirement: From OIC, I need to send data to a BI publisher so that it can return a PDF file containing the data I send. … -
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …Tauseef_Akram909 32 views 1 comment 4 points Most recent by Dawn Cawston - CPS Reporting and Analytics for ERP