Reports
Discussion List
-
Need Report books to run in parent -> child order.Summary: In FR Reporting our books ran in parent -> child order. Now in new Reports our books are running in child -> parent order. When we preview the member selection,… -
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…
-
OTM BI Publisher - barcode fontHi, We are modifying a report in Oracle Analytics using LibreBarcode39Extended-Regular.ttf font but when making any changes to the existing report the barcode is not dis…Carolina Alves Silva 22 views 0 comments 0 points Started by Carolina Alves Silva BI Publisher Learning Center
-
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 223 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
OTBI column formula help - change days to working daysIn my report I need the following column formula to calculate 5 working days (not 5 days as it does now) and leave out Saturdays and Sundays. Any help would be great. CA…
-
Can we customize Process Lease Actions report.(Generate Lease Transactions and Balances Report')Can we customize Process Lease Actions report.(Generate Lease Transactions and Balances Report') Need to customize Process Lease Actions report as per client requirement…
-
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…Marilyn O 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can we display different Infolet tiles based on each page?Summary: Is it possible to display difference Infolet tiles based on page (e.g., Me, My Team, My Client Info)? Can EL expressions solve this problem? If so, please provi…Nipon 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
Reporting on Payroll Balances with a Time Definition DimensionSummary: Hi, we have a number of payroll balances defined which utilise element allocation functionality and have a 'time definition' dimension i.e. _REL_BD_TDPTD. The t…Jon Taylor 23 views 2 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM
-
Mass Download of Document Records errorsSummary: Can you get details on the skipped downloads or those with errors? Content (please ensure you mask any confidential information): This is in the log file: Total…Stephen Jones 25 views 1 comment 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…Charan Kollipara 117 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What Value should be provided to Lexical parameter for Seeded Report Data modelHi All, What value should be provided to below Lexical parameter for Seeded Report Data model of Uninvoiced Receipts Accrual Report ? &ACCRUAL_ACCOUNT &CHARGE_ACCOUNT Th…
-
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
Pass the member from year to retrieve custom1 dimension memberSummary: Looking for a way where user can select the member from year dimension in POV and based on that the respective year acquisition member from custom1 dimension wi…
-
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C…THawkins_LGI 41 views 15 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
generate report from NR on the EPCMSummary: Triggering burst Definition to generate report from NR on the EPCM application by using Rest API but the groovy is not working. Content (please ensure you mask …
-
how can u migrate and use Management report created in NR(Narrative Reporting) to EPBCSSummary: Hi Folks, So, I am trying to import the report from NR to EPBCS application. I tried multiple ways of it: Tried exporting the report from Narrative Reporting in…Himani Jain-Oracle 22 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
Lease amortization schedules extract missing bigger report?Summary: We're exploring the lease amortization schedules extract and we were expecting a more detailed report. Is the text file report the final result? It looks like j… -
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.… -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 82 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 156 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 335 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…