Reports
Discussion List
-
Report for Position Attributes change HistorySummary Looking for a report whcih can give us history of position attribute changes.Content Hi I am looking for a report to track changes in all position attributes lik…Mohit Gupta-45440 232 views 10 comments 1 point Most recent by Jesus N Reporting and Analytics for HCM -
Custom Report example for PPM Allocations ?Summary: Custom Report for PPM Allocations ? Content (required): Hello I would like to create a custom report for PPM Allocations, will you please share with me the tabl…Cesar Saveedra 41 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management -
How to get member aliases from row dimension set as "Children of" in ReportsSummary: Planning - Reports Content (required): Hi, I have a report with 2 row dimensions. The first row dimension is set as "Children of [Total Expenses]", the second o… -
How to enable Data - "Create Ad Hoc Grid"?Summary: Cannot find "Data" in FCCS. How can it be enabled to create Ad hoc grid reports? Content (required): Hello, I can find "Data" in FCCS in the Test instance, but …Teodora Bulancea 51 views 6 comments 0 points Most recent by Teodora Bulancea Financial Consolidation and Close -
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh… -
Balance Initialization Data - Payroll ExtractsSummary: Fetching data from balance loads in balance group reports. Content (required): Hello, We are building a payroll report using HCM extracts. Using a combination o… -
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on … -
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…Jithin Mathews 91 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference?Summary: Hi Team, We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference? what is the main purpose of ESS JOB . How can we u…AjayKumar Maddipati 111 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…User_2025-01-30-23-52-10-842 177 views 2 comments 0 points Most recent by Mirela Tomoiu-Oracle Reporting and Analytics for ERP -
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to edit Subject in Enterprise Onboarding mail- ChecklistWelcomeReportSummary: Wanted to customize the Enterprise Onboarding email subject being sent. Content (required): We want to display the first name in place of full name in the Enter…Gourabh Choudhary 51 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
IfThen formula function Management reportSummary: Hi All, For a specific report I have been using the formula function "IfThen", but I am struggling to have the falseparameter defined properly. The goal is to g… -
Need Enterprise Onboarding Template NameSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We need the path of the template. We want to display the first name in place…Gourabh Choudhary 52 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …Pritam Das 271 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Most Recent Assignment RecordSummary Most Recent Assignment RecordContent When we need to report inactive and active employees in one analyses, it is not easy to get the latest record (for example, …User_2025-01-23-21-37-42-476 76 views 9 comments 1 point Most recent by Julie Mandel Reporting and Analytics for HCM -
Is there a way to build a Custom BI Report similar to Lease Disclosures ReportSummary: Is there a way to build a Custom BI Report similar to Lease Disclosures Report Content (required): Version (include the version you are using, if applicable): C…
-
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, …Anders W. Langholm 161 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP -
Payables Multi-Period ReportSummary: HI, Anybody have AP multi-period invoice reports with amortizations? Content (required): Version (include the version you are using, if applicable): Code Snippe… -
Formula for exporting date in csv as dd mmm yyyySummary: I have a need to present date in a csv extract as dd mmm yyyy. I have the below formula that presents it as dd mm yyyy, any assistance that could be provided to… -
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 194 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
New Redwood reports available for P&GSummary: Hello, Is there any new redwood reports available for Performance & Goals? Kindly provide the links here. Your help is highly appreciated. Regards, Hazel Conten…Hazel De Castro 51 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 42 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Security on HCM ExtractWe have created a extract and the customer want to implement security. Business Unit Security Need To Be Applied. The extract output should show only the records as per … -
we need below BI columns but unable to development of those from absenceSummary: any one help me and to the requirement Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that …AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Degree Reporting - Item Code not available in Subject AreaSummary: Hello there, I'm trying to create a simple analysis that provides a full list of Degrees and the Item Code. There doesn't seem to be a "Item Code" option to sel… -
How can I pull the source information indicated on the Candidate Profile.Summary: We are looking to pull the source information that is stored on the Candidate Profile - not the submission that is associated with any requisitions. Content (re…Craig Stevens 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM