OTBI
Discussion List
-
We are trying to obtain a Audit report which captures audit for customer bank account changes.Summary:We are trying to obtain a Audit report which captures audit for customer bank account changes. The business need is to capture the following details for audit: I… -
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 1K views 5 comments 1 point Most recent by Eros Mario Nicotra Receivables & Collections
-
How to extract ship to customer and ship to site name?Hi, How to extract ship to customer and ship to site in a receivables table? We only found id. Thanks, Regards
-
UPDATE RECEIVABLES RECEIPT DFF using APII tried to update receipt DFF with the following Payload: single…
-
Is it possible to use FBDI for adding some sites to an exiting customer?We created a customer but we need to add many sites to him, so we are thinking about using FBDI, but is it possibile for an existing customer to use FBDI just for create…
-
Export Manage Receivable ActivitiesIs there a way to export the results in Manage Receivable Activities setup & maintenance screen? Or is there a back end table I can create a data model and report off of…Matthew - Town of Aurora 18 views 1 comment 0 points Most recent by Matthew - Town of Aurora Receivables & Collections
-
Print Receivables Transactions but don't emailSummary: Hello, We want to be able to run the aforementioned request but rather than have email the documents out, simply generate a PDF document. I know that we can rec… -
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…
-
All AR transactions excluding vat and remaining balanceSummary: We need a report showing all AR transactions excluding vat and remaining balance including vat as at a date. If there is no remaining balance no need to be in t…
-
OTBI Report that includes oustanding BalanceI am trying to build an OTBI report for customer ATR transactions including outstanding balances (Remaining Balance). But I couldn't find out the customer Outstanding Ba…jgrahamavanti 55 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Migrated AR report returning an error which has DFFsSummary: I have migrated 3 AR OTBI reports from one instance to another and earlier I was not able to find those DFFs in OTBI though it was configured but post running t…Rahul Kumar Gupta.-Oracle 1 view 0 comments 0 points Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
Philippines Statutory Report - Cash Disbursement JournalSummary: Philippines Statutory Report - Cash Disbursement Journal Content (please ensure you mask any confidential information): Hi, We are trying to get the details on …D Mandal 51 views 4 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
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 49 views 4 comments 2 points Most recent by User_F7IX4 Receivables & Collections
-
Due Date field in Receivables Transaction Real Time is not displaying any valueSummary: Even though we tried with the most basic fields but the Due Date value is not getting displayed (Screenshot 1). Only when we are adding due date field from Rece…Rahul Kumar Gupta.-Oracle 23 views 4 comments 0 points Most recent by Rahul Kumar Gupta.-Oracle Receivables & Collections
-
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… -
Line Total Amount field in AR Transaction Real Time OTBI subject area is missingSummary: Could someone please let me know how can I have Line Total Amount field in my OTBI report? Content (please ensure you mask any confidential information): Versio…Rahul Kumar Gupta.-Oracle 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa…Atul_Ghd 12 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
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 517 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 94 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 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 33 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 79 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…