Category 81
Discussion List
-
hr_org_unit_classifications_fSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…VarunMittal01 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Unable to access BI report using REST serviceHi, When I try to access BI report from postman it returns as 400 Bad Request Thanks -
How to fix legislation code in table per_person_names_f_v?Summary: The following query gives two different legislation codes for the same Employee due to which the extract doesnt pull the gender information for that employee: p…Shilpa Varghese 212 views 1 comment 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
OTBI scheduling agentsCan we use agents to deliver a url to prompt user to log into the system? We have reports which need to be delivered to recipients with varying AORs. e.g. JML for staff …Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 715 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we edit fonts on OTBI Analysis Reports?Hi, We are reviewing our OTBI suit and wanted to know whether it is an option to change the font to meet business guidelines - is this a possibility? Thanks! Katie
-
Issue with converting UTC time to BRT timeSummary: When I run below SQL to convert time from UTC to BRT (America/Sao_Paulo), output is not correct. There is a difference of 1 hour in the output. I read somewhere… -
which subject area contains the name column of transaction console of oracle hcmSummary: which subject area contains the name column of transaction console of oracle hcmContent (please ensure you mask any confidential information): Version (include …Sneha815353 42 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Can we call external application from BIP ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 3 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Total Compensation Statement - AnalyticsSummary: Hi All, We have completed generating the Total Compensation Statements for our employees. However; we would like to know if is there any way to get the analytic…Santhosh Bachu 11 views 2 comments 0 points Most recent by Santhosh Bachu Reporting and Analytics for HCM -
ActivityAttemptNumber - QuestionsSummary: We are loading Learning Record V3 business object where we have ORA_COURSE and ORA_SPECIALIZATION as the Learning Item Type. We ran the query and found that the…P_SNG 65 views 2 comments 0 points Most recent by Sunder.Velagala-Oracle Reporting and Analytics for HCM
-
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as…Scott_Turner_ 35 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc…
-
When we select Other as a disability category, a text box should appear in UISummary: When we select Other as a disability category, a text box should appear in UI. How to configure this requirement? Content (please ensure you mask any confidenti…Gleamy Mishra 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Restriction of DOR to dependents only and not employeesSummary: Restriction of DOR to dependents only and not employees. Eg: Birth certificate is required for birth of the children not employee. Only dependents Content (plea…Gleamy Mishra 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We have requirement to fetch the column 'Offering Section' in OLC moduleWe have requirement to fetch the column 'Offering Section' in OLC module basically Offering section is also a kind of leraning item and it is directly linked to the offe…
-
Move multiple candidates to rejected on Assessment, Initiate Assessment StatusSummary: We are trying to utilize the Move functionality to reject several candidates at a time, but we are receiving an error Content (please ensure you mask any confid…KMore 31 views 3 comments 0 points Most recent by ChelcieN-Oracle Recruiting, Opportunity Marketplace -
OTBI Reporting in UTC Time Causing IssuesSummary: Hello, We noticed that employees were showing as Terminated in OTBI before the end of the day (11:59pm) of their last day. The UI still shows an employee as Act…
-
how to fetch the direct report of the manager in otbiSummary: I am creating a journey and performance report in OTBI in which if a manger logs in then he need to see only his direct reporties. Content (please ensure you ma…Sindhuja Neerasa-Oracle 133 views 2 comments 0 points Most recent by Sindhuja Neerasa-Oracle Reporting and Analytics for HCM
-
Strange OTBI Error:[nQSError: 27046] Inaccessible columnSummary: Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screensh…
-
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisitionMartin_Melek 1 view 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Convert Rows to Columns in OTBI from multiple subject areasSummary: Hi All, We recently went live with oracle HCM implementation. I have a OTBI report requirement where I need to convert fields containing multiple rows to separa…Ameya_J 147 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ERROR MESSAGESummary: I can't submit Overtime Request from a Doc of Record Step up attached below: Content (please ensure you mask any confidential information): Version (include the…ahmed foly 21 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
In case of termination, there is a requirement to show last payment date.Summary: In case of termination, there is a requirement to show last payment date. Can anyone please guide on which oracle delivered field its captured? Content (please …
-
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
Can we able to send data from Oracle cloud to GCP directlyGot a requirment to send file from Oracle to GCP. Can we able to send the file directly? Need suggestions. Thanks, Keerthana.KeerthanaBaskaran 1 view 0 comments 0 points Started by KeerthanaBaskaran BI Publisher Learning Center