Reports
Discussion List
-
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 106 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.4K 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 361 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 1K 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 364 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… -
BI multivalue filter with bad performanceHello, We are tuning a query and see that the performance issue was in the multivalue filters. We are filtering invoices with the Code combinations table and filtering d…
-
What is Public View Objects (PVO) and where can we use it?Summary: What is Public View Objects (PVO) and where can we use it? Can it be used in Data model for BI Publisher report? Also, can we see the SQL or logic behind this P…Karun Jain-Oracle 5.6K views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to find out columns with empty value in Oracle fusion table through query ?Summary: Hello... I want to make a query to get all blank column names from a Oracle fusion table…Kindly help me in writing the query. Thanks. Content (please ensure you…I am a learner 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reportsHi Guys https://us.v-cdn.net/6034893/uploads/XBAKK1LFAVL0/wp-fusionbipaudit-5459609.pdf I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, …
-
How to get manager comments from absence approval notification in BI reportsHi Team, How to get manager comments from absence approval notification in BI reports We are searching for table name and field name that stores manager's approval comme…Anup Karmankar 31 views 1 comment 0 points Most recent by Florin Dumitru-Oracle Workforce Management
-
How to change 'TO' email address in workflow approval email notifications BIP TemplatesSummary: We have a requirement to change the "TO" email address when approving /rejecting workflow emails. We need to replace it with organization email address. Then it…Aditya Jena 35 views 2 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
Query to find instance refresh /clone date in FusionContent Hi All, Like we used to have below query in EBS to get instance clone date , what table is used in fusion. SELECT resetlogs_time FROM v$database; Any help is rea…Nidhi Chhajed 3.2K views 8 comments 0 points Most recent by Bhanuchander Manthri Reporting and Analytics for ERP