Reports
Discussion List
-
Access to tables which holds FCC Audit dataSummary: Hi All, Do we have access to tables which holds the FCCS Audit data in relational database? if yes, can you please share the name and tables structure of the ta… -
Data Source Name in the Narrative ReportingSummary: Content (required): Hi Experts, In the Narrative Reporting, we are getting data from multiple sources e.g. PBCS, FCCS and, ERP. It's difficult for the client to…
-
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 101 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is the equivalent of EBS Request Group in FusionSummary: I would like to know the equivalent of EBS Request Group in Fusion. For Example, I have a project accountant who needs to have access to run and view AP custom …Navaneeth TechM 61 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Report on Job Openings as of Last MonthSummary: I need to report on how many job openings there were as of last month. When I use the sql for last day of last month, the numbers aren't accurate as it is live …Jessica D 31 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Report showing previous month (starters, leavers)Summary: Is there a way to filter results for only a previous month - for example all new hires, terminations - regardless of the date the report is run? Content (requir…Gary Miller-39965 171 views 4 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Arrears report with Current Deduction And Total ArrearsSummary: Hi, I am trying to create a report that will show current deduction taken for Med, Dental, Vision Arrears along with how much the total is and if the full amoun…
-
How do you get the effective date based on the action reason value?Summary: I want to get the parental leave start date which is the effective start date based on the action reason = 'On parental leave' Content (required): I have the co…Ed Sevilleja 31 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Gross Pay - Previous Week and YTDSummary Would like to be able to report out on the previous weeks' gross pay along with the year to date balanceContent Currently we have two reports. One to pull the pr…Kyle Norris 149 views 6 comments 0 points Most recent by Deekshith Kalluri Reporting and Analytics for HCM
-
Need a list of all the BPM Approval Workflows from oracle fusionSummary: Content (required): Do we have any report or query or any front end screen which exports the list of all the BPM Approval Workflows from Oracle Fusion? Version …Vinay Gharge 538 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 311 views 2 comments 0 points Most recent by Bonnie Lafferty Reporting and Analytics for HCM -
Duplicate lines in Fixed Asset Depreciation reportI've created a simple analysis that pulls the depreciation details from the application and presents it in an overview. Here is the analysis XML: There's an issue where … -
Issue with Report Edit for Bursting QuerySummary: Issue with Report Edit for Bursting Query Content (required): Hi All Greetings! This is an issue as observed when we tried to open the data model- When we try t…Parag Hiremath 61 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Weird output behavior when reporting learn ItemsContent Hello, How can i change the export of reports so Each learning Item has it's own row? I can't figure this out for the life of me. This is the export now in excel…User_2025-02-06-13-23-44-898 30 views 3 comments 0 points Most recent by MichelleWard Reporting and Analytics for HCM -
BIP Samples?Is there another place to see samples of reports? the links from this page are brokenWayne Van Sluys 21 views 3 comments 1 point Most recent by Bhaskar Konar BI Publisher Learning Center -
How to create schedule wise S curve in fusionSummary: How to do Project Schedule wise S curve as explained in below link? Excel S-Curve Charts • My Online Training Hub Is there any workaround available? please advi…
-
Maximum Number Of Columns Created In Excel RTF TemplateHi All, What is the maximum number of columns supported by Oracle Fusion BIP report having Excel Template. Regards VijaiVijai Bhatia 61 views 4 comments 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
Could not able to search BI Consumer in PermissionSummary: Hi Experts, I have removed the BI Consumer role from a folder and when I try to add back the BI Consumer role, I could not able to search in "Add Application Ro…HarishVummidi 61 views 1 comment 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP?Summary: Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP? Content (required): Dear All, I would need to know if a Finan… -
BIP jobs are getting stuckSummary: BIP jobs are getting stuck Content (required): Hi Team, Greetings! We have been observing that multiple BIP jobs ( manual or scheduled) are getting stuck and re…Parag Hiremath 181 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report Error - PGA limit (MB) exceededSummary: Report Error - PGA limit (MB) exceeded Content (required): Hi Team, Greetings! We have been getting the error as per the attached file for the report in Product…Parag Hiremath 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to lock down HSGETVALUESummary: Would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet Content (required): I…User_2025-02-13-14-57-57-487 21 views 1 comment 0 points Most recent by Angus_Little Reporting and Analytics for ERP
-
White space added in PDF book reportSummary: For some of our users, when they generate the PDF output of a book in some of the text boxes white spaces are added. When they run the individual report, the te…
-
Failed to log into BI Publisher: invalid username or passwordSummary: Failed to log into BI Publisher: invalid username or password Content (required): Hello experts, we have done the P2T in oracle HCM, but after it, the connectio… -
SOC-1 for Subservice of FCCSSummary: What is the best way to obtain SOC-1 reports which are not available in MyServices? Content (required): Deloitte claims that clients cannot rely on Oracle's SOC…MrKellyGreen 123 views 2 comments 0 points Most recent by MrKellyGreen Financial Consolidation and Close -
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if …AjayKumar Maddipati 61 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBISummary: Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBI Content (required): Version (include the version you are us…Swati U 71 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report Output is blank after passing the flowInstanceName/payrollActionId of the Extract RunSummary: Hello All, Can anybody please give inputs for this issue. Report Output is blank after passing the flowInstanceName/payrollActionId of the Extract Run. The Extr…