Reports
Discussion List
-
Can you insert Financial Reports into DashboardsSummary: I'm trying to insert Financial reports created in EPM into Dashboards. However it doesn't seem like this option exists. Only options are either to add forms int… -
FCCS reports show approval status/ calculation statusSummary: Client migrating from HFM to FCCS. When reviewing report contents, users want to know the current location/approval status. Functions were available in HFM to s…
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe… -
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…Mahendra 497 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a backend table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Lis…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 87 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
extract element type id from xml cacheSummary: How to extract element type id from xml cache: When I try to extract the value , it is always throwing error : extractValue(value(ElementEntry), '//ElementTypeI…
-
How to control or restrict OTBI access?Summary: We need to control OTBI access from accidental deletion of a folder/report and moving reports from one folder to another from business users? Content (please en…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 36.2K views 94 comments 56 points Most recent by JayanthP Reporting and Analytics for ERP
-
OTBI Subject area to get Project cost and accounting entriesSummary: Unable to get details of view accounting page from Project Costing - Actual Costs Real Time. Wanted to pull the Project cost transactions which are enabled for …Kalyani-Oracle 34 views 4 comments 0 points Most recent by Klaus Dimitri Zuidwijk Project Management
-
Oracle pbcs report (drill down support)Hi, I’m creating a report in the Reports section of Oracle PBCS. I’ve added the zoom option to enable drill down on the data. Currently, in the column for the Total dime…
-
Did You Know? Export Large Volumes of Project Costs to Excel EfficientlySummary Export large volumes of project costs from the Manage Project Costs page to Excel. Content You can export the search results on the Manage Project Costs page to …Amrit Mishra 1.6K views 25 comments 13 points Most recent by Andy May-Coates-Oracle Project Management -
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 55 views 3 comments 2 points Most recent by Rishitha sravanya Reporting and Analytics for HCM -
Journal # not in Consolidation Journal reports?Summary: I was wondering if it is intentional that Journal number (#) is not available as a column in "Consolidation Journal reports". I know that we can also use Label …HulyaAkan76 22 views 1 comment 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 245 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 1 view 1 comment 0 points Most recent by Akhila.Allagadda BI Publisher Learning Center
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 11 views 0 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 341 views 11 comments 1 point Most recent by Velidi Supraja Reporting and Analytics for HCM -
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 31 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM
-
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 52 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 923 views 16 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 1 view 0 comments 0 points Most recent by Akhila.Allagadda BI Publisher Learning Center
-
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …
-
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
How can I force FND_FLEX_VALUES_TL to update to the latest values for Description?After updating the Name of Department from '60508-East Operations-508' to '60508-Operations-508' via Setup & Maintenance > Manage Departments > Update > Submit The FND_F…Matt_C. 11 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
BI Report for compensation budgetSummary: I need to develop a report with compensation budget aggregated by country. Content: In a BI report (I can't use OTBI) I need to show the following data: Country…Gian Luca Triglia 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
List of all Oracle ERP ReportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Venkatesh Chittajallu 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …Sherie Ross 41 views 3 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM