Reports
Discussion List
-
Intercompany Matching Report EnhancementsSummary: Looking for Enhancements in Intercompany Matching Report Content (please ensure you mask any confidential information): Hi All, We are facing below issues with … -
AI Agent Audit ReportSummary: Two different BI Publisher reports to track AI Agent usage by end-users and administrators. Summary Audit Report that audits a completed conversation from a pub…Race Schreimann-Oracle 10 views 0 comments 0 points Started by Race Schreimann-Oracle AI for Fusion Applications -
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 85 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