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
-
ORA-29400: data cartridge error ORA-10260: PGA limit (20000 MB) exceeded - process terminatedSummary: We are running a custom report that have recover more than 1.2 million of records and cheking the XML Data this have over the 1GB, when we executed this report … -
How to change the output format of the JAVA type ESS Job from .csv to .xmlI have a ESS Job of JAVA Type in Oracle Fusion having output in .csv format, User want the .xml format anyone have any idea how could I change the format? -
Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extractSummary: Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extract. Lot of BI enabled DFFs are not available in Doc ID 2463485.1. For ex…
-
BI publisher reports using Custom Subject Area objects show Slow PerfomanceSummary: Hi, we defined several custom objects in our sandbox and created Custom subject areas to develop reports by using fusion bi publisher In general, reports are wo…
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu… -
What is the difference between Uploading a BIP report vs. Archiving a BIP ReportSummary: There are two options to take a copy or get a copy of Data Model and Reports. XMLPServer and click on Upload/Download Catalog folder and Archive/Unarchive Conte…
-
Calling another template in RTF left-justifies the alignment instead of justifySummary: Content (please ensure you mask any confidential information): Hi all, I am calling another template within my rtf template and it's working great, but the issu… -
BurstingSummary: Hi team I have a requirement where I should extract list of the reports name in which we have used bursting? Content (please ensure you mask any confidential in…
-
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…
-
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 …
-
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… -
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…
-
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 …
-
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:
-
Which Table Stores the GL Overridden Natural Account Code in Oracle Fusion?Summary: Hello everyone, I am currently working on a data model in Oracle Fusion and need to identify which table stores the value for the GL overridden natural account … -
Anyone have experience in importing catalog file using PublicReportWSSServiceSummary: Can anyone help us to get the sample payload required to call PublicReportWSSService to upload catalog file in Oracle Fusion ERP application? Content (please en…
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…
-
oracle.xdo.XDOException: Template type 'etext' is not yet supported.Summary: DataException:[INSTANCE_JOB_ID=1343928] oracle.xdo.XDOException: Template type 'etext' is not yet supported. oracle.xdo.servlet.data.DataException: oracle.xdo.X…
-
Unable to select Manage Formats from the Report LayoutI need to be able to format a column on a custom BIP to HTML but in the report layout in edit mode, I am unable to select the Manage Formats. What could be the issue? -
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…
-
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…
-
Generating Sheet name dynamically in excel from xml tag in rtf word with PublisherSummary: in publisher while creating an rtf in word for a multi tab excel is it possible to generate sheet name dynamically from source After loading xml, should be able…