Reports
Discussion List
-
May I know which subject area suitable for below columns ?Summary: Hi Team, May I know which subject area suitable for below columns ? unable to find ? Thanks, Ajay Content (required): Version (include the version you are using…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Exponential formula does not work as expectedSummary: Content (required): We have difficulty with below exponential formula that results in #ERROR in Narrative Reporting. This formula works in excel as shown below:… -
Map Smart List in BSO to Dimension in ASO - Text Account Display as Text not Essbase IDSummary: We are exploring the use of the functionality to map a Smart List to an ASO dimension via data map so that a report can be pulled in Management Reporting using … -
How to design the report in Financial Reporting Web Studio ?Summary: In FRS , when giving a custom heading to a dynamic calc member , how do we avoid the children taking up the same custom heading as the parent member in the HTML…
-
Job code with Null profilesSummary: Hi Everyone! I am trying to create a report which should fetch the job codes with No profiles in Manage job page. I hard coded one job code which is having no p…
-
Performance Management Eligibility ProfilesContent Hi All, I am unable to find the table names for "Manage Eligibility Profiles" and "Profile Criteria". Please finds the attached screen shots for your reference a…
-
Succession Permission AuditSummary Succession Permission Audit ReportContent Is it possible in Oracle HCM to create a report showing all plans, and the individuals who have Succession permission f…
-
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…Shea Hartsell 275 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Analysis to identify employees with missing payment method - any help appreciatedSummary: We are looking to create an OTBI (not BIP) analysis which returns employees who don't have a payment method Content (required): Our current queries are bringing…Kevin M Storrie 81 views 5 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …Nicolas Vahman 42 views 4 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for ERP
-
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 41 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Privilege required to get data for OTBI reports from General Ledger - Transactional Balance RealTimeSummary: Content (required): Hi, What is the privilege or duty role required to obtain data from General Ledger - Transactional Balance Real Time subject area for users …
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 405 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Group columns for expand / collapseSummary: In excel grouping columns / rows so you can expand and collapse them is often used function for reports. Is there an equivalent in Oracle Planning? Content (req…
-
Folder Permissions Error in 22BSummary: Since 22B we receive error when adding or removing users to folder permissions under Custom Content (required): The following error is thrown: "Exceeded number …Janine Brown 31 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Cross Receivable Subject Areas in OTBISummary: Cross Receivable Domain in OTBI Content (required): Hi, I would like to know if there is a way to link the domain "Receivables - Standard Receipts Application D…Antoine.Kaiber 91 views 1 comment 0 points Most recent by Antoine.Kaiber Reporting and Analytics for ERP -
Consolidation Journal Report IssueSummary: Report times out when running against single account Content (required): When running a consol journal report it times out when running against a single account…Jeremy Stubbs 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Suppress Missing Blocks - Identify intersections of data that exist, but have missing blocks?Summary: Using a form, we are suppressing Missing Blocks to ensure that we do not hit the data governor. In validating the forms, we discovered that the checkbox "Suppre…
-
Need the query to get the data on the Review Budgetary Control Balances UISummary: We need a query for a report, which happens to be the details of the Review Budgetary Control Balances UI. Please assist. Please assign this SR to the relevant …Sushan Peiris 323 views 3 comments 0 points Most recent by Catherine Myrand Reporting and Analytics for ERP -
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 71 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 212 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 483 views 8 comments 0 points Most recent by Arun Menon Reporting and Analytics for HCM
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…Dannielle Dellucci 41 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 362 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…Abhilash K - Deloitte USI 173 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP