Reports
Discussion List
-
Report for Approval Status of Performance GoalsSummary Report or Dashboard for Approval Status of Performance GoalsContent Hello All, A report/dashboard is required to show current Approval Status of Performance Goal…Veena P 458 views 6 comments 0 points Most recent by Mayqueen Sefakor Attatsitsey Reporting and Analytics for HCM -
Pre-Active and Post-Active Details OTBI subject areaSummary: Pre-Active and Post-Active Details OTBI subject area Content (please ensure you mask any confidential information): Hello Experts, I'm currently using the OTBI … -
How to track the user who delete a report/data model/folder in the Reports and Analytics areaSummary: How to track the user who delete a report/data model/folder in the Reports and Analytics area Content (please ensure you mask any confidential information): Hi,…Barile Alberto 251 views 2 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Descendants before childrens option in ReportingSummary: Content (please ensure you mask any confidential information): Hi all Can someone please confirm if there there is an option to display "descendants before chil… -
What setup should perform to enable the drill through to Summary Level in EPM FCCS?Summary: The drill through is working fine in EPM Report but not in data form. Content (please ensure you mask any confidential information): Version (include the versio…User_ZCB13 71 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
How to add threshold line in Narrative Reporting bar charts?Hi Team, can we add threshold line on Y axis in narrative reporting bar charts to compare the value with specific threshold value. eg. If we have bar with data 10,000 an… -
How to report on worker Area of Responsibility records assigned?Currently created an analysis report in OTBI to pull Area of Responsibility records against current active employee records. Tried testing with a variety of ways with di… -
Specializations not pulling in Enrollment typeSummary: I pulled a report for Learning Assignments (To match the Learning Assignments Screen that summarizes a Team Members Learning Assignments) The screen shows the s…THawkins_LGI 21 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Copy URL functionality in Reports not loading the report since updating to redwoodSummary: We have been using the copy URL feature in EPBCS for some time but since updating to redwood we have found that some of our reports are no longer loading throug… -
In BI Report we have date parameters when we apply morethan one year we get time exceeds errorSummary: Hi Team, Hope all are doing great! In Onbaording BI Report we have date parameters when we apply more than one year we get time exceeds error if we apply less t…AjayKumar Maddipati 104 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL query or Table for Cost Accounting DistributionsHi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organizat… -
Reporting on Seniority DatesSummary: Our OTBI reporting only has 2 Seniority Date codes when there should be 5. Content (please ensure you mask any confidential information): When I run a simple re…Kevin Orze 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Custom Dashboard look and feelHi Team, My customer has shared a requirement to customize a OTBI dashboard and wanted to view like attached image. Is there any option to make such graphical view? Plea…Mohan Murali P-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 121 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
multiple phone numbers on single rowSummary: I have an employee report returning multiple rows when the employee has multiple phone types. Does anyone know how to correct so that the report only shows one …Gaby Castelan 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
alignment issues in EPBCS reportsSummary: While trying to create a report in epbcs, I am trying to put a graph and grid side by side and they will always have alignment issues in size though size, width… -
Narrative Reporting Formula - Ignore negative values in sumHi, In narrative reporting I have a number of conditional suppressions in my report for negative values. I am trying to only sum the positive values for a certain range … -
Can migrating Reports between TRCS applications be enabled?Summary: Solution to migrate Reports (Narrative Reporting) from one TRCS application to another Content (please ensure you mask any confidential information) We are atte…Catherine Carney 52 views 3 comments 0 points Most recent by Komala Reddy-Oracle Tax Reporting (Direct Tax) -
EPBCS Report BuidingWhat is the best way to create a report from different cubes from epbcs, Where we have different prefixes for the metadata from account dimension members? Eg : TPF_ABCD(… -
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
ORC Offers Transactions Report but need to add Requsition Number in BI it is possible ?Summary: Hi Team, ORC Offers Transactions Report but need to add Requsition ID in BI it is possible ? if how can i add this , I'm new to ORC. PFA of query. https://us.v-…AjayKumar Maddipati 101 views 24 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…THawkins_LGI 21 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - … -
Invalid Intersection Report - Audit InformationSummary: We had a user create an Invalid Intersection Report, and the audit log information for this action was a bit unclear. In the audit records, the creation of this…Alyssa Longo 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Text String to Number Function in Management ReportingSummary: We have a report requirement for which I need a substring of a number from a member name to use in a formula in the report. Is there any way to achieve this wit…