To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
OTBI report for FND LOOKUPSSummary: I need to create an OTBI analysis for FND LOOKUPs. Through OTBI Lineage document I found there is a View object for fnd lookup. "FscmTopModelAM.AnalyticsService… -
List of all seeded reports navigation path required for procurement contracts, SCM, ProcurementI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…
-
List of all seeded reports for SCM , Procurement and Procurement contractsI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…
-
How to implement the Column Group in OTBISummary: I am checking a seeded report "Top 10 Requisitions Breakdown". can anyone help me how to implement the below column group functionality in OTBI report? Also, Ho… -
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
How does chunking data work for Oracle BICC extractsHow does Data chunking work for Oracle BICC extracts, typically for large volume extracts I want to use this feature. When I mention creation date and days in the Perfor…
-
Parameter getting defaulted automatically - BI publisherSummary: When I run a report, one of the parameters is unusable because, after I select one value, it gets defaulted to "All" The data model works fine before running th…
-
How to see the list of ESS Jobs scheduled using BICC and UCMSummary: How to see How to see the list of ESS Jobs scheduled using BICC and UCM and their start time Content (please ensure you mask any confidential information): Vers…
-
accouting hubSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Actual Revenue VS. Budgeted RevenueSummary: I want to make a dashboard of Actual Revenue VS. Budgeted Revenue. Which subject area could be used for this query? Comparison is required between 2024 Budget, …
-
Looking for query to get details of Review Budgetary Control Balances screen informationSummary: Content (please ensure you mask any confidential information): I am creating a custom report to get the details of Review Budgetary Control Balances screen. Ver…
-
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…
-
BI report cannot be restricted with data access setSummary: A user without a data access set(where only ledger A is attached) is able to select ledger A as the report's parameter, and view its data as well. (the user is …
-
Need query to get Job details oracle fusionHi Team, Please correct me if i am wrong, once we have submitted Job from schedule jobs then we can see the data in the below tables fusion.ess_request_history fusion.es…
-
Supplier contracts OTBI/SQL reportSummary: Is there any standard Supplier contract OTBI/SQL report available? Content (please ensure you mask any confidential information): Version (include the version y…
-
How to convert Customer TRX ID into textHi Team, We have developed Invoice Extract report and the output is in the CSV format. In the report having the column as Customer trx id which is the length of 8/9numbe…
-
How to schedule an OTBI report to run for a subset of the full OTBI report?Summary: I have an OTBI report I created that lists all active Projects, the assigned project managers and total budgeted amount. The full report with all project manger… -
AP check template MICR Font is showing as square boxesSummary: I am working one of the Saas Customer and trying to customize the AP check template. Existing custom template was build by Solution Implementation team is worki…
-
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… -
Create an AP invoice using supplier number instead of supplier name in the REST API payloadSummary: Currently the payload to create AP invoices requires to enter the supplier name to create the invoice, since the source system is not Oracle the characters may …
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
Customer require to extract FRS report data in XML or SQL format. Is this possible?Hi All, Customer require to extract FRS report data in XML or SQL format. Is this possible?
-
Query to identify BPA changesSummary: Query to identify BPA changes Content (please ensure you mask any confidential information): I am building a query to identify BPA's that have had their UNIT_PR…
-
Purchase Order PDF Using Sub TemplatesSummary: We have multiple entities and developed a custom data model and appropriate custom purchase order PDF's. All working fine for PdfDraft and PdfArchive sections. …
-
How to show the data label (Count) in all the colors of Stacked Bar Chart in the RTF Template?Summary: We have a requirement to display the number as data label in the RTF Template – Stacked Bar Chart. The count is being displayed only in one colour and it’s not …
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to handle null values in BIP report param which is "text field contains comma seperated values"Summary: In BI publisher Report,I have a parameter Type enabling check box of :text field contains comma seperated values" This parameter is not mandatory so how to hand…
-
Splitting Of master detail records into new detail result if detail data exists more than 2k recordsSummary: Hi Team, We have a requirement to develop master detail report with master data set containing header level details of transaction and detail data set containin…
-
Unsupported use of WITH clauseSummary: My custom report is producing the error of Unsupported use of WITH clause Content (please ensure you mask any confidential information): I have developed a repo…
-
Custom role Project Administrator and Cost Controller cannot see AnalyticsThe custom role that we made Project Administrator and Cost Controller should be able to see the Analytics Widget with Project Dashboard information. However its missing…