Sample Reports
Discussion List
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 152 views 2 comments 4 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
We need PVO's for the following tables in BICC but we couldn't find these in Lineage Sheet.Summary: We need PVO's for the following tables in BICC but we couldn't find these in Lineage Sheet. CMP_RANGE_DIFF_VALUES_F CMP_RANGE_DIFFS_F_TL Can you please help me …Janardhana Kondaveeti 11 views 0 comments 0 points Started by Janardhana Kondaveeti Reporting and Analytics for HCM -
Embedding BI/OTBI Reports in My Learning Experience (Redwood) for LearnersHi Everyone, As a learner, I’d like to know if it’s possible to display a BI or OTBI report directly within the My Learning Experience page (Redwood experience). Navigat… -
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…
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 51 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP Report issueSummary: Hi I am trying to extract Item master data . Count is huge and getting below error. What is way to extract all records in csv Content (please ensure you mask an…
-
User Adoption Insights - Preconfigured Sample Reports in OTBISummary Sample reports for user adoption insights in OTBI are available with attached .catalog fileContent Oracle CX Sales has received requests to provide pre-configure…Greg Rice-Oracle 697 views 13 comments 9 points Most recent by Navin Jose-Oracle Reporting & Analytics for Sales -
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 571 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
Need relation between Project and Expenditure OrgSummary: I want to extract Data using BIP for Project and Expenditure Org. Can you please help with relation or if any SQL is present Content (please ensure you mask any…
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 7.1K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.6K views 8 comments 0 points Most recent by User_E31A6 Reporting and Analytics for HCM -
User Access Report (v2) API has only POST command available currentlySummary: One of our clients has requested the GET command for the user access report. Could you please let us know the expected timeline for its availability? Content (p…Swathi Gutta-Oracle 31 views 3 comments 4 points Most recent by Swathi Gutta-Oracle Reporting & Analytics for Sales
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 91 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 96 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 199 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 163 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult… -
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 6.1K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
Subledger Period Close Exception ReportSummary Subledger Period Close Exception ReportContent I am seeing these transaction on the Sub-ledger exception report as per below table. 1. Does this means they were …
-
Service Usage Metrics Report for EPMSummary: One of our customers has requested the Service Usage Metrics Report for EPM (Hosted Named User, Hosted Employee, Records, and Hosted Employee details) from OCI.…Swathi Gutta-Oracle 43 views 2 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
RTF Template File Size Limitation in OLC CertificationHi Team, In the Oracle Learning Cloud (OLC) module, I’ve created an RTF template for course certifications. The template includes six different certificates for six diff…
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 61 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…
-
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…MayuriMMote 243 views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for ERP