OTBI
Discussion List
-
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 591 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 1 view 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 948 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 105 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
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 468 views 4 comments 0 points Most recent by Neal Foley 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 108 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 21 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 3.9K 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 131 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 165 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…User_JUCNT 11 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 12 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to Create a Grand Total Column in OTBI ReportSummary: We created a Payment advise report using the Payables Subject area, but the customer wants us to create a Grand Total column to Sum up all the columns, please h…Chukwuemeka Aniukwu 925 views 5 comments 0 points Most recent by Estefanía Payables, Payments & Cash Management
-
Customizing Payables Withholding Tax ReportSummary: I am looking to customize the Payables Withholding Tax report by adding another column to it. Whenever the report is moved to a different folder it flags the er…
-
General Accounting Entries link tax with initial amount in OTBIHi Could you please advise if, in the analysis or data model, there is any way to determine that the tax amount of 200 with the natural account X on line 2 is on the amo…Elyse Meouchi 51 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
Supplier Internal Profile changes table details that includes the New Bank details before Approval.Summary: Hi All, When user do changes in the bank account of supplier and internal profile change request submitted to approver. Approver can see Only the last 4 digits …
-
Code Combination ID field from Payable Invoices-Transaction Real Time subject Area for Invoice LineSummary: Distribution tab details are not available for an Interfaced Invoice prior to validating the invoice in Oracle fusion. We are trying to create an OTBI to displa…Sifat Shaikh 62 views 1 comment 0 points Most recent by Swapnil Nagvekar-Oracle Payables, Payments & Cash Management
-
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 558 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management
-
How to make US1099 report to be emailed to Vendor?Summary: Content (please ensure you mask any confidential information): Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .p…Vikram_Patel 11 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Create Deep Link for receipt attachment in the Oracle Fusin OTBI Expense ReportSummary: One of our customers is expecting us to add Receipt attachment Deep link to the Oracle Fusin OTBI Expense Report Content (please ensure you mask any confidentia…Shashikanth Kumar P-Oracle 121 views 3 comments 0 points Most recent by Baskar.Chakravarthi Payables, Payments & Cash Management
-
User facing Issue while saving OTBI reportSummary: The user is getting the following error while saving an OTBI report: Catalog object privilege validation failed for user to path . You do not currently have suf…
-
How to report on the last person who updated an invoice prior to it being validated?Summary: Have a need to report on AP clerk invoice count metrics and would like to know of a field other than Last Updated By to determine who was responsible for proces… -
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 11 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Regarding the security role required to access OTBIDespite assigning the AP role to the user, the AP OTBI is not displayed. It is likely related to security roles. Could you please tell me the security role required to a…yuyano-Oracle 31 views 3 comments 0 points Most recent by Swapnil Kashid 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 41 views 2 comments 0 points Most recent by SERGIO BARRETO Payables, Payments & Cash Management