OTBI
Discussion List
-
Query to get customer profile historySummary: Query to get customer profile history Content (please ensure you mask any confidential information): We have a requirement where we are enabling Credit Limit at… -
Print Receivables Transactions ESSjob errors when scheduled and works fine when ran on ad-hoc basis.When the Print Receivables transactions ESS job is schedules for more than one run, it doesnt pick any record and ends in Error. When it is submitted for a single run or…
-
SQL Query to Retrieve based on Customer ShipTo Site NumberSummary: Hi, I need SQL Query to Retrieve below data from Ship to Site Number OrigSysShipPartyId OrigSysShipPartySiteId Original System Ship-to Customer Reference Origin…Mahmoud9308 656 views 3 comments 0 points Most recent by Karun_Jain-Oracle Receivables & Collections
-
How to pass Business Unit for Customer Site while creating Customers using Customer FBDI UploadSummary: We are trying to load Customers using FBDI (CustomerImportTemplate.xlsm) Content (please ensure you mask any confidential information): We are not able to find …Abhishek Sinha 103 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Customer party DFF info is not show in OTBI analysisSummary: We have some DFFs in the customer party level and try to show those customer DFF info in OTBI analysis report with AR transaction. But the DFF info is not shown…
-
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…usr_a.nv 31 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 92 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. 101 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…Kristina P - National Heritage Academies 31 views 4 comments 0 points Most recent by Madhavi Godbole Receivables & Collections -
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 267 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 …vasanth.rao 41 views 6 comments 0 points Most recent by Jithendra-Fusion Receivables-Oracle Receivables & Collections
-
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 31 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 42 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 68 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