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
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma… -
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential…
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you! -
FUSION_APPS_PROV_PATCH_APPIDSummary: we saw in audit log that the user- Provisioning Patch Application Identity - user ID: FUSION_APPS_PROV_PATCH_APPID has added the role ORA_FND_APPLICATION_DEVELO…
-
SQL for Project Events InvoiceSummary: Trying to get the approved Invoices only and I am getting incorrect values. Content (please ensure you mask any confidential information): Code Snippet (add any…
-
Need guidance on Malaysia specific localizationWe are looking for information regarding Malaysia localization changes that have been implemented from reporting perspective. What are the possible changes we need to ca… -
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …
-
I need to find Frieght amount for purchase order line BI publihser sql,Summary: i am looking to figure out where freight amounrt for purchase order line is stored, can any one help me ? Content (please ensure you mask any confidential infor…
-
Which table contains payment final approver name?Summary: I need to add 'Final approver name' for payment to a sql query/bip. What is the table name please? Content (please ensure you mask any confidential information): -
IC and GL Reports that capture DFF detailsDo we have any seeded report that can capture the details of DFFs configured in the following tables: IC- FUN_DIST_LINES GL- GL_JE_LINES If none, could you please sugges…
-
24C regression - scheduled reports are completing successfully for invalid email addressesSummary: Content (please ensure you mask any confidential information): If an invalid email address is provided as xyz@abc, Till 24B, the delivery was failing and delive…
-
-
How do I get my OTBI Income Statement to default to the current GL period?Summary: My OTBI Income Statement is defaulted to January 2022, but we would like it to dynamically open to the current GL period. Content (please ensure you mask any co…
-
How to remove double quotes when getting output in csv pipe delimited from BI ReportHow to remove double quotes when getting output in csv pipe delimited from BI Report
-
ERP Cloud Fusion DatabaseHi, i have a customer that is asking about Disaster Recovery with defined Recovery-Point Objectives (RPO) and Recovery-Time Objectives (RTO) for my erp cloud fusion data…
-
Getting java.lang.NullPointerException error while invoking fscmService/ServiceCatalogService?WSDLSummary: fscmService/ServiceCatalogService?WSDL We are trying to using above ServiceCatalog WSDL for FDBI upload process..which upload zip file and submit the ESS Job as…
-
What would cause the same data to be bursted across multiple days?Summary: We have quite a few Bursting notifications but one of them bursts the same data across two different days. This Notification is a generic email and an excel att… -
Payables Invoices - Transactions Real Time - does not return all invoicesSummary: Payables Invoices - Transactions Real Time - does not return all invoices Content (please ensure you mask any confidential information): Hi - if I run this SQL …
-
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t…
-
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the view PAYROLL_FLOW that trigger a BIP report, but I'm unable to fin…
-
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
BIP Data Source: Secure HTTP ConnectionSummary: While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching o…
-
OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real TimeSummary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and … -
OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real TimeSummary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and …
-
reports dont appear when emailing a dashboardSummary: We have a dashboard that includes multiple analysis and one report (created from a data model). This dashboard is scheduled to be deliverd by email (not attachm…
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…
-
Need the SQL query used in SaaS Service Usage Metrics ReportNeed the SQL query used in SaaS Service Usage Metrics Report (the one with PDF format extracted from MyServices) as we need to use it in a bursting program under BI Publ…
-
What subject areas and query should I use to get AR Aging report based on BICC Extractts?Summary: I know the AR Aging report is complex with joins to XLA tables, hz tables, ar_payment_schedules, and other ra/ar tables. We are trying to generate the AR Aging …
-
How do I add the FDI link onto our oracle cloud homepageI am looking for the steps to add a link to FDI from our Oracle Cloud Homepage as shown in the screenshot below: