Category 81
Discussion List
-
How to sort characters numerically in OTBI?I'd like to order these custom values in OTBI numerically. However, this is how my current values sorted: The requirement is to sort them like this: 0-0.5 0.5-1 1-3 3-5 … -
I have a report with element totals and I need to filter so it only shows the total rowSummary: I was able to get totals by month for each element. Now I need to only have the Totals row visible. Any ideas? See below. I do not want each element total to sh… -
Index -1 out of bounds for length 10Summary: I have used Excel Template for the data model and getting following error: Index -1 out of bounds for length 10 Issue is there was already an excel template wit…Amit Mundlye-27103 640 views 4 comments 0 points Most recent by Amit Mundlye-27103 Reporting and Analytics for HCM
-
Adding Grade Details to Standard Approval Workflow Notifications using Custom templateBusiness has a requirement to add Grade under Employment Details section that is displayed in the delivered/standard Workflow Approval notifications. We have tried achie…Neeraj Awate 15 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
getting 406 Not Acceptable error while running the rest api for "Role Assignment Audit Report"Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…POOJAJSINGH 13 views 1 comment 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
table that stores "Enable Role for Access from All IP Addresses" indicator value (Role Basic inform)Summary: table that stores "Enable Role for Access from All IP Addresses" indicator in role page Content (please ensure you mask any confidential information): Need to k…SaiPavan Kumar Gadepalli 40 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
how to disable expired identity service provider(SSO)?Summary: In our single sign on configuration page(Security console), we see two expired identity service provider(certificates) with Enable Flag= Yes, we would like to k…Sushant95-Oracle 22 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to find user login to fusion application was via mobile or web browserSummary: Hello Team, We have a requirement to know the login to fusion application was done via mobile or webbrowser by the user. Appreciate your thoughts. Content (plea…Shiva Prasad M 21 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Reporting Variance - Security Console vs Security Detail ExtractWe would like to understand the source of truth for user roles and privileges. We have a report that is looping through the ASE_ROLE_ROLE_MBR table linking the child and…Clare Paone 22 views 1 comment 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Information of the logged in userCan I detect which operating system or device the user logging in to the system is using?Sinem Kara 14 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
EL expression not working inside Questionnaire in Performance documentSummary: Below EL expression not working inside Questionnaire in Performance document: #{(pageFlowScope.pDocumentInfoMap['pPerformanceDocumentName'] ne 'Document name')}…SagarLaddha 23 views 3 comments 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
OTBI report not displaying seniority dates for secondary WRSummary: OTBI report designed out of delivered subject area - "Workforce Management - Person Seniority Real Time", is displaying only the primary WR seniority dates. Whe…Suchayan_Garai 145 views 25 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is the Revoke User Access field from HCM termination process available in BI Publisher?Summary: The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in a BI Publisher report, but we have not been able to f…
-
Oracle HCM Table for currency exchange ratesSummary: Content (required): Hello experts, we have implemented custom BI Compensation reports displaying payroll elements and amounts in local currencies. Our customer …Valerio Curzi 262 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
Unable to extract learning course rating and link it to the related courseSummary: Hi, I can extract learning course rating data, by course participants, from OTBI subject area 'Workforce Learning: Learning Records Realtime' but I am unable to…Paul Morrissey 21 views 4 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 129 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration -
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 42 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting …
-
Event Tables Not carrying out the data from PROD to TEST on P2T RefreshSummary: On our recent P2T refresh the below event tables not carrying the data from PROD to the TEST environment. Please provide if there is any doc or reason for this.…Rengaraj G 22 views 1 comment 0 points Most recent by TSCloudLabs-Oracle Fusion Applications Administration
-
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can…Nick Dorfner 22 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
how to get the length of service based on gradeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…a.w.anand 14 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report not showing pictures when exported as Web ArchiveSummary: We have an OTBI report that stores images + html values. When extracted as Web Archive, first row displays image just fine, but row2 and row3 are only showing I…CAMIL_Q 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBISummary: How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBI Content (please ensure you mask any confidential information): Versio…
-
CSV output in body and attachmentSummary: Is it possible to show data in CSV format in the body of the email bursting as well as in an attachment? Content (please ensure you mask any confidential inform…Consultant Ian 13 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Are there any jobs to schedule hourly/daily/weekly for OTBI?Summary: We have schedule jobs for various areas of HCM but nothing that runs hourly/daily/weekly for OTBI reporting. Are there any jobs that you can recommend to schedu…LFafard 27 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to configure RTF Template on the basis of DatesSummary: Unable to configure RTF template on the basis of date of completion of course. For example CPO of the client firm has been changed and the change happened on 2n…Minal Nitnaware 21 views 3 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Reporting on total number of employees that completed a subset of learning itemsSummary: I have a requirement to create a summary report that includes how many employees have completed a subset of all of the learning items included in the filter of …Jacob Arfa 14 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
DNUSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anshul-Khandelwal 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Do we have any delivered HR and Manager dashboards in 24ASummary: Where can I find the delivered HR and Manager dashboards in 24A Content (please ensure you mask any confidential information): Are there any delivered manager a…Priyanka_Kumari 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM