OTBI
Discussion List
-
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 12 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 151 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 11 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 21 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 61 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 91 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_ 22 views 2 comments 0 points Most recent by Siva Chittapragada-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 2 comments 0 points Most recent by Shashikanth Kumar P-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 94 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 …KanikaMahajan 22 views 1 comment 0 points 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 37 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_ 41 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 24 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…
-
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 2.4K views 4 comments 1 point Most recent by Mohamed Faramawy dev.-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 241 views 5 comments 0 points Most recent by Sandeep Nayak-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 641 views 4 comments 0 points Most recent by Connie Finck Payables, Payments & Cash Management
-
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 81 views 0 comments 0 points Started by SireeshaJaladi Payables, Payments & Cash Management
-
TAX reports output should be in Hebrew Language in Oracle FusionSummary: TAX reports output should be in Hebrew Language Content (required): Hi Team , We are looking for the TAX reports output should be in Hebrew Language, both heade…Spats 61 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Table details which stores Payment System Account name in Payment Process Profile setupSummary: We need table details which stores Payment System Account name in Payment Process Profile setup task Content (required): Version (include the version you are us…Nishanth B Jain 91 views 5 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Multiple Bank Accounts in Smartview Cash ForecastSummary Multiple Bank Accounts in Smartview Cash ForecastContent Hi I would just like to inquire if there is a way to do a multiple bank account view at the same time in…JOHANN CHRISTIAN MORDENO 38 views 3 comments 1 point Most recent by CA Nirmal Choudhary 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 101 views 2 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management