Analytics
Discussion List
-
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…Omran Zeaiter 8 views 0 comments 0 points Started by Omran Zeaiter Reporting & Analytics for Fusion Service -
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…BHAVANA SINGH 5 views 0 comments 0 points Started by BHAVANA SINGH Reporting & Analytics for Fusion Service
-
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.4K views 7 comments 1 point Most recent by Surendra Majeti Reporting & Analytics for Fusion Service -
sql to fetch organizations or departments based on business unitHi Team, We are trying to write sql to fetch all organization or departments for a business unit. But we dont know how to link organizations to business unit. To tell yo…RamNarayan-Oracle 28 views 1 comment 0 points Most recent by IpsitaGhosh-Oracle Human Capital Management
-
We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 13 views 0 comments 0 points Started by nehayadav86 Reporting & Analytics for Fusion Service
-
BIP RTF template need Freestyle Script fontHi Everyone, I have a requirement to create an PDF document with employee name like signature. (who signed electronically) We want to use different font which will look …Naveen Jayaraman 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 80 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM
-
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… -
hcm - document of records - flex fields and attachmenthcm - document of records - I NEED TO GET THIS SAME FIELDS TO BE AVAILABLE IN DOCUMENT OF RECORDS APPROVAERS AND IN EMAIL AS ATTACHMENT -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…User_5FJ4I 71 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
How to display the content of the PO PDF document in the Email body of the Approval NotificationApart from getting the attachment as a PDF, need to display a few columns in the email body as well
-
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 38 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
BI Publisher report to join MSC_CUSTOMER_SITES to MSC_CALENDAR_ASSIGNMENTS and MSC_REGIONSI'm trying to write a BI Publisher report to join MSC_CUSTOMER_SITES to MSC_CALENDAR_ASSIGNMENTS and MSC_REGIONS and how to best join these planning tables to the custom…Sera Hager 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Supply Chain Planning and Collaboration -
how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables
-
Invoice summary details table for APWhich table stores Invoice summary details in Fusion cloud. I am looking for the column which stores Accounting informationKavya Gururaj 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Fusion Data Intelligence - System settingsHello, Trying to do some configuration for the Oracle Data Intelligence, and when I'm logged in and go to the Console and System Settings. It says I don't have permissio…BenSayers 54 views 2 comments 0 points Most recent by Amanda Hope Fusion Applications Administration -
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 82 views 2 comments 0 points 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 11 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
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 12 views 3 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
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 …Ankita Choudheri 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can …
-
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 44 views 1 comment 0 points Most recent by Angel Jimenez-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 27 views 2 comments 2 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 31 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 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Print Labels on Zebra Printer from Oracle FAW - BIWe have a requirement on printing labels to Zebra printer. We are sending the print command from FAW-BI to CUPS and CUPS to Printer however it is not getting printed. Po…Pawan Deep Singh 7 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM