OTBI
Discussion List
-
24B FTP server errorSummary: We have certain BIP Reports setup in various environment and most of them have no issue except Dev1 environment, which was updated on 24B and when reports jobs … -
Is there any available CFO and payables dashboard in reports and analytics?Summary: Is there any available CFO and payables dashboard in reports and analytics? Content (required): Version (include the version you are using, if applicable): Orac…Zeinab Nabil 61 views 3 comments 0 points Most recent by Mirza Muhammad Mohsin Baig Payables, Payments & Cash Management
-
OTBI - Accounting status of paymentHi! Is there another column available in the OTBI report that exclusively indicates the Accounting status of payments? We'd like to display whether the payment is "Accou…Anne Nicole 31 views 1 comment 0 points Most recent by User_H0BZG Payables, Payments & Cash Management -
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…salma_essam 81 views 2 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management
-
Which table Stores the AP Invoice Mail Received Date by the IDR and Process Date by the IDR?Summary: I'm creating a custom report and I need to add the Dates when Mail Received by the IDR and Process by the IDR. I refer from the OOTB report (IDRImageTraceabilit…James Canaber 31 views 2 comments 1 point Most recent by Brian Burns Payables, Payments & Cash Management
-
Join Validated Date to Invoice Details in OTBI Data ModelSummary: We are trying to write a query in OTBI to create a data model that joins Validated Date and Validated By to Invoice Details. In running the query below, we noti…hannah_barry 11 views 3 comments 0 points Most recent by hannah_barry Payables, Payments & Cash Management
-
I need a query to get Payment Method , Payment Category descriptionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bahaa 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Store signature in cloud (employee DOR or somewhere) to be used in the reportSummary: In EBS we used to be able to store the employee signature in the DOR, then we used the image in the PDF reports (like tax certification). We wanted to do the sa…
-
IDR Image Processing Status automatic emailIs there a delivered or modified approach that teams have identified to automatically send an email to the sender of an IDR email to confirm that an invoice has been cre…ThomasScott 71 views 5 comments 0 points Most recent by Sourav Parbat Payables, Payments & Cash Management -
Work Confirmation with Invoice details reportSummary: PO Work Confirmation with Invoice details report Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
Invoice NotificationSummary: Is there an option to enable notification to requestor when invoice is uploaded to the supplier portal. Content (please ensure you mask any confidential informa…
-
what is the information get by Payment History Posted Status-OTBIIt's confusing what is the right criteria we should used to view the accounting status of payment. Could you confirm whether the criteria for viewing the accounting stat…Anne Nicole 12 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
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 …
-
Webservice or REST API to fetch Data from OTBI Seeded ReportSummary: We are in need of a Webservice or REST API to fetch data from OTBI Report Content (required): We are trying to get data from seeded OTBI Report through webservi…Neha Bhatt 41 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Is the accounting status of payments accessible in OTBI?Currently, only the accounting status of invoices appears in the criteria. Could you please specify the location column for the accounting status of payments?Anne Nicole 61 views 9 comments 0 points Most recent by Anne Nicole Payables, Payments & Cash Management
-
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 84 views 3 comments 0 points Most recent by Boying Payables, Payments & Cash Management
-
Oracledatatable for supplier masterdata fieldsSummary: In an external application, we are creating checks on Supplier master data information combined with data from other sources. For 2 checks we need the data fiel…Daniel.Hut 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Anyone having issues post 24A upgrade with OTBI analysis using the Payables Invoice subject area?We have several reports using the Payables Invoices - Transactions Real Time subject area that are not working as they did before the 24A upgrade. As soon as a filter is…Kristina P 161 views 7 comments 1 point Most recent by Kristina P Payables, Payments & Cash Management -
How to get the PO number from AP Distributions in OTBI?Summary: We are creating an analysis using "Payables Invoices - Transactions Real Time" and when trying to get Purchase Order number from Invoice Lines, it appears blank…Arshad Hanif 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Payments approval details not available in BPM history tablesSummary: Hi Team, There are approval rules setup to handle the 2 level approvals of payment process requests. However the payment approval data is not getting stored in …Shashank Shekhar 52 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Reference number in system transactionsSummary: Could we change the reference in system transactions for bank reconcilliation? The reference column and transaction number is populating same data. Could this b…Dhevina 42 views 8 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
What is the subject area and column that holds the Cash GL Accounts of Bank AccountSummary: Can you help me find the OTBI subject area column name to get the Bank GL Account? Front-end navigation: Setup and Maintenance Subject area: Financial Functiona…Earth place 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to reconcile MPA invoices vs GL Trial Balance ?Summary: How to reconcile MPA invoices vs GL Trial Balance ? Content (required): Hello We have several invoices in AP that were transfered to GL in summary hence I was w…Cesar Saveedra 63 views 2 comments 0 points Most recent by Syed Irshad Ali Payables, Payments & Cash Management
-
Download in bulk AP invoices in PDF - one pdf per invoiceSummary: How to download in bulk the AP invoices in PDF - one pdf per invoice? Content (please ensure you mask any confidential information): Hi, We need to download in …Teodora Bulancea 62 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Option to get Payment UTR number on Separate Remittance AdviceSummary: Hi Experts, Is there any way to get UTR number, received from bank through MT940, to be visible in the Separate Remittance Advice sent to supplier? Content (ple…singhankitj1 42 views 2 comments 0 points Most recent by singhankitj1 Payables, Payments & Cash Management
-
OTBI folder permission segregationHello, I am working for a client that has multiple subsidiaries ( in UK, IN France, in USA etc) and all of these subsidiaries have distinct folders with distinct OTBI re…Vlad CONSTANTIN 33 views 0 comments 0 points Started by Vlad CONSTANTIN BI Publisher Learning Center
-
Fusion 20C: Custom CM Dashboard not visible to some users?Summary Fusion 20C: Custom CM Dashboard not visible to some users? Cash Manager already assigned but still not able to access the dashboard.Content Hi Experts, Fusion 20…User_87I2Y 62 views 2 comments 2 points Most recent by Georgina Catchpowle Payables, Payments & Cash Management
-
How To Use SQL To Return Audit Of Supplier Bank Account Changes ?Summary: How To Use SQL To Return Audit Of Supplier Bank Account Changes ? Content (please ensure you mask any confidential information): Hello We have enabled the Suppl…Cesar Saveedra 101 views 2 comments 0 points Most recent by User_25PXG Payables, Payments & Cash Management
-
Need to allow holds resolution routing for system invoice Hold codeSummary Need to allow holds resolution routing for system invoice Hold codeContent Hi, For our user case, we need to allow holds resolution routing for system invoice Ho…Mohamed jouini 219 views 4 comments 1 point Most recent by AmitGoel 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…Kumar 57 250 views 2 comments 0 points Most recent by Basavaraj N Payables, Payments & Cash Management