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
-
Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda… -
BICC Extract Schedules vs Job SchedulesSummary: Hi, I would like to create a pipe line between BICC and data warehouse to extract Financial Data I wonder what the difference and use case is for one or the oth… -
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…
-
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …
-
'Create Accounting for Assets' Custom ESS Job for Draft Accounting Mode only.Summary: How to create custom 'Create Accounting for Assets' ESS job where Accounting mode parameter must be - Draft only..? Content (please ensure you mask any confiden…
-
Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI reportI have created a custom OTBI report DPO (Days Payables Outstanding) to look at the average days to pay vendor. The last column is a calculated measure based on the multi…
-
General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…
-
Automating BI Catalog archivingSummary: 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 submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…
-
Best Practice for Monitoring Performance and Resolving Issues?Hello, We are experiencing recurring times of slowness in our system and want to better monitor the performance to potentially troubleshoot this problem. When users repo…
-
how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance report
-
How to duplicate a DashboardI need to duplicate and modify an out of the box dashboard: CIP Account Analysis. How do I duplicate it and save it, when I try to do so, I am unable to edit components. -
Bank Account Export from ERP CloudSummary Is there an out of box report to export all Bank Accounts set up in ERP Cloud?Content New ERP Cloud user here. How can I export a list of bank accounts that are … -
REST API's related to projectPlanDetails (/fscmRestApi/resources/11.13.18.05/projectPlanDetails).Summary: Rest call (/fscmRestApi/resources/11.13.18.05/projectPlanDetails) returns forbidden error (HTTP-403) Content (please ensure you mask any confidential informatio…
-
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…
-
How to convert PERIOD NAME to Date data type?Hi I am using Between operator in Period Name and it is not working. Period Name is a Varchar type. How to convert it into Date data type so i can use between operator i…
-
Remove Implementation roles for FAWService_APPID, FAWService and FUSION_APPS_GRC_APPID userSummary: Users want to know if the following roles can be removed from FAWService_APPID, FAWService and FUSION_APPS_GRC_APPID user ids if they are not using GRC feature …
-
BICC Extract to get Data Access for UserSummary: We have requirement to get the details of Data Access for User (Containing User ,Roles assigned to User, Security Context etc.) using BICC Extract. Is there any…
-
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o…
-
BI Publisher report parameters do not workSummary: Requisition Header Description based parameter is not working Content (please ensure you mask any confidential information): I have created a BIP report for Req…
-
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi… -
Performance considerations while doing Bulk Email BurstingSummary: At a time, need to send around 5K email notifications to supplier/supplier sites belongs to country . Content (please ensure you mask any confidential informati…
-
Need Information on Fusion tables related to REST APISummary: Would like to know which fusion tables are used to pull data for REST API /fscmRestApi/resources/11.13.18.05/projectPlanDetails. Content (please ensure you mask…
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en… -
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E…
-
How to schedule an OTBI report to generate monthly with dynamic prompt?Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically popula…
-
Cannot Deliver More Than 75K Lines to an OTBI reportSummary: Hi, The customer needs to extract data from an OTBI report with more than 75,000 rows. How can we change this limit, which is already pre-set in the report? Cur…
-
Display days of a week in order using rtf templateI have a rtf template which is using days of week to display receipt totals for each day for different entities I am using pivot table to display data weekday vs entity …
-
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long …