OTBI
Discussion List
-
Invoice Print Template criteriasSummary: I would like to have 2 different criteria for Invoice Print Template Content (please ensure you mask any confidential information): If I have only criteria like…AN_ 32 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
How to show AR invoice balance in OTBI dashboard?Summary: I want to show AR invoice balance info in the OTBI dashboard. For example, I want to show info list in the 'View Balance Details' tab in the AR invoice page, su…
-
BI Report for Invoice in Receivables Manage Transaction PageHi Experts, Kindly if anyone knows from where in BI publisher we are able to see the template and data model used to view the invoice in Manage transaction page in Recei…Yuvraj S-Oracle 31 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
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 61 views 3 comments 0 points Most recent by Francine Gemora Receivables & Collections
-
How to customize the data model to include disputed transactions for Strategy based dunning letters?How to customize the data model to include disputed transactions for Strategy based dunning letters? What data fields are required to be added for including the disputed…Kratika Sharma 31 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
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 61 views 8 comments 0 points Most recent by Mohamed Iqbal Jahangeer 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 21 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…
-
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. 72 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
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 1 view 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. 11 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 153 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 32 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 41 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 11 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 21BKanika Mahajan 46 views 2 comments 0 points Most recent by Srivatsav PR-Oracle Receivables & Collections
-
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 31 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 31 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 61 views 2 comments 0 points Most recent by Ashwin M-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 61 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 298 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 (…
-
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…