OTBI
Discussion List
-
Extract all the financial transactions pending for approvalHi All, We have a requirement to create a single report to fetch the details of all workflow transactions (Invoice Approval/Requisition Approval /Purchasing Document App…Truptesh Solanki 11 views 2 comments 0 points Most recent by Rohit Kumar Singh Payables, Payments & Cash Management -
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 31 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management
-
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 200 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
Payables Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked by one of our internal auditors the following 2 questions specific to the Oracle Accounts Payable module: List the specific tables and fields wh…K Hart13 71 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Read only user unable to open standard dashboard report. how to get required privilege for report.Summary: We have Auditors user having read only role access and also given standard dashboard report access but report not opening. Content (required): for e.g standard …AmitD 31 views 3 comments 0 points Most recent by Lakshmi Prasanna Bandaru Payables, Payments & Cash Management
-
Need Payable Invoice DeeplinkSummary: Need to know which Payable Invoice deeplink can be used in OTBI to show AP invoices related to POs Content (required): Version (include the version you are usin…Arunima Pandey 21 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Payment infotile on the Invoices landing pageSummary: Starting Update 22C, the Payment infotile on the Invoices landing page is no longer be available. Has anyone recreated the Infotile, and can share? Content (req…AVorster-Oracle 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
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 SATYA123-Oracle 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 101 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 11 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 72 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 181 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 61 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 51 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 41 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 21 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 71 views 2 comments 0 points Most recent by Syed Irshad Ali Payables, Payments & Cash Management