Reports
Discussion List
-
Looking for Primary flag for phone number in HCMIn HCM, I am trying to add a flag for "Primary" phone number in a BIP report. I didn't see the flag as a field in the per_phones table. Is there another table that I can… -
Need Approval status report in FCCS like Data Process Control of HFMSummary: Need Approval status report in FCCS like Data Process Control of HFM Content (please ensure you mask any confidential information): Hi All, In HFM application, …DISHIL SHAH 8 views 2 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
In Reports, is there a way to use User VariablesSummary: Is there any way we can leverage User Variables when creating Management Reports? When running the report, it should be able to select two different members of …Kenneth John Asper-Oracle 41 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 350 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle Recruiting Cloud – Talent and Candidate Pool (Pool entry date)Summary: Hi Experts, We urgently need Global Talent Pool and Candidate Pools reporting in Oracle Recruiting Cloud (ORC) to meet business demands. I would appreciate clar…
-
IFRS 18 - How to have 2 separate Profit and Loss account structure in Oracle EPM FCCSSummary: As IFRS 18 will be effective from 1 April 2027 onwards, and 1 year comparative number is required to reflect the requirement of IFRS 18, we need to know how Ora…
-
How to concatenate manager person numbers from hierarchy in HCM Extract?Summary: Content (please ensure you mask any confidential information): urrently my extract structure is like this: PER_EXT_PERSON_MANAGERS_HIERARCHY_UE In this UE, I wa…
-
Employment contracts - Audit missing action code fieldSummary: Hi experts, we are trying to add the field "Action code" as selected attribute in the audit for the Worker Employment Contract business object but it seems it i…
-
Old value of Seniority Date doesn't appear in the report.Summary: Hi, We are building a BI Publisher report to track changes in different attributes in the system alongside Seniority Dates. So while we perform changes in that …Smaragda.gg 30 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Which table stores the Action Reason for salary?Summary: It doesn't seem the per_all_assignments_m but some other pay_* table, any idea? Content (please ensure you mask any confidential information): Version (include …Stefano_Mazzocca 17 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Narrative PPT Package and Data Grid rendering quality issueHi, Checking in to see if there is any progress in fixing the image quality issue with Report data grids that are embedded in a PPT package? We've tried the suggested wo…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…Sonal_Lalwani 44 views 4 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Is there a way to suppress invalid rows in a FCCS smart view ad-hoc?Summary: Hi EPM experts, Is there a way to suppress invalid rows in smart view ad-hoc analysis like we can in data forms? I do see an option to suppress invalid rows in …Anuj Patney - FIL 53 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…Visu 704 views 12 comments 0 points Most recent by SudiptaDey-Oracle Reporting and Analytics for HCM
-
Which table store the ESS Scheduled Process frequency, actual schedule start date and end dateSummary: We have requirement to get the ESS Scheduled Process frequency, actual schedule start date and end date details. I have validate the fusion_ora_ess.request_prop…
-
What role is required to run Reports in Lease Accounting TileSummary: Content (please ensure you mask any confidential information): I created a custom Lease role by copying the seeded Lease Contract Management role. However, when…
-
Copying POVs between reports in a bookSummary: I have several different reports that have the same structures but different selections of metrics. Say, one report has financial metrics (e.g. revenue, expense…
-
Need SQL Query to Extract Seeded and Custom Audit Report DetailsHi Team, I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the follow…Karthikeyan s-Oracle 84 views 2 comments 0 points Most recent by User_CNE9Q Reporting and Analytics for ERP
-
Access restriction for userSummary: Access restriction for user Content (please ensure you mask any confidential information): Hi, Would like to restrict user that normal user - only can read and …
-
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.5K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Roles that can create and update, or only view Financial Reporting reports connected to GL EssbaseThis concerns roles that can create and update, or only view Financial Reporting reports connected to GL Essbase. We need to understand two types of roles: one that only…
-
Drill through using FCCS Reports shows multiple links if POV is changed on ReportsWe have enabled drill through from FCCS to ERP using FCCS Reports . When we run the report and if POV is set correctly, it shows the link to Drill through to Source only…Batul Rangwala 11 views 4 comments 0 points Most recent by Batul Rangwala Financial Consolidation and Close
-
Effect of Redwood on custom Dashboard displayed on classic UISummary: Hello, We used a sandbox in oracle classic UI to create a custom group and in this group we have created a page entry to display a dashboard. This dashboard con…
-
Which tables are used to link the Goal Plan Assignment ID with archived transactions?Summary: Could you please specify which database tables store the Goal Plan Assignment ID? Additionally, which tables are used to establish the relationship between the …Nalsoft Pvt Ltd 15 views 0 comments 0 points Started by Nalsoft Pvt Ltd Reporting and Analytics for HCM