Reports
Discussion List
-
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …JohnG 31 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…Anand Balasubramanian 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Added new Parent for existing members.Will we be able to get the data by default?We have added a new parent for the existing members in the Entity Hierarchy. We are looking for a way to get the data under the new parent by other than running Consolid…Shilpa Char 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we burst XPT templateSummary: We have an Report created with XPT template (Normal report creation). Can we use this template and burst the report in excel format? Content (please ensure you …
-
group & roleAssignmentAuditReportSummary: Hi, As the User Administration Tasks have been removed from audit, we are using roleAssignmentAuditReport and groupAssignmentAuditReport to gather the appropria…Alyssa Longo 1 view 2 comments 0 points Most recent by Vinay Gupta-Oracle Financial Consolidation and Close
-
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…gabriel kinovisques-163562 411 views 9 comments 0 points Most recent by Sachi Patel Reporting and Analytics for ERP
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 932 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
Report Repository DistributionMy company uses the report repository to send out batch reports to individual email addresses. We have a number of distribution lists that we need to manually update. Ha…
-
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 103 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 3.3K views 11 comments 0 points Most recent by Harshitha S Motagi Reporting and Analytics for ERP
-
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 11 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Knowledge Search Efficacy DashboardKnowledge Search Efficacy Dashboard; I would like to know exact information since the details are not present in oracle docs. a. # of Clicks b.# of Searches with Clicks …
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.5K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 355 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Need to Burst a Report with Multiple DepartmentsSummary: I need the Sales dept report and the Operations dept report to go to two different groups of emails. Content (please ensure you mask any confidential informatio… -
Write-back errorSummary: Write-back error - An error occurred while writing to the server. Please check to make sure you have entered appropriate values. Content (please ensure you mask…AM HRE 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…Rahul K-Oracle 995 views 2 comments 0 points Most recent by Jean Vishal Reporting and Analytics for HCM
-
Scheduled Jobs running for more than 2 daysSummary: Hi , In Explore Repository → Batch Schedular , One of the job that is scheduled for daily is still in running status since past few days . Even today the job is…
-
Can we customize 'Yearly Withholding Tax Report for Italy' report ?Summary: There are 2 requirements as below To add a period parameter 2. To add a new field on the report (The report uses a global temporary table, so how to know inform…Ankit Parikh 11 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 362 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Can someone please help, on where to find this value in oracle Tables?Hello can someone please help on where to find this field on HCM Table and Views? UI Navigation is Benefit Administration> Plan Configuration> Rates and Coverages> Varia…Joliver Caangay 11 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
A report that will show the Fusion Role's last update dateGood afternoon. I wonder if there's a Fusion Report that will provide the date when the Fusion roles were last updated? Let's say a specific role was updated by Oracle d…
-
How to stop/disable email bursting from BIP reports after P2T refreshSummary: Hi All, We have multiple custom BIP reports with email-bursting queries. When the P2T happens, we want to disable the email bursting from the custom reports. Si…