OTBI
Discussion List
-
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…Neal Foley 592 views 11 comments 0 points Most recent by Manisha Sujal Puria Payables, Payments & Cash Management -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…
-
OTBI-Cannot find "Structured Payment Reference" field in Cash Management - Bank Statements Real TimeSummary: I'm trying to create a report based on bank statement line items. The one field I cannot seem to find is the "Structured Payment Reference" (see attached). Are …
-
Payment details are missing using OTBI Payables Invoices - Transactions Real Time & Payables PaymenSummary: Payment details are missing using OTBI ( Payables Invoices - Transactions Real Time & Payables Payments - Payables Payments - Disbursements Real Time" ) the bel…
-
Display Latest Approver in Custom Payables InfoletSummary: Hi All, Currently, I have created a custom Payables Infolet, in which I added the "Approval Status" and "Approver" information. However, the application display…Ucup Maulana 29 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management
-
Update of Invoice Landing Page to add custom infolet/infotileHello, The requirement is to update the Invoice Landing Page to add custom infolet/infotile. We would like to verify if this is feasible. Navigation: Payables > Invoice …Mark Llasos 22 views 4 comments 0 points Most recent by Vasu Gurunarayana Chinni Payables, Payments & Cash Management
-
Conditional Signature Printing in Disbursement Payment File Formats Based on Fusion InstanceSummary: In the Oracle Fusion ERP seeded report “Disbursement Payment File Formats”, I need to conditionally print a signature in the check template based on the Fusion …Basavaraj Navalagi 11 views 0 comments 0 points Started by Basavaraj Navalagi Payables, Payments & Cash Management -
Receivables Source Missing in OTBI Payables Transactions Real Time Despite Appearing in Manage InvoiSummary: In Oracle Fusion OTBI, I’m trying to build a report using the Payables - Transactions Real Time subject area to track refund-related invoices. The report needs …Sejal Mehta 10 views 0 comments 0 points Started by Sejal Mehta Payables, Payments & Cash Management
-
OTBI AP Invoice real time is not bringing information when it is the second subject areaSummary: I tried to merge 2 subject areas (Fixed asset and Payables transaction real time). The Fixed Asset information is bringing the right data, but when added the se…Pablo Schenquerman 12 views 2 comments 0 points Most recent by A Lotfy Payables, Payments & Cash Management
-
OTBI How to filter column YTDI have a formula-based column that is based on other columns, and a table prompt using Accounting Period Name. I am trying to make this column to show values in Year-To-…
-
OTBI report looks different when opening from ERPOTBI report looks different when opening from ERP than when opening it from OTBI. I want it to look like in ERP, but I do not understand why it will not do this. The fie…
-
How can I report via OTBI on 'Source' field in Payables - Transactions Real Time?Summary: We have a request from the Business to include 'Source' field in a dashboard utilising Payables - Transactions Real Time. We've used the Invoice Source Code in …Fiona Marran 1 view 0 comments 0 points Started by Fiona Marran Payables, Payments & Cash Management
-
How to create a report in OTBI of Manage Payment Process Requests informationSummary: The customer needs to have the information regarding the related invoices in a payment batch. Content (please ensure you mask any confidential information): I a…SERGIO BARRETO 75 views 3 comments 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management -
Payables Invoices - Transaction Real TimeSummary: Extracting AP Data and PO status as well Content (please ensure you mask any confidential information): When selecting the required columns like invoice #, date…
-
In OTBI trying to pull Natural Account preSummary: We are creating OTBI report by combining the subject areas - 1. Payables Invoice - Transaction Real time and 2. Payables Payment Disbursements real time. We are…Mounika P 11 views 1 comment 1 point Most recent by Conor Pewterbaugh Payables, Payments & Cash Management
-
AP Invoice Validation Status DescriptionSummary: we have developed a OTBI report for Invoice details. While reviewing the report we noticed that there are a variety of validation status for Invoices. In order …Sathish Ravi 1K views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Payables, Payments & Cash Management
-
Do we have any standard report in Oracle Accounts Payable for Payment exception and EncumbrancesSummary: Business want to find the report for the below need. It looks we have no report, please advice Content (please ensure you mask any confidential information): Li…Kish_Hariharan 3 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to know what AP invoice approval rule was triggered for a particular invoice?Summary: How to know what AP invoice approval rule was triggered for a particular invoice? Content (required): How to know what AP invoice approval rule was triggered fo…User_2025-03-10-23-59-44-230 1K views 5 comments 2 points Most recent by Prudhvi_S-Oracle Payables, Payments & Cash Management
-
Some of the fields in the OTBI subject area are not populating valuesWe are trying to select "check number" from the OTBI subject area "Payables Payments - Disbursements Real Time" but the field results no values in it due to which the da…
-
Need SQL QUERY for PPR details along with terminated status with no installments and stageNeed SQL query for PAYMENT PROCESS REQUEST details in oracle fusion cloud along with terminated batches where status='no available installments'Renuka Chougule 255 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Check format using oraMICR fontSummary: Check format using oraMICR font Content (please ensure you mask any confidential information): Hello, I am implementing a check format for JP Morgan's payables …MARIANA25 161 views 6 comments 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management -
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 80 views 4 comments 0 points Most recent by b nightingale Payables, Payments & Cash Management
-
how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_AllSummary: how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_All Content (required): Business wants to see the list of invoices in BI Report whe… -
Query to get tax registration from supplier address levelSummary Tax Registration from Supplier AddressContent Hello I was wondering if you can share with me any SQL to get the Tax Registration at the address Level. I have the…gabriel kinovisques-163562 4.2K views 6 comments 1 point Most recent by Ch M Prasad-Oracle Payables, Payments & Cash Management
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 132 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Self Service related Privilege's for Oracle Fusion PayablesSummary: We are looking Self service related Privilege's to Invoice Payables. The below two privileges provide access to Payables and are considered part of the license …Linga Murthy 217 views 4 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Meaning of Invoice Hold Notification ContentSummary: The Invoice Hold Notification has the PO Number, Invoice Line Number. I am not sure what is the "1" Content (please ensure you mask any confidential information…Pablo Schenquerman 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
What are the tables to view the Invoice Account Coding ID 2507811.1Summary: Which fusion table will have information of Initiate Account Coding, to write a SQL query Content (please ensure you mask any confidential information): Initiat…Ravi Kumar N 20 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to add components under payables landing page in oracle fusion to create an infolet tile.How to add user defined component under Payables> Invoices in Oracle fusion to display the count of Not validated invoices. Attached the Screenshot below: I have tried w…MitaliMeshram 15 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management