OTBI
Discussion List
-
Is the number of rows retrieved from OTBI analysis is increased from 75K?Summary: OTBI analysis can retrieve maximum rows of 75K. But users are now able to retrieve around 160K records from the analysis. Is there any update/change happened in…Mounika Samayamantri 11 views 0 comments 0 points Started by Mounika Samayamantri Reporting and Analytics for ERP
-
Receivables - Customer Real Time OTBI is not showing any report dataSummary: We have an OTBI report where we are using Receivables - Customer Real Time subject Area. When I run the report, its not showing any data. I have BI admin, Accou…
-
OTBI - Customer Credit - Last Review Date / Next Review Date Missing?Hello, We are looking to pull the Last Review Date and Next Review Date areas of the customer account profile history to an OTBI report. I cannot locate these fields to …Brandon Wortman 7 views 0 comments 0 points Started by Brandon Wortman Reporting and Analytics for ERP
-
How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report?Summary: How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report? In the Receivables to Ledger Reconciliation Summary Report …
-
is it possibile to check uniqueness of a field using page composer and el expression?I need to verify that when a user creates a customer of type person it is not already existing in cloud trate the fiscal classification code, because people do not have …
-
What table links user name and QUEUE_RESOURCE_IDSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Stan Oku 2 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
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 21 views 3 comments 0 points Most recent by KaranRaj-Oracle Receivables & Collections
-
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…
-
Why can't I see DFF configured in Trading Community Model in OTBI Receivables subject area?Summary: DFF has been setup in Manage Trading Community Organization Descriptive Flexfield under the application Trading Community Model, and Module is Trading Community…Jennifer-Leung 1 view 1 comment 0 points Most recent by Marius Neagu - Oracle Support-Oracle Receivables & Collections
-
Create SAFT-PT Audit File for Portugal not generating XML fileHello All i am trying to run the process Create SAFT-PT Audit File for Portugal and in the parameter i'm including the file i want it as XML but when the process succeed…
-
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …Sharne Thysse 11 views 2 comments 2 points Most recent by Seeam Jyanesh Reporting and Analytics for ERP
-
Unable to convert our customer outstanding balances to USD for Indian EntitiesSummary: Hi Team, We have requirement to convert customer outstanding balances for India entity to show in USD. In OTBI if you provide option convert outstanding balance…Rajasekhar Reddy Adam 11 views 2 comments 0 points Most recent by Rajasekhar Reddy Adam Receivables & Collections
-
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…
-
How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report?Summary: Could you please help us on explaining the logic on how Receivables Begin Balance/Non Receivable Begin Balance is calculated in OOTB Receivables to Ledger Recon…
-
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…Patrick Bonahoom 2.1K views 4 comments 2 points Most recent by Vidhya Nadarajan-Oracle Receivables & Collections
-
How to edit Create Accounting Execution Report to add "Created By" columnI created a copy of standard create accounting execution report in Reports and Analytics to edit the columns reflecting in the report. Upon exploring, adding a "Created …Butch Melvin 11 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
How to add a Customer DFF in OTBI ReportSummary: We want a Customer DFF (Party & Sitre Segments) in the OTBI report. Unable to find the DFF. Content (required): Version (include the version you are using, if a…Siddhant Aggarwal-Oracle 52 views 5 comments 0 points Most recent by Wang Yuan-Oracle Receivables & Collections
-
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…
-
Condition to display active customer accounts/sites in Customers extract OTBI ReportSummary: Hi, We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder …
-
Receivables Transaction Review and Control ReportingSummary: We are working on implementing the new feature around Receivables Transaction Review and Control, however we are looking for reporting related to the credit mem…
-
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 12 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 2 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 …