Report Delivery
Discussion List
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 171 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Benefits Report of Terminated EmployeeSummary: Hi All, Does any one have a Benefits report of terminated employees which Shows their enrollments with Dates parameter? Thanks Content (please ensure you mask a…Naveen setti 14 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Using Dashboard Prompts When Using OTBI AgentGood day Experts, Is there a way to use the available dashboard prompts in a dashboard when creating an OTBI Agent? For example I have a dashboard where the default peri…JMLMIII 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Error when scheduling Logical SQL ReportContent Hi all, I've scheduled quite a few logical SQL reports, but the two newest ones I've created (Change Value Reports) receive the attached error. Any ideas on what…User_2025-01-31-00-25-12-234 29 views 5 comments 1 point Most recent by User_U5JXC Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…Rama123-Oracle 67 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident…
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 52 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …Janardhana K 58 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Restrict user to go to Analytics pageIs there a way to restrict user to access to Reports & Analytics page. From Structure i have disable the Report & analytics page from Navigator and springboard. But we a…Sourabh Patial 41 views 7 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMYSummary: How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMY Tried with FND_LOOKUP_VALUES.Meaning does not return any vaue Can anybody Please…MilanMohanty 14 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e…MilanMohanty 48 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 230 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell…
-
In BI Report we have date parameters when we apply morethan one year we get time exceeds errorSummary: Hi Team, Hope all are doing great! In Onbaording BI Report we have date parameters when we apply more than one year we get time exceeds error if we apply less t…AjayKumar Maddipati 71 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
ORC Offers Transactions Report but need to add Requsition Number in BI it is possible ?Summary: Hi Team, ORC Offers Transactions Report but need to add Requsition ID in BI it is possible ? if how can i add this , I'm new to ORC. PFA of query. Thanks, Ajay …AjayKumar Maddipati 102 views 24 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you…THawkins_LGI 63 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti…
-
we have given the row num in select statemnt but we need row count also ?Summary: Hi we have given the row num in select statemnt but we need row count also ? need row count=2 ? Content (please ensure you mask any confidential information): V…AjayKumar Maddipati 11 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
We need termination reson column but how to link with any table ?Summary: We need termination reson column but how to link with any table ? PER_ACTION_REASONS_TL Thankss, Ajay Content (please ensure you mask any confidential informati…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to query for encumbrance amount on an Open status Purchase OrderSummary: We currently have PO139487 that has a status = Open. We are trying to query the tables to identify the encumbrance amount of $ 8,773 (35,700.00 - 26,927.00) usi…
-
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 13 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need citizenship column in BIP querySummary: Hi Team, We unable to find the citizenship column and we checked on per_citizenships table also . any one help me on ? Thanks, Ajay Content (please ensure you m…AjayKumar Maddipati 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one rowHI Team, when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row. how to…AjayKumar Maddipati 31 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FAW connection - Is support Oauth for Salesforce and PeopleSoft & SFTP supports - PGP encryptionFAW connection - It supports Oauth for Salesforce and PeopleSoft & SFTP supports - PGP encryption: Please confirm it is possible.Saravanan Pandian 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to …Oriana L. 11 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI icon with starSummary: Regards Oriana Content (please ensure you mask any confidential information): Hello experts, does anyone know what this icon refer to? I basically have an otbi …Oriana L. 11 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM