OTBI
Discussion List
-
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 97 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 193 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 250 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 31 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 21 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 46 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 102 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 11 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 171 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 14 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 96 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 41 views 3 comments 0 points Most recent by Nipun_Garg Payables, Payments & Cash Management
-
Supplier Analysis Prompt not displaying from ReportsSummary: I created Supplier ACH Verification Analysis with prompt for user to select Supplier Name prior to displaying results, however when user opens analysis from Rep…Eybrown 1 view 1 comment 0 points Most recent by Veronique Gagnon Payables, Payments & Cash Management
-
Actionable Dashboard for AP Invoice Approval in Oracle Fusion CloudSummary: To approve bulk invoice all columns are not available in the worklist where the approver can view the columns and select and approve. So can we create a actiona…Jagjit Singh Arora 84 views 0 comments 0 points Started by Jagjit Singh Arora Payables, Payments & Cash Management
-
Request for Documentation on Fields Match for XML Document in IBY_TRXN_DOCUMENTS TableSummary: Hello, My team I are working on an H2H implementation for a client using the Oracle ERP Cloud system. As part of this implementation, I need to understand the s…Arturo Contreras 197 views 2 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Report Payables withholding tax and accountsSummary: Hello, We would like to know if there is a report to support the Payables withholding tax invoices and Tax Accounts Content (please ensure you mask any confiden…AN_ 21 views 2 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
IDR: Report to pull Invoice Account Coding HistorySummary: We would like to track account coding history as part of the invoice for reference and audit purposes. What is the best way to accomplish that? Content (require…Judy Hamner 102 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Can we create a rule to auto reject the invoices if particular account is found?We have a requirement to not allow the invoices (PO, non PO, boundary apps invoices) to be charged to 1***** account. This account can be used in other subledgers so we …KanikaGupta 21 views 1 comment 1 point Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Holds, Approval and Due payables infotile displaying data for all available BUsSummary Holds, Approval and Due payables infotile displaying data for all available BUsContent Team, User can able to see all available BUs information on the Holds, App…Surya01 35 views 5 comments 0 points Most recent by Arvi Dinavahi-Oracle Payables, Payments & Cash Management -
Payables OTBI Subject Area - Account Coding Intiated DateHi All, We are developing an AP KPI dashboard using OTBI . Wanted to check if the following field available in Payables OTBI subject area? 1. Invoice Account Coding Init…Devashish Saun 31 views 0 comments 0 points Started by Devashish Saun Payables, Payments & Cash Management -
OTBI - View employee hierarchy vs manager hierarchySummary: I am trying to write an analysis in OTBI which would provide a managers Level 2,3,4,5 Department vs an employee's Level 2,3,4,5 Department. I want to ensure tha…Scott_Turner_ 45 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management -
how to purge data files from ucm server for Import Payables programSummary: We have around 2000 datafiles appearing in datafiles Lov while submitting Load Interface File for Import program. Attaching the screenshot where the datafiles c…Sachin Kr Singh 25 views 2 comments 0 points Most recent by Sachin Kr Singh Payables, Payments & Cash Management -
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has… -
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…
-
Setting custom check format for APSummary: I am setting up custom AP check format first time. Need to know the steps, any document showing steps. Content (required): I need to add custom layout for AP ch…
-
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…
-
How to sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code…SireeshaJaladi 99 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP