Category 81
Discussion List
-
Which table store the data of Recruiting Category Enablement detailsSummary: Which tables store the details of Recruiting Category Enablement details Content (please ensure you mask any confidential information): Version (include the ver… -
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 32 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
SQL query to get the child department of a parent department from the department hierarchy in BIPI have written below query where I have hardcoded Organization id for which I want to fetch the child departments from department hierarchy in BIP report but the query i…Anjali_Kumari4121 63 views 3 comments 0 points Most recent by B Casla Reporting and Analytics for HCM
-
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not …Rajib_Samanta 295 views 20 comments 0 points Most recent by Jacqueline Mellonas Reporting and Analytics for HCM -
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, RaviRavi-Palacharla-Oracle 134 views 4 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
How to hide Page Options while accessing by managers Fusion Cloud HCMHi Team, Could you please to hide below Page Options (Edit dashboard, other options in it) while accessing by managers in Fusion Cloud HCM BIP.Chanikya Neelam-Oracle 1 view 0 comments 0 points Started by Chanikya Neelam-Oracle Reporting and Analytics for HCM
-
Generate Payslip - Archive Information and Generate Report ErrorSummary: When i ran Generate Payslip, The Archive Information and Generate Report log status are Error. Content (please ensure you mask any confidential information): I …
-
Labelling issue for Percentage Bar graphSummary: My client has created Graphs for OTBI report data as part of requirement and what we see in one of our Percentage bar graphs is we are not getting the expected …Mamatha P-Oracle 11 views 8 comments 0 points Most recent by Mamatha P-Oracle Reporting and Analytics for HCM
-
HOW TO GET ELIGIBILITY PROFILE Name in compensation through querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_RTHRD 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO missing dataSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to Add Home or Work Address for Internal Employee in Offer Letter TemplateHi, We are currently unable to include the Home Address or Work Address of internal employees when generating the offer letter using our offer letter template in Oracle …Narendra N 32 views 3 comments 0 points Most recent by Sridevi Kuttalingam Reporting and Analytics for HCM
-
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t… -
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re… -
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Query to extract all the updates made on employees assignmentsSummary: Content (required): Hello experts, when accessing the employee assignment page, it is possible to see users making last updates. Is there a query to extract all…Valerio Curzi 795 views 6 comments 0 points Most recent by VivekKumarAgarwal_CZTR1 Reporting and Analytics for HCM
-
Are there any seeded alerts for HR Help desk ?Summary: Hello Experts, We are looking to implement HR Help Desk for a client. However I am a little puzzled regarding the notifications capabilities of this module. Is …
-
How to Add DFF values to ApprovalHumanTask BPM Task TitleHi Experts, We need to customize the Title of the Sales Order Approval BPM workflow notification (ApprovalHumanTask) by adding Descriptive Flex Field (DFF) values. When …
-
Write a sql query to fetch average number of learning days per employeeSummary: Write a sql query to fetch average number of learning days per employee (includes all formal learning). Content (please ensure you mask any confidential informa…
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 294 views 10 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Defaulting the date parameter value based on their native languageHi Team, We are facing some issue in the existing report. Below is the details of the issue. 1. In one of our report, we are defaulting the date parameter value as Last …
-
Report BI - double column headerHi, is there an alternative to RTF for making a report with two headers on the columns? Example I have these columns: Organization Tot Male Female Tot Male Female Org1 4…
-
How to make the email confidential through bursting in BIPSummary: We have a requirement to make the email confidential in BIP , we are sending the email to recipients through bursting . Content (please ensure you mask any conf…
-
Query to get the failure reason of a transactionSummary: Please share any sample query to get the issue description of a failed transaction Content (please ensure you mask any confidential information): From the scree…
-
what table stores payment date of quick prepayments?Summary: hi All , i need to get the below payment date for BIP but i am not able to get the table which stores this. Please help. i tried PAY_REL_PAYMENTS_VL PAY_PAYROLL…Divya Vaish 21 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in…Katharina_Seidenfuß 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Unable to get requisition number value when combining with assignment subject areaSummary: Please find the report catalog , unable to see the value for Requisition number. I'm combining below three subject areas and for Recruiting I'm using Number of …
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 31 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
Missed Punch report using BIPSummary: Customer wants to create a BIP report which will give Missed punches of web clock. If there is public holiday or leave applied on that day and no punch data the…Siddhesh Nisal 11 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM