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 18 views 3 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP -
LOV not displaying any values in OTBI promptSummary: Hi, I am creating prompts in OTBI for AP module and while creating prompts for 'Invoice created by username', 'Approver', 'Invoice Source' columns, the list of …
-
Add Additional Columns in Review Customer Account Details ScreenSummary: We are looking to create an analysis based on customer account details. This includes information available in the seeded solution for customer accounts, such a…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
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… -
Report requirement for Bad debt Allowance/ ProvisionSummary: Hi This is regarding a report requirement related to allowances /Bad provisions and write off at entity level that we would like to clarify, The business expect…
-
To update the "Send statement" box, we use the REST API for Customer profile.Summary: to update the "Send Statement" checkbox for a customer in Oracle Fusion do we have the rest api and If yes what it is Content (please ensure you mask any confid…
-
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 …
-
Report to see invoice and their accounting entriesSummary: Content (please ensure you mask any confidential information): Do we have any standard report which can give the details of all the AR invoices and their accoun…
-
Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,Summary: i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix t…
-
LACLS NFSESummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Camila Lima-Oracle 3 views 0 comments 0 points Started by Camila Lima-Oracle Receivables & Collections
-
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 …
-
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 1 view 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 24 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 13 views 1 comment 0 points Most recent by Marius Neagu - Oracle Support-Oracle Receivables & Collections
-
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 13 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 12 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.3K 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 14 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…