Reports
Discussion List
-
Using OTBI Analysis, how can we append sysdate (MM-DD-YY) to the filename?Summary: Using OTBI Analysis, how can we append the date (MM-DD-YY) to the filename? Content (please ensure you mask any confidential information): Can we append sysdate…SUSAN SANDIFER 52 views 5 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
How to get the 'Plan Period Start Date' in absence plan balances?I am creating a report that would output each plan's balances by year. But this one sample, for 2023, its calculation started from 2022, it's a bit complex I think. For …notautomni9 457 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Annualized Full Time Salary not in Compensation TablesSummary: Looking for a workaround for CMP_SALARY table not reflecting the actual salary information ()Doc ID 2403581.1) Content (please ensure you mask any confidential … -
Req staffing agent fields in OBISummary There are no equivalent fields to this in OBI so how can I report on this using the new Recruiting universe?Content I was asked to build a report showing our ope…User_2025-01-23-20-17-41-106 61 views 2 comments 0 points Most recent by FuriousSS Reporting and Analytics for HCM -
Trigger Running Reports through the APIHello, I would like to trigger the running of Reports (new style Financial Reports) through the API in PBCS and FCCS. There seems to be nothing available, the closest I … -
OTBI scheduling agentsCan we use agents to deliver a url to prompt user to log into the system? We have reports which need to be delivered to recipients with varying AORs. e.g. JML for staff …Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Can we edit fonts on OTBI Analysis Reports?Hi, We are reviewing our OTBI suit and wanted to know whether it is an option to change the font to meet business guidelines - is this a possibility? Thanks! Katie -
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 367 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
Is anyone experiencing an issue with attaching the Lease Details Report to a lease?Our accountants have a Lease Accountant role and when they try and run the process to attach the Lease Details Report, they receive the following: The lease detail repor…
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as…Scott_Turner_ 33 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
System Report in EPCMSummary: Need information on how to create the System report in Enterprise PCM Content (required): I am trying to create a System report (Rule Details) in the EPCM envir…Rajen Patil 61 views 3 comments 0 points Most recent by Bhavani Gajula Profitability and Cost Management
-
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to present both actual and rounded value in NRCS reports?Hi, We are replicating Peoplesoft reports in NRCS. In the original reports excel files, we can see values rounded off to no decimal points and when we select any cell, w…Guntuka VenkataKrishna 42 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Creating Bursting of Reports from FCC Reports to Application InboxHi Team, We are trying to burst reports from FCC Reports to FCC application inbox. Is there any way we can burst in inbox? As Currently bursting is possible to only Libr…Tejas Vaidya 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Bursting of Reports to External Directory or Inbox/Outbox of FCCSSummary: Hi, Is it possible to submit a bursting of reports and have it sent to an external directory or the Inbox/Outbox folder of FCCS? If not, is there an ETA or enha…Bruce Truong-235790 131 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
In Tax Reporting can we create a form or template for issuing certificate to vendor for Withhold TaxSummary: In TRCS-(Tax Reporting Cloud Services), can we create a form or template for issuing certificates to vendors for Withhold Tax paid and its respective details. F…
-
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisitionMartin_Melek 1 view 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…User_2025-01-22-19-28-29-985 98 views 6 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM
-
member not found error in epbcs reportsSummary: I am creating custom reports in EPBCS Planning application in development and now trying to migrate from dev to test environment and see that after migration re…
-
Do we have any joining's for PJF_TASKS_VSummary: Do we have any joining's for PJF_TASKS_V for bellow tables okc_k_headers_vl okhv, pjb_invoice_headers pih, fun_all_business_units_v fabu, PJF_TASKS_V ptv, PJB_I…
-
Need Oracle BI accountHi Team, We have registered as a Oracle Partner. We need Oracle BI reports account for creating and accessing data in it. Please provide us access to the account. Thanks…
-
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…Shant_Sarkissian_WJG 61 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Candidate Risk of Loss and Candidate Impact of Loss field table namesContent HI All, We have a requirement to fetch the succession plan, Candidate Impact Loss and Candidate Risk of Loss details through BIP . I find the "HRM_PLANS " and "H…
-
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 337 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
HCM Extract attribute back end QueryHi All, We need your help in finding out the Actual query being used in the back end of Attribute in HCM Extract. We built a HCM Extract with data group using the user e…
-
The tentative deprecation date for Oracle Financial Reporting in Cloud EPM has been updatedPlease note that the tentative deprecation date for Oracle Financial Reporting in Cloud EPM has been updated to sometime between mid-to-late CY2024 (subject to change, s…