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 & Analytics for Fusion Service
Discussion List
-
data is not populating in fusion.ess_request_history if we run the BIP report manuallydata is populating in fusion.ess_request_history for only scheduled reports data is not populating in fusion.ess_request_history if we run the BIP report manually Step1)… -
Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web…
-
A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…
-
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…
-
Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…
-
Audit Reports Through REST APISummary: Where is possible to find list of business objects type for CRM. Content (required): Hi, I'm trying to generate Audit Reports trough REST API. The purpose it's …
-
Report who all are using Fusion Cloud applicationsSummary: Report who all are using Fusion Cloud applications Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
BICC job statusSummary: How to check all the schedules defined in BICC -- by anyone How to check which all jobs are currently running in BICC How to check which all jobs errored out in…
-
Separate heading for two grids in FRS reportWe have two grids in FRS report, is it possible to have separate Header for two grids?
-
How to display the latest add/new columns at last in BICC via UCM extractHi All, When we added new column in datastore(PVO) of BICC , while extraction of data via ucm we see the new column is not displaying towards last of extract. As per my …
-
Table to fetch HCM Extract name and delivery optionsHi Team, Please let us know the tables required to fetch submitted extracts and its status in fusion HCM. Thanks, Jahanavi
-
Unable to find table name for files uploaded on content server by partnerSummary: My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server and the external user/…
-
Is the Standard AR Aging Report working after 24B Patch Upgrade?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…
-
Is any possibility to Fetch Report Last run details ( BIP or OTBI reports)?Is any possibility to Fetch Report Last run details ( BIP or OTBI reports) Can anyone tell me that is oracle capturing the information for the Reports (BIP or OTBI) last…
-
Tables for BI Consumer role, BI Administrator Role, BI consumer role in oracle fusion HCMSummary: Hi All, I need a table name or query for BI Consumer role, BI Administrator Role, BI Author role in oracle fusion HCM. Need to write a SQL query like, who have …
-
Can I get a report with a full list of ERP Roles that displays the access to Create FBDI Journals?For Audit controls creation of FBDI report and then ensure all the roles from that reports are reviewed. -
Inconsistent report bahavior with error ORA-56733: logical I/O limit exceeded - call abortedHello, We have a BIP report which is a customized version of the Account Analysis report. In this report, we have added sub-queries to have the reconiciliation details i…
-
How to generate BIP report bursting output in PDF and HTML bothThe requirement is to get the email notification through bursting BIP report as an attachment and email body both. The template of the report contains tables , company l…
-
How to retrieve data from xml file which is loaded as data source in data model in oracle fusionI have a requirement where report will have 2 data set.One data set will have xml file as data source and other data set will have sql query as data source.How to retrie…
-
Using BIP uploading the files to UCM serverHi using this document i was trying to upload the files to content server. Job is sucessfull and i got the content ID but unable to seach back the files which got upload…
-
Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.
-
Unable to get WCC server[servername] SecurityGroups DetailsThere is an existing scheduled report job that uploads the csv report to CS. When I check it gets the error "Unable to get WCC server[servername] SecurityGroups Details"…
-
what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r…
-
BI Publisher Report Issue -"Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df."Dear experts, In some of the Data Model (Fusion SaaS) , I am below error when I open the datamodel. "Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df." Also I… -
Getting XMLPGEN - 03111 : User requested cancel operation ERROR in BIP ReportI have built a Order Management Pricing Report (BIP Report) Getting "User requested cancel operation" Error in the Report. Attached the screenshot for the reference, if …
-
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…
-
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…
-
Is the Workforce Learning - Learning Management Real Time subject area being deprecated, and when?Can you help me understand if this SA is being deprecated in OTBI or if it will remain? This Customer connect article seems to indicate it was announced in 2021 that it …
-
What if an instance has been created on analytics cloud instead of FAW ?Hi guys, What's the difference between creating an instance on Analytics Cloud and FAW on OCI ? What if some work has been done on an instance (let's say Instance 1) cre…
-
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…