OTBI
Discussion List
-
Issue finding PVO'S for the listed columnsTrying to add these columns to AR Transactions SA from the Fusion cloud application to FDI D&B Customer Number Account Profile Class Account Status Account Termination D… -
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… -
How to resolve time out error in running a Fusion BI report specific to an user account?Summary: A specific user is getting time out error after running a report with specific parameter. But the same report with same parameter is working for another user. P…Sneha Kathirendran 10 views 2 comments 0 points Most recent by Sneha Kathirendran 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
-
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…
-
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 12 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 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Error using 'Upload Customers' FBDI, using OIC processthe error is: Processing Data File: ArUploadCustomers.csv Data files cannot be processed due to incorrect file name prefix. You must provide the Data Files having valid …ACNROMA2023 19 views 1 comment 0 points Most recent by Andreea Laura Panait-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 3 views 0 comments 0 points Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
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 493 views 4 comments 0 points Most recent by Jeremy Starling Receivables & Collections
-
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 21 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 13 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 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Ship-to Site Number field is missing in the Receivables Transactions Real Time subject area for OTBISummary: I need to add *Ship-To Site Number field and I don't see it available under Receivables Transactions Real Time subject area. Please suggest if it's available in…Rahul Kumar Gupta.-Oracle 22 views 2 comments 0 points Most recent by Rahul Kumar Gupta.-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 171 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 21 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…AN_ 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