OTBI
Discussion List
-
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 85 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 17 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
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 82 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 73 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 283 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 27 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 - National Heritage Academies 166 views 7 comments 1 point Most recent by Kristina P - National Heritage Academies 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 72 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 64 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 61 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 25 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 86 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 304 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 124 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 38 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 68 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 279 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 253 views 4 comments 1 point Most recent by AmitGoel Payables, Payments & Cash Management
-
Supplier AgingSummary: We want to develop a custom report basis on the payables aging as on date Content (please ensure you mask any confidential information): Is there any specific t…V.Bharath 47 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
The table AP_AWT_GROUPS from the tables and views for financials not bringing any dataSummary:The table AP_AWT_GROUPS from the tables and views for financials not bringing any data while AWT_GROUP_ID from AP_INVOICES_LINES_ALL bring data Content (please e…Mariam Umar 40 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Process Electronic Bank Statements - How to change SFTP passwordContent Our "Process Electronic Bank Statements" scheduled process stopped working in March when the SFTP password was changed and our Finance department just noticed. O…John-SCC 51 views 6 comments 2 points Most recent by Norman Jee Payables, Payments & Cash Management -
How can we define. aba format file for payments?We have a third-party vendor who validates the payment file in ABA format before a payment file is shared with the bank. So, our request is how do we generate an. aba fo…Veera_CPS 109 views 4 comments 1 point Most recent by Veera_CPS Payables, Payments & Cash Management
-
Invoice Distributions Prepayment amount remainingHello We are creating a report to reconcile prepayment in OTBI. We are facing a case that the "Invoice Distributions Prepayment amount remaining" field for unpaid prepay…Kamonwan Srasrisom 16 views 2 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management
-
AP Invoice Account Coding initiation dateSummary: which fusion table will have information of AP invoice Accounting Code, Initiation Date to write a SQL query Content (required): AP Invoice Account Coding initi…Harish Pati 177 views 2 comments 0 points Most recent by James Canaber Payables, Payments & Cash Management
-
Requires to have a Cash Flow Report?Hi, We require to have a cash flow report, appreciate if you can provide any existing reports or subject areas which can be used in creating the report, and any inputs y…Janitha Perera 17 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Negative Vendor_Id values in AP_INVOICE_ALL TableSummary: We can see -ve vendor id's in AP_INVOICES_ALL table which are not available in POZ_SUPPLIERS table at all. We understand that this is expected behavior in scena…PradeepKrSingh 135 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
Update Separate Remittance Format RTFSummary: We would like to add the bank account account name and bank account alternate name from the supplier banking information in the separate remittance RTF. There i…Clare Paone 44 views 3 comments 0 points Most recent by Nipun_Garg Payables, Payments & Cash Management