Sample Reports
Discussion List
-
FBDI Fails to import Data containing Double Quotes(")Summary: FBDI Fails to import Data containing Double Quotes("). We are loading Items through "ItemImportTemplate" FBDI template. In item description we have data like WO…Lucky Sharma 234 views 8 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 44 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
"Total Amount" column in OTBI from Paysheet - ICMSummary: Anyone who knows the exact column name of "Total Amount" in OTBI? This is a field from Paysheets in Incentive Compensation. Tried other existing columns in the …User0901 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Simple sample report: persons processed during a payroll flowSummary: This BI report lists person number and person name for payroll flows in which person records would have been processed. We had a requirement to be able to dump …Shant Sarkissian_NES 62 views 2 comments 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Rtf template special character errorSummary: Content (required): Hello everybody, I was having a problem concerning the extraction of certain data to insert in an rtf template in word. In particular, extra…Gerardo Peluso 43 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Employee Commute DistanceSummary: We need a way to calculate and report on Employee Commute distance to support our Environmental, Social and Governance reporting. In our legacy data warehouse w…Chelsea Holden 31 views 3 comments 2 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 141 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 31 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM
-
Please, which subject areas can i use to build a report on personal information data.Summary: We want to build a report on personal information data. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…David Sakeye 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 2 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unarchive ErrorSummary: I am unable to unarchive the BIP report to BIP and getting the below error. Tried in different browsers by clearing the cache, but still the same issue. Content…Satyanarayana M-Oracle 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when …
-
which field stores value for Primary for national_identifiersSummary: which field stores value for Primary for national_identifiers Content (required): For National Identifiers in Front end,we can enter more than 1 National Identi… -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
Learning Records Real Time Report cannot add Hire Date field without rendering an errorSummary: Content (required): Since the Learning Management - Learning Real Time Assignment Subject area has been deprecated, we've been directed to use 'Learning Records…Ivy__Valverde 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Oracle HCM Cloud Mobile Apps usage reportSummary: Oracle HCM Cloud Mobile Apps usage report Content (required): Please we have a request from our Executive Management, we need a report that can show us how man… -
Creating a report to show how much time learners have spent learningSummary Is it possible to create a report that shows how long each learner has spent learning?Content Hi everyone, I hope you are well. I am currently trying to build a … -
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 171 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u…
-
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 11 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 41 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…Dian Minshan 1.7K views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
Catalog for Payroll Balances Real timeSummary: Trying to create a report from Payroll Balances Real time SA to match the Balance Results values from SOE with the amount included in the report for the respect…Hem 81 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise.Soumya Prakash Parhi 155 views 2 comments 8 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 41 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
User Login DetailsSummary: Hi I am looking for a BI / OTBI report that would give me the user login details. Content (required): I looking for a report that contains, User Name, Email, Pe…Manoj B. Cheruvathoor 421 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
RTF TemplatesSummary: Hi, Can anyone please provide documents or sample RTF templates for learning or exploring purpose. Thanks. Content (required): Version (include the version you …Padamatinti Varsha 91 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales