Category 385
Discussion List
-
General Ledger Journal Entry Database InquiryHi Oracle Experts, I have a question regarding the General Ledger Journal Entry report. Could you please clarify if the field JRNL_Effective_Date refers to the journal c… -
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…Fareeha Altaf 103 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…Surya Chandaka 31 views 1 comment 0 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
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 42 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
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 116 views 3 comments 0 points Most recent by Amr Hassan Reporting & Analytics for Fusion Service -
Archive/Unarchive permission to My folders onlySummary: BI Administrator role generally gives archive/Unarchive access to entire catalog. Here the requirement is for few users, we would need archive/Unarchive permiss…Karthik Soundarapandian1 55 views 3 comments 0 points Most recent by Karthik Soundarapandian1 Reporting & Analytics for Fusion Service
-
Help on finding out the right PVOs...Hi, I'm trying to pull HCM data through data augmentation (FDI) and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax …Lauriane Massin Whitaker 164 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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 -
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdictionCindy Souvagis 32 views 2 comments 0 points Most recent by Cindy Souvagis Reporting and Analytics for ERP
-
Hello experts, do you have the SQL query to get the list of employees and their HR representativesHello experts, Do you have the SQL query to get the list of employees and their HR representatives? Regards, Hazel
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 3K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
How to purge records from ZX_LINESHow to purge unaccounted Transaction records from ZX_LINES Table. Any one have idea please let me know. Iam trying to purge by using "Purge Tax Transactions" Program.But…Sagar Reddy 21 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
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 225 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 22 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
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
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 55 views 1 comment 0 points Most recent by User759763-Oracle Reporting & Analytics for Fusion Service
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
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 41 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 24 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 42 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 2 views 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 85 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, NagendraNagendra Chitra-Oracle 16 views 2 comments 0 points Most recent by Nathaniel.Wilcox Reporting & Analytics for Fusion Service