Global HR
Discussion List
- 
            
      
            Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM - 
            
      
            Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…Afrid_3R3AE 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM - 
            
      
            Is there a way to bring UNION_ID for an employee in FAW? Please suggest a suitable PVO for UNION_ID.How to get UNION_ID for an employee in FAW? It is not present in assignment table: dw_wrkfrc_asg_f.Rituparna Maity 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM - 
            
      
            How to Restrict BIP report data based on the AORsSummary: Hi All, @Mandeep Gupta --> If you have faced any such type issues kindly help me with this. I have a requirement to build a BIP report in such a way that If emp…Dasari Dileep 403 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM - 
            
      
            Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id… - 
            
      
            Parag Hiremath 1 view 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM - 
            
      
            Aaron Reynolds 11 views 1 comment 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM - 
            
      
            Compensation Salary History Details Real Time not showing data for leaversSummary: Hi all I have built a report in OTBI using the Compensation - Salary History Details Real Time. I noticed I am missing data for employees who have left the orga…NusratB 71 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM - 
            
      
            Can we Autopopulate TRU as per the Legal Employer, when when hiring an employee.Summary: When hiring an Employee/converting a Pending Worker, in the Payroll detail section, we need to auto-populate the TRU as per Legal Employer. Is this achievable t…Megha N. 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) - 
            
      
            How to Create a Report for "Correct Employment" Transactions?Summary: I need to create a report for all the Correct Transactions performed by the HR team in a day/week/month but not sure which table to use? Is there a way to repor…Amit Mundlye-27103 11 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM - 
            
      
            Workforce Structures > Job Detail Screen - Can You Report a History of Changes?Summary: Is there a way to write an OTBI report that shows old and new values, field name and date of change entered on the Job Detail screen (Workforce Structures/Job D… - 
            
      
            Schedule report to run based on Last Run DateSummary: Is there a way to schedule a report to run starting from last run date? Content (please ensure you mask any confidential information): Version (include the vers…THawkins_LGI 32 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM - 
            
      
            In which table is the information about who rejected the notifications with rejected status?Hi, I would like to access the information on who and on what date the rejected leave notifications were rejected in the system. I would appreciate it if you could share… - 
            
      
            Grade values not appearing in the notification templatePlease refer to the document below for more information about the encountered issue. Thank you.VDoolhur 1 view 1 comment 0 points Most recent by ravali koaduru-Oracle Reporting and Analytics for HCM - 
            
      
            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 … - 
            
      
            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 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management - 
            
      
            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 21 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security - 
            
      
            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… - 
            
      
            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 41 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 … - 
            
      
            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 12 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM - 
            
      
            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 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM - 
            
      
            Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 122 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM - 
            
      
            is there any way to trigger email notifications through BIP based on demand.Summary: We want to trigger email to associates immediatly after the course enrollment through Bip is it possible to do?if it's possible how to approach.Help appreciated… - 
            
      
            Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 133 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM - 
            
      
            Draft water mark is missing in the draft fileSummary: Content (please ensure you mask any confidential information): Hi Team, Draft watermark is missing in the draft file. I have used the RTF template in the report…Ashok Dhara 82 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM - 
            
      
            Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM - 
            
      
            In oracle fusion which table have NationalityDear , I want to know in oracle fusion which table i can find nationality . in fusion i can see nationality in person document but not found in table ThanksMirza_Adeel 2.5K views 10 comments 0 points Most recent by Saleh_Taslaq Reporting and Analytics for HCM - 
            
      
            How to Retrieve Employee Active Assignment through Groovy ScriptsSummary: We are trying to get employee active assignments inside the Groovy scripts. For that, we need to configure the endpoints in web services. In the latest worker e…Karthick_Sathasivam 21 views 1 comment 0 points Most recent by Marius Voicu-Oracle Reporting and Analytics for HCM - 
            
      
            Report on Leave of AbsenceSummary: In our company, we use an Action in the Employment page to track if the employee is going on Leave of Absence (e.g. Maternity leave). Then, we use another actio…