Reports
Discussion List
-
Table to pull the ESS Scheduled Job definition details.Summary Required table which stores the ESS scheduled job defiinition details.Content Hi Experts, I would like to know from which table we can pull the ESS Job definitio…Charan Kollipara 118 views 3 comments 1 point Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for HCM -
Right-of-use asset maturity reportSummary: My SME's have identified some gaps in the lease accounting reports/ aspects they do not understand. Any advice is welcome. Content (required): Looking for a rep…User_2025-10-10-00-26-55-794 32 views 1 comment 0 points Most recent by Maria Mendoza - Oracle-Oracle Lease Accounting -
Committed Costs showing on Project Control Budget Balances report but is not in Manage Committed CosSummary Committed Costs showing on Project Control Budget Balances report but is not in Manage Committed Costs PageContent We have committed costs showing in the Project…Michelle Swisher 82 views 4 comments 0 points Most recent by Venkat Patlola-Oracle Project Management -
How to take Resignation Submission date?Summary: How to take Resignation Submission date? Content (required): Hi All, Report requirement to show employee's Resignation Submission Date. From which table we can …Venkatesan 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to perform Drill through source on financial reportSummary: Content (required): Hi, We are trying to create a drill through on reports. When we select level 0 member for the project dimension and keeping the other dimens… -
OTBI Report for Manage Unprocessed Cost Area in ProjectsSummary: I am trying to create an OTBI report to extract all the Cost available in Manage Unprocessed Cost area (Projects) where most of the Columns are extracted. (I am…Shashank Verma-Oracle 62 views 3 comments 0 points Most recent by Shashank Verma-Oracle Project Management -
Rehires are showing twice when using Seniority Years in Wrkfrc Mgmt - Person Seniority Real TimeContent (required): When I add Seniority Years (or months/days) to a report in this subject area, rehires are duplicated with one row calculating based on their enterpri…Monique Dias 53 views 5 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM -
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 234 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 42 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 94 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 181 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 51 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 272 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 163 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…