OTBI
Discussion List
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
Receipts created in spreadsheet are not getting applied to the AR invoices automaticallyI am trying to load receipts from the ADFDI "Create receipts in spreadsheet". I do pass the customer name, account number and reference as transaction number and transac… -
Remittance Bank cash accountI have a requirement to build a custom BI report which shall report on all the segments of the cash account used at the remittance bank setup. While creating a receipt t…KanikaMahajan 2 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
How to add a Customer DFF in OTBI ReportSummary: We want a Customer DFF (Party & Sitre Segments) in the OTBI report. Unable to find the DFF. Content (required): Version (include the version you are using, if a…Siddhant Aggarwal-Oracle 21 views 4 comments 0 points Most recent by Siddhant Aggarwal-Oracle Receivables & Collections -
Working deeplinks/OTBI drill down for CollectionsSummary: Has anyone managed to get the following collections deeplinks to work: Collections (AR_TRANSACTION,PAY) Collections (AR_TRANSACTION,PROMISE) Collections (IEX_CU… -
Bill Management - DashboardsSummary: Hello, my client was wondering if it would be possible to add dashboards with infolets and external links outside the system to the external/customer view of Bi…
-
Deep link to edit customer Account not workingSummary: I am trying to create a report with the drill down option to 'Edit Customer Account' page, however its opening the manage customers page (search page) and not t…
-
Add Description to Customer StatementsSummary: We need to add a description to our customer statements letting the customer know what the invoice listed on the customer statement is for (what they are billed…Robert G Wilkinson 1 view 0 comments 0 points Started by Robert G Wilkinson Receivables & Collections
-
Default Revenue account for Credit Memo lines not defaulting correctlyContent Hi Would like to kindly seek help as when we are creating a credit memo, the default revenue account combination is not exactly defaulting as some of its segment…JOHANN CHRISTIAN MORDENO 2 views 2 comments 0 points Most recent by Krishna Sharma Receivables & Collections
-
AR Cash Receipt ReportingSummary: AR Cash Receipt Reporting Content (required): I am looking for information on when cash receipts are applied (and the application timestamp). Is there a subject…
-
Is there a list of tables where the "Manage Geographies" setup is stored?Summary Looking for SQL Tables for the Manage Geographies setupContent Someone has setup some Geography data in the Manage Geographies setup pages which include some hie…Patrick Bonahoom 19 views 2 comments 2 points Most recent by Patrick Bonahoom Receivables & Collections -
AR Cash ReceiptsSummary Which Role gives us the access to print AR Cash Receipt Print report?Content Which Role gives us the access to print AR Cash Receipt Print report? Version 21BKanika Mahajan 17 views 1 comment 0 points Most recent by Daniel Stanislav-Oracle Receivables & Collections
-
Include Unbilled PPM invoices in Available Credit CheckContent Our client woul like to leverage the Credit Management module, however they are having difficulties with the available credit calculation. The available credit o…Suzette Dixon 11 views 1 comment 0 points Most recent by Mihaela Cozma GL_Oracle-Oracle Receivables & Collections
-
How to record more than 350 Character in DFF fusion AR Cloud ?Summary How to record more than 350 Character in DFF fusion AR Cloud ?Content Hello This is the business requirement , we need to store QR code string in DFF which is gr…gabriel kinovisques-163562 20 views 2 comments 2 points Most recent by gabriel kinovisques-163562 Receivables & Collections
-
Account Reference InformationSummary Provide account reference to customers requesting on accounts looking to add businessContent We have customers on a regular basis coming to us asking for referen…
-
Bad Debt report CustomizationSummary What are the best steps for customizing a bad debt report?Version Oracle Fusion R13 -
How calculate Customer opening Balance and Closing BalanceSummary How calculate Customer opening Balance and Closing Balance for Customer transaction ReportContent Hi Guru, As i am new to AR , wanted to understand , how to calc…Rohit Soni-259808 21 views 1 comment 2 points Most recent by Manwesh Jain-30070 Receivables & Collections
-
Update Customer Tax Profile - Fiscal Classification CodeSummary Update Customer Account's Tax Profile - Fiscal Classification CodeContent Hi All, To give you a background: We have new customer accounts created in our AR Syste…
-
Translated Customer NameSummary Translated Customer NameContent How to get Translated Customer Name as we are uploading Customer into English but we need invoice report in both language "ENGLIS…Sandeep Nihalani 28 views 3 comments 4 points Most recent by Baskar.Chakravarthi Receivables & Collections
-
R13 Please Share an SQL/OTBI to get Customer Detail InformationSummary SQL to get Customer Detail InformationContent Hello : As far as I know there are not any Customer Contact Listing Report avaliable , Hence I was wondering if you…gabriel kinovisques-163562 33 views 3 comments 2 points Most recent by Manwesh Jain-30070 Receivables & Collections