Reporting and Analytics
Discussion List
-
Table containing Candidate personal informationHello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. We have a requirement to crea…Maitra 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
SQL to get both po with requisition and without requisition in a single queryHi All , I need a query to get SQL to get both PO with requisition and without requisition in a single query and the columns I am trying to fetch are below mentioned que…AKV27 834 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Query to get the element entries and the pay period datesHello, Requesting your help to get the sql query to fecth element entry details and the associated pay period start dates and end dates. The elements are recurring eleme…Regunanthan 1.3K views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
SQL Reporting TransactionsHi I need to check a Approved documents of records transactions. But I couldnt Get The Transaction Id which matches with my Document_Code from Hrc_Txn_Header and Hrc_Txn…Kaan Can Calkan 132 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
How to convert primary ledger currency balances to USD currency balance in Oracle FRS reports?Need to get the primary ledger currency balances to USD currency balance, based on 'Period Average Rate.'Fredrick Ignatius 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Report to identify terminated employees in BPM workflowSummary: Content (please ensure you mask any confidential information): Hi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle wo…Nidhi Chhajed 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Cannot find table in Oracle BIP that stores the Organization (Department) of usersHi all, In order to complete a movement Request report, I am required to include the Department of the user that created the movement request. I have not yet been able t…Mariyam129 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Is there way we can get the "Import Asset and Assignments Process" import errors detailswhen we run the "Import Asset and Assignments Process" to import the Capital assets the load interface file import success and errored at import job and we are trying to…Saadiq 22 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 … -
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
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 11 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 71 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 11 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 22 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…User_2025-12-05-00-49-06-629 21 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 43 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
View analytical reports in SFA from other users as adminSummary: View analytical reports in SFA from other users as admin Content (please ensure you mask any confidential information): Dear All, There is a way to view the rep…AlexFH 21 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
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 31 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service -
Nagendra Chitra-Oracle 25 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 11 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 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Table to get BICC job schedule detailsHi Team, I am looking for any table where i will get the BICC Job details for completed or Running.vikram khengare 259 views 2 comments 0 points Most recent by Prabha.R Oracle-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 12 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 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service