Reports
Discussion List
-
Report as reference doclet: grid per individual member (pov) in doclet?Content Narrative reporting: When using a management report (one grid, several cost centers) as a reference doclet, you are asked to set the POV when inserting the repor… -
Generate Data in Query with ThresholdSummary Generate Data in Query with ThresholdContent Hi - Is there a way we can generate Data through PCMCS Query with a threshold, say I would like to have only the Cos…Amit Agarwal-158816 43 views 3 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop…
-
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 39 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242 Reporting and Analytics for HCM -
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 30 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 191 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
EPBCS, EPM Cloud Planning Custom Expense DriversSummary I have created custom expense drivers, which relies on 2 different accounts. However when using the driver based expenses tab, every time I click save I 'm getti…
-
BI Pub folder/object security reportContent Hello, Are the catalog folder/object level permissions stored in a DB table? Can we report on what users/roles have been applied to folders/items to secure them?…JBlain 25 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…User_2025-02-11-13-25-48-351 28 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 16 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557 Reporting and Analytics for ERP
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…David Zajac 41 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …Rama Pedamallu-193980 63 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro…
-
Project task Exceptions-PPM Tables/ViewSummary Looking for Project Task Exceptions information in DBContent Hi All, I am looking for information about Project task exceptions data in PPM tables Or BI report t… -
PJC_TXN_TASK _NAME_IS_INV ALIDSummary PJC_TXN_TASK _NAME_IS_INV ALIDContent I keep getting this error for below. some transaction load and others error. Task Number Task Name 3 Overtime PJC_TXN_TASK …
-
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
FR Formatting QuestionContent Hi All, I am not sure if this is correct forum for this topic so please tell me if there is a better place, but I have a client that would like to embed their FR…Preston Oakes 22 views 4 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close -
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.2K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP -
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered…Alvaro Couto 160 views 12 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Oracle - Please update IDCS System Log Report to show Policy names, as well as IdentifiersSummary IDCS System Log Report is very difficult to use as it only provides the internal Identifier keys rather than Policy Names.Content The IDCS System Log Report is u…Alan Hall 14 views 1 comment 1 point Most recent by Joshua C. Stewart Identity and Access Management -
IDCS Dormant Users report cannot filter out Inactive UsersSummary IDCS Dormant Users report is not very useful as it does not differentiate between Inactive Users and Active Users.Content Inactive Users in IDCS will of course b…Alan Hall 20 views 1 comment 3 points Most recent by Joshua C. Stewart Identity and Access Management
-
Management Report Excel formatting inconsistent to on screen formattingSummary I am seeing issues downloading all of our Management reporting when downloading to excel - formatting is incorrect and different to on screenContent When using t…