OTBI
Discussion List
-
How to update ORIG_SYSTEM_REFERENCE filed of HZ_CUST_ACCT_SITES_ALLSummary: customer site was interfaced with wrong ORIG_SYSTEM_REFERENCE value to EPR fusion from an external system. Now we encountered error when tried to interface cust…Mohamed Iqbal Jahangeer 43 views 8 comments 0 points Most recent by Mohamed Iqbal Jahangeer Receivables & Collections -
Receivables Aging by General Ledger Account ReportSummary: We are trying to develop a new custom aging report as to ease the reconciliation and make some custom column but we are not able to match the report with the st…Shadaab Ahmed 28 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Receivables Aging by General Ledger Account ReportSummary: We are developing a custom report to show us aging 13 buckets we are not able to reconcile it with the standard we are facing issues with credit memo refund pro…Shadaab Ahmed 29 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
How to show CR and DR account combination in two lines with correct transaction amount in OTBISummary: How to show CR and DR account combination in two lines with correct transaction amount in OTBI analysis? Content (please ensure you mask any confidential inform…
-
Import AutoInvoice Successful Transactions ReportSummary: Is there a report which lists down details of all transactions that were successfully interfaced into Oracle AR (not just the count)? Content (please ensure you…Francine Gemora 33 views 2 comments 0 points Most recent by Francine Gemora Receivables & Collections
-
What is the current OTBI export limitSummary: What is the current OTBI export limit in Oracle Fusion? Content (please ensure you mask any confidential information): Version (include the version you are usin…CarmenR. 22 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
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… -
Advice on Printed Transaction in OTBI subject areaSummary: OTBI Receivables subject area is there a field which is a result of 'DELIVERY_METHOD_CODE' from ra_customer_trx_all data table as "Receivables - Transactions Re…Jesús Vega-Oracle 2 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections -
How do you add a parameter to a seeded data modelSummary: How do you add a new parameter to a seeded data model? Content (please ensure you mask any confidential information): Version (include the version you are using…CarmenR. 12 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
What Table is the Miscellaneous Receipt Distribution Comment located in?Summary: I am trying to get the comments entered on our Misc Receipt Distributions to come through in an Analysis or Report. Content (please ensure you mask any confiden… -
How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBISummary: How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBI Content (required): For example, if invoice is paid in October m…Harshil Tolia 22 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Not able to access Customer Listing Report under BI CatalogSummary: Not able to access Customer Listing Report under BI Catalog Content (required): When i try to run Customer Listing Report from BI Catalog, I am not able to see …
-
How to extract a list of transaction details that are pending contingency removal?Summary: Users must be able to extract which transactions (and their details) are pending contingency removal, so that they can easily monitor which transactions they ne…Francine Gemora 23 views 2 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Not able to run Transaction register for the duation of one monthSummary: We have 300K transactions per month and OTBI transaction register is not able to pull the data when we execute the report for one month. We are able to get the …Subbareddy Kandala 43 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Deeplink to Approve Adjustment Page or Billing Landing pageSummary: In the absence of a notification to alert Receivables Adjustments approvers to approve an adjustment, is there a deeplink or shortcut that can take a user direc…Jonathan Adejokun 12 views 2 comments 0 points Most recent by Jonathan Adejokun Receivables & Collections
-
How to create a log file of invoices that were sent by email ?Summary: How to create a log file of invoices that would be sent by email ? Content (required): Hello I was wondering If you can share with me an SQL of the invoices tha…
-
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 21B
-
How to purge the tables JG_FSCL_HDRS_ATRB_INT and JG_FSCL_LINES_ATRB_INTSummary: Hi, we need to purge this tables JG_FSCL_HDRS_ATRB_INT JG_FSCL_LINES_ATRB_INT How can I do this? Content (required): Version (include the version you are using,…Alex Pagliarini - Ninecon 22 views 1 comment 0 points Most recent by Raghuram Saradka-Oracle Tax & Global -
Need report for Applied Receipts & Un-applied ReceiptsSummary: Hi Experts Can any one advise how to get the below 2 reports in AR Applied Receipt Register Un-Applied Receipt Register Content (required): Version (include the…Satya Mothe 23 views 4 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Receivables & Collections
-
How to extract Tax Classification (Party Tax Profile Controls) for all Customers?Summary: We need to update the Tax Classification of multiple customers, so we would like to first extract all existing data (which were uploaded using TaxImplWorkbookTe…Francine Gemora 42 views 2 comments 0 points Most recent by Ashwin M-Oracle Receivables & Collections
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 146 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to add account balancing segment filter in Receivables Aging report?Summary: I need to add multiple balancing segment filters in "Receivables Aging by General Ledger Account Report" Content (required): Hello, What i see now in the balanc…Teodora Bulancea 42 views 2 comments 0 points Most recent by Teodora Bulancea Receivables & Collections
-
Why Miscellaneous Receipts not considered in the Receivable to Ledger reconciliation report.Summary: Why Miscellaneous Receipts not considered in the Receivable to Ledger reconciliation report. Content (required): Version (include the version you are using, if …
-
Query for unearned revenue in oracle fusion from RA_CUST_TRX_LINE_GL_DIST_ALL tableSummary: we have Oracle fusion cloud services and we need to develop a report for unearned revenue how Can I identify the unearned revenue from RA_CUST_TRX_LINE_GL_DIST_…Shameer Muhammed P M 114 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Access BU in BIP based on UI RolesSummary: I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (…
-
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 50 views 3 comments 2 points Most recent by sailesh_cloudare Receivables & Collections
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…