Reporting and Analytics
Discussion List
-
How to create custom PVO and add it in BICCSummary: How to create custom PVO and add it in BICC Content (required): How to create custom PVO and add it in BICC Version (include the version you are using, if appli…Vivek Gautam 2.1K views 6 comments 1 point Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …John Aitken 3 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
How can we limit access to FRS Reports in Oracle FiSummary: Limit Access to FRS Reports in Oracle Fusion Cloud as they contain Sensitive information Content (please ensure you mask any confidential information): We wante…Anil Bathula 11 views 2 comments 0 points Most recent by sanjam1130 Reporting & Analytics for Fusion Service
-
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Fusion Licencing are there any reports to help usORACLE don’t provide users vs licences vs roles reports - do they? closest Ive got is this - since deleted - Document 2512770.1 Hera Licensing Monitoring & Optimization …Rory Fielding 11 views 2 comments 0 points Most recent by Rory Fielding Reporting & Analytics for Fusion Service
-
How to personalize Schedule process screen?i am trying to personalize Schedule process screen but none of the filed is editable.TejasUphade04 21 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Looking for PVOsSummary: Looking for PVOs under biacm for the below tables msc_sr_assignments msc_customers msc_customer_sites_msc_v msc_items msc_sr_source_org msc_sr_receipt_orgGeorgina Sawyer 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Audit eventSummary: Event type and Attributes required to audit Role/Priv creation and maintenance Content (please ensure you mask any confidential information): We would like to r…Ai-Yeen 25 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
BIP Output delivery Details to SAAS and UCM detailsHello All, Could you please help us with details on following points if you have any inputs regarding BI reports delivery: 1. BIP output shown in report history is hoste…Pooja K 21 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Enable Data Stores in BICC OfferingsWe observed that there are some oracle delivered data Stores which are not enabled for extraction e.g Customer for given offering like Financials or Customer Data manage…Oracletechnofunctional 21 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
how to find source to disable autorun for an OTBI report?Customer is getting a delivery report but now they don't want to use it further, We are trying to find a way to disable the autorun of the report. FYI: We were not able …Sushant95-Oracle 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
How to add a specific offering to BIACM extract in Fusion?Hello all, I am unable to locate and add the below data store. FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvEventsExtractPVO Can you please help? ThanksEarth place 1 view 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
Sql to find weekdays between two DB dates in fusionI want the query for Fusion to find weekdays between two dates skip the saturday and sunday and give the subtracted days dates may be have differnce of 1 day or 10 days …Abdur Rehman 32 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
Nagendra Chitra-Oracle 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
BIP to burst the file to SFTP Server with 0 KB in case there is no data extractedSummary: We have requirement to burst BIP report output to SFTP server with 0 KB size in case there is no data extracted after data model query being executed. Content (…Hitesh Jasuja-Oracle 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…Krutika Narayankar 2 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…Krutika Narayankar 12 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…Sharmava 2 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Can I use output from one BI report as input to another BI report?Summary: Content (required): I know that I can create multiple templates for my output, but that would require me to run the data model again. I'm looking for a way to p…Scott Paulin 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Need to Stop Showing Business Unit Code in Report HeaderHi All, I have created Report using Oracle FRS and in the report output i need to stop appearing this BU code. Please AdviceNavindu Amarasinghe 13 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…Sai Shyam 12 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 11 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
Authentication issueDear All, I am currently utilizing basic authentication (username, password) to invoke a report and retrieve data from Visual Builder through the SOAP API. However, we h…George Mattar 11 views 3 comments 0 points Most recent by Narendra More-Support-Oracle Reporting & Analytics for Fusion Service
-
Problem of report object after convert from FR report and export to ExcelAfter we migrate FR to Reports and export to Excel, 1. All the header and footer objects changed to pictures. 2. For these pictures, the wordings are not very clear and …
-
How do I update the User Distinguished Name?I am working on building a report that references the PER_USERS table in our ERP environment? However, I have noticed that the USER_DISTINGUISHED_NAME column has inconsi…Thomas Loftus 16 views 1 comment 0 points Most recent by Narendra More-Support-Oracle Reporting and Analytics for ERP
-
Learning Completion date of a course under specializationHi All, I am not able to get courses under a specialization to get its completion date. Any help is appreciated? Thanks-Praveen
-
Functions/Query in OTBI report to seperate concatenated segmentsHi, I'm trying to separate the concatenated segments into individual segments. I would like to separate 6 segments. I found a few Oracle documents which have solutions f…Varalakshmi 14 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
How to disable Approve Reject from workflow bell icon notification?Proposed Email template & resignation approval process to People Leader: 1. We are requesting to remove the ‘Approve or Reject’ button from the current resignation email…Nagendra Chitra-Oracle 507 views 19 comments 0 points Most recent by Jay.Joshi-Oracle Human Capital Management
-
How to define a custom field which its LOV is dependent on another field in the formSummary: Custom field added to form should hold LOV based on a query dependent on another field in the form Content (please ensure you mask any confidential information)…Michal Shaked 44 views 2 comments 0 points Most recent by Michal Shaked Reporting & Analytics for Fusion Service
-
How to embed BIP Reports in Job Requestion UI pageNeed to add the BIP Report in Job Requestion UI page. Based on the selected Requisition the embedded BIP Report should populate the candidate's details in UI. Kindly let…Anand-ST-Oracle 12 views 0 comments 0 points Started by Anand-ST-Oracle BI Publisher Learning Center