Category 385
Discussion List
-
Required SQL query to get Customer Opt in featureSummary: Required SQL query to get Customer Opt in feature Content (please ensure you mask any confidential information): Hi Team, We need the SQL query to get Oracle fu…Opkey PA 233 views 2 comments 1 point Most recent by Biju Radhakrishnan-Oracle Supply Chain Orchestration
-
Oracle Delivered ReportHi Team, I noticed that there's a delivered analysis for Leaver details categorized by Grade, Age, and Gender as separate analyses. However, is there a standard delivere…Oviya 15 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
Which PVO contains the organization unit legal info ?Hi, Do you know which PVO contains all the legal info of the organization unit in hcm please ? I'm trying to augment the data for FDI and I'm not able to find the right …Lauriane Massin Whitaker 23 views 3 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
Can you programmatically extract an audit log for narrative reporting?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…Kunal Prasad 21 views 2 comments 0 points Most recent by Kunal Prasad Reporting & Analytics for Fusion Service
-
Export the list of configured time attributes and display value from Time entry layout componentsIs there a way to export the list of configured time attributes and display value from Time entry layout components? We are comparing 2 different layouts and it will be …
-
requires work schedule table which has effective from date as columnHi Team, We want to use work schedule effective start date to differentiate which day will be week off and working day of the employee in the report. Please suggest the …A123 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Extract Oracle Fusion BIP Report's SQL statementsHi, Is there a way to extract the SQL statements out of .Catalog files ? or this information is stored in any of the XDO tables ? ThanksNagarajuKanukanti 60 views 1 comment 0 points Most recent by User759763-Oracle Reporting & Analytics for Fusion Service
-
FA Mass AdditionHow can I obtain runtime errors from logs for each MASS_ADDITION_ID in FA Mass Addition? Are there any backend tables that hold the FA Mass Addition runtime errors for e…
-
CRC 32 - Hash in Oracle fusionHello , We have one requirement where it has been asked to convert the 16 digits column value ( The site ID from Account Payable) into a CRC 32 HASH value. I did not fin…VarshaK 42 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Getting Blank row when we unmerge the rows in FRS reprotWe ran the FRS report and exported the data to Excel. Once we extract we merge the rows and when we unmerge the rows one row is blank and it another we have a data.Surabhi 52 views 5 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Needed for Custom Query Mapping in ORC to CORE HRHi Team, I hope this message finds you well. I wanted to reach out regarding a custom query I created for the offer creation page in ORC. While I’ve made some progress, …Girish Kushibi 21 views 2 comments 3 points Most recent by Girish Kushibi Recruiting, Opportunity Marketplace
-
Is there any documentation for the setup of FDI/FAW Fusion Analytic ?FDI Fusion data intelligence FAW Fusion analytic warehouseOmran Zeaiter 41 views 1 comment 1 point Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service
-
Effective date / Frozen date on FAW/OACHi guys, Our client is asking us to use this "effective date" parameter on FAW/OAC but with a specific requirement : They would like to have this "frozen date" every mon…Lauriane Massin Whitaker 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC.Gowri Perumal 81 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…Chanida 13 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr…Simon Kaplun 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…Vitor Nakamura 51 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Sales
-
function to return fast formula return variabledo we have any function / package in hcm that we can use in BI query to retrieve the return values from a Fast Formula. Like we have one for value sets (pay_ff_functions…Parul_prabhat 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Looking for linkage details for some of the Fusion HCM PVOsBelow is the list of PVOs which are missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects. If anyone happen to have these details please share. Hcmtopmodelanal…Vineeta Agarwal-Oracle 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get what are all the Permissions assigned to the report for xdo file and xdm filesHow get what are all the Permissions assigned to the report for xdo file and xdm files through back end (sql script or rest services)UdayKuditipudi 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service
-
Extract name field from transaction console pageTransaction table for extracting the Name field in transaction console. Please assist
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 101 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get overridden account attribute from AP tables?Hello, I am not able to find attribute for Overridden account in any AP tables. I am using Oracle Fusion Cloud Applications 24B (11.13.24.04.0) and the tool i am using f…
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 206 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Send Email to multiple employees based on the region they belongHi Team, We have received requirement where we need to send the email to all pending workers who are based in an office, and provides important Day 1 information. There …Vinay_Raulwar -Oracle 11 views 0 comments 0 points Started by Vinay_Raulwar -Oracle Reporting and Analytics for HCM
-
Create tables(DDL) from PVO metadata provided by REST APIWe are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata) Url: https://{server_name}/biacm/rest/meta/da…Alex25 41 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for SCM
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPS? Content (required): Version (include the…