OTBI
Discussion List
-
Please let us know how we can add the Attachment column in an OTBI report for ReceivablesSummary: Please let us know how we can add the Attachment column in an OTBI report for Receivables subject area, prefarably Receivables- Real Time Transaction subject ar… -
Is there a table where we could query/retrieve the match configuration rule attributes for CDM?Summary: We've a requirement to create a report showing the match rule and the rule attributes. We can use ZCH_MERGE_DETAILS_B to get the match rule name for merged reco…
-
What table/field is Customers->Tax profile->Controls and Defaults ->Tax Classification CodeI'm trying to find a table that contains the tax xlassification code field which is in the customer site → tax profile → controls and defaultsNatalyPescador 14 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Which privilege need I to view data in vbs page?I created a vbs page that extract the customer data, but without "Application Developer" role the user can't see nothing when starts the calls. I can access to the page …
-
Changing Oracle out-of-the-box data model of invoice print templateSummary: We have a requirement in the invoice print template to group and print the Bundle Name for lines with a bundle and just the product name for lines that are not …
-
Issue with missing value list in Receivables to Ledger Reconciliation ReportSummary: Hello, I’m trying to run the Receivables to Ledger Reconciliation Report, but I can’t see the value list. I currently have the standard roles assigned. Does any…Teresa Martinez-Oracle 5 views 1 comment 0 points Most recent by Deepak Singal Receivables & Collections
-
How to run Import AutoInvoice Execution Report alone?We have many users that upload invoices via spreadsheet. Their supervisor wants to generate a report that list down all unsuccessful uploads of her subordinates.
-
DR number and Shipment number not appearingSummary: I have 3 lines on one SO, all lines are closed and billed. But when checking on OTBI (sales invoice report), DR and Shipment number is not appearing on one SI. …
-
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 …
-
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…PrasadN 42 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
receivable adjustment amount column to add in OTBI ReportIn our report we are using OTBI subject area Receivables - Transactions Real time our users want to see the adjustments in the report. So we added Receivables - Adjustme…priyankarao 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Is there any predefined report showing customer wise trial balance ReportSummary: user requires Customer wise trial balance as well as Receivable balances customer wise. Do we have any predefined report? Content (please ensure you mask any co…Jeetesh Singh 23 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
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 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 27 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 64 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 2 views 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 52 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 22 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 11 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
-
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…