Reporting and Analytics
Discussion List
-
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj…Curtis Allen 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Error adding PVO to BICCHave SR open—no useful response yet so looking for other response. Error adding an existing PVO in BICC shows this error " [BIACM0185] Error saving data store due to [BI… -
Requisition Email Approval templateI am currently working on updating the custom requisition email approval template. As part of the testing process, I have enabled the BIP_CLIENT_REFRESH_TME profile opti…
-
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Getting error 401- Unauthorized error while calling WebService from Oracle Fusion BIPWhen we are calling Webservice from Oracle Fusion BIP , OIC is triggered but going into error 401- Unauthorized, however we are using the same User Name in OIC and BIP b…Hitesh Jasuja-Oracle 32 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
I have build the report using service request object with custom subject area but getting error.Summary: I have build the report using service request object with custom subject area and trying to map the reference number to SR number (custom object custom field) b…Manjula Bellamkonda-Oracle 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Unable to burst a BIP report for data model based on web service?I have created a data model based on web service which I have created in OIC(exposed a SOAP based web service). This pulls data from ATP database based on parameters sen…Shikha Charadva 31 views 3 comments 0 points Most recent by Krishan_Palihakkara Reporting & Analytics for Fusion Service
-
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden…
-
Missing Data Repsonse using soap UIcould you please check this payload--> csv P_START_DATE…Anjali Kumari Gupta 12 views 1 comment 0 points Most recent by Anjali Kumari Gupta Reporting and Analytics for ERP
-
How to create Employee as a SupplierWe have a requirement to create Supplier records for all active Employees. Please advise on the best approach to establish a link between the Employee and the correspond…Kinjal Patel-Oracle 41 views 3 comments 2 points Most recent by Umar Reporting & Analytics for Fusion Service
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 11 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_valuesHi Guys Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values? Data Source : ApplicationDB_FSCM E.G. C…
-
How to determine the correct PVO to use for data augmentationSummary: Attempting to create a data augmentation for the Fusion Data Intelligence package to include an Accounting date from the Fusion ERP environment. We are needing …jstruth 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Multiple Delivery By options in Oracle BI ReportSummary: Hi All, I have developed Oracle BI report in fusion, facing an below issue - I have 4 data sets A,B,C,D and joined A-B and A-C-D, included KEY in all the datase…
-
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…Opkey PA 51 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
BICC external storageSummary: We have to send bicc files to external storage allocated in a s3 site. wich kind of serviceName i'll request from my aws technician to make bicc get container n…
-
Need a SQL of employees who are missing costing details on the person/ assignment costing.Employee who are missing costing detailsSARAORC 11 views 1 comment 0 points Most recent by VIKURAMA-Oracle Payroll and Global Payroll Interface (GPI)
-
Why is country code "CZ" missing in fusion.psc_com_country_bSummary: Why is country code "CZ" missing in fusion.psc_com_country_b to convert country codes between ISO 3166-1 alpha-2 and ISO 3166-1 alpha-3 or ISO 3166-1 numeric. C…
-
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 11 views 0 comments 0 points Started by Karthik Chedella Reporting and Analytics for SCM
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 128 views 3 comments 1 point Most recent by Erick.B Reporting & Analytics for Fusion Service
-
What is the BICC PVO for FND_VS_VALUES_B Fusion table that has the attribute values?We are on FDI 25.2. I have found some PVOS like FscmTopModelAM.AnalyticsServiceAM.ValueSetTypedValuesPVO in BICC that map back to the valueset/code data in Fusion data b…
-
In Cloud Fusion need ability to audit changes in the admin profile optionsI need the information whether it is the correct Oracle doc or just an answer on how to enable and then report on how to report on any changes made using manage admin pr…Mike P 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
BIP Bursting - Is it possible to get confirmation emails whereSummary: Using Bursting to email AR Invoices. Need to ability to know if email was actually sent to client Content (please ensure you mask any confidential information):… -
How to add date parameter while calling BIP Report using Custom ESS JobWe have created a BIP Report and calling it through ESS Job. The report is using a data parameter and we're trying to add the parameter in the ESS Job. The ESS Job is wo…Kunwar Prashan Srivastava 61 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to Update an DataModel/Object in the BI Publisher Catalog Using the CatalogServicewe are trying to implement a solution to migrate BI(Data Model and Report) into oracle SAAS from Source to Target folder using Oracle standard WSDL- https:// /xmlpserver…Avilash1265 51 views 2 comments 0 points Most recent by Avilash1265 Reporting & Analytics for Fusion Service
-
Unable to update headcount as 1 for few employees using HDLHi, We are using HDL for updating the headcount of 48K+ records and have successfully updated for most of them however for 5 records we are getting error as "More than 1…
-
Getting Duplicate data on performance and goalsGetting Duplicate data on performance and goals when employees checking from Me >> Performance >> Employee is able to view the list of goals of other employees from his …Shivani Karna 32 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Can I have multiple logos for 1 only income statement FRS report?Kindly find the below: The client want more than one logo used in the same income statement created in financial reporting center is there any way? thanks for help, Rega…Anthony Sleiman 41 views 2 comments 1 point Most recent by Abdelrhman Samy General Ledger & Intercompany
-
Missing HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VIWe don't see HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VI in BICC offering though it is available HCM PVO mapping document. How do we ge…Prakash Maram 1 view 2 comments 0 points Most recent by Ritambhara Rai Reporting and Analytics for HCM