Category 81
Discussion List
-
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S… -
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
BIP report with Excel template output file showing wrong time when compared the value in Data modelHi Al, I am working on a conversion BIP report where I am printing Start Time, End Time in the output file. when I loaded the XML and inserted the fields into the Excel …JP Chandran 25 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How/where can I get a glossary/dictionary of language pack translations for all UI text?Hi We are in process of implementing HCM & Learning cloud for 5 countries in Europe. As part of the implementation, we have a couple of custom reports (BIP) to be genera…Jayant Ankur Kujur 62 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor…Cansel Karasoy 205 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can’t design the RTF file in Arabic layout when the report exceed 64 fieldwhen the report extracted from system the layout starts from the middle of the excel sheet and technical advised that he can’t design the RTF file to start from the (Cel…Omar El-sherif 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
HCM Table To Fetch BCC Details From Report Job HistorySummary: Need HCM table to fetch BCC details from report job history Content (please ensure you mask any confidential information): Version (include the version you are …puja suryanarayana 31 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Query to find the email recipients of the scheduled BI ReportsSummary: Hi, Is there any Query to find the recipients of the BI Scheduled Report using Job. If I knew the Report name, I can get this details by Jobs History -> Edit . …Faqir 228 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIAJoycieee 22 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How we can schedule report to a shared folder.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…Abhishek.Sachdeva 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring … -
How can we determine what field BI Publisher Attributes are linked to ?Summary: Is there a search option that we can use to find out what field is linked to an attribute? Content (please ensure you mask any confidential information): Versio…Antonio Washington 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Randomization of employee list(from different BU/Department) for every runSummary: Report to fetch Random list employees for every run Content (please ensure you mask any confidential information): I need the report to fetch randomized list of…Raksha Govindaraj 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Charts in bip how to use more value columns in oracle hcm fusionSummary: Issue: 1- When I create chart it maximum allows to add 5 values but I have more than that to be added. 2- Percent split inside the bars how to display ? How to …Deepeeka Nath 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How can we add dynamic dates to a scheduled BI report?Summary: We would like to schedule a BI report (integration) to run every two weeks with the parameter date as the new payroll date. For example, run the report on April…Terri Butler 77 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
HR Dashboard - Headcount Tab - Where to find data, how to change colors, and how to change filters?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know the reason the colors are different for the same categories and if they can be…Jay_Brannan 3 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Keri N 2 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
B S Rafatullah-Oracle 41 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
Custom BI Publisher reports takes a long time to completeSummary: I created a custom BI Report. When I run the report it takes about 23 seconds to complete. When my client runs the report it takes almost 10 minutes to complete…Consultant Ian 45 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Transaction ID is missing Human Capital Management - Approval Notification Archive Real TimeSummary: We are trying to develop a report with below two subject area Workforce Management - Worker Assignment Event Real Time and Human Capital Management - Approval N…
-
How to change the name of an UDT once created?Summary: Can we change the name of the UDT after it has been created? Content (please ensure you mask any confidential information): Version (include the version you are…Sudita 20 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Payroll and Global Payroll Interface (GPI) -
BIP Report Citibank PaycheckHello everyone, I would like to ask if you have or if there are any existing RTFs that follow the specifications for Citibank Paycheck. Thank you.CAMIL_Q 3 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Darrin N 3 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I create multiple records in a single payload from Postman?Hi, I can create them one by one as follows, but I get the following error when creating more than one record in a single payload. Can you correct my mistake? Thanks { "…Cansel Karasoy 11 views 2 comments 0 points Most recent by Bianca Culea-Oracle Reporting and Analytics for HCM
-
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
-
BPM Approval notification BI report for "Request a New Position" notificationSummary: When an employee is moved between departments, a "Request a New Position" notification is distributed. This notification provides details on positional details …Maruthi T 14 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
Email bounce back notification fusion hcmSummary: Client have a requirement where in a recipient try to reply to "sender email address" an email bounce back notification to be sent to recipient. for example: De…Shiva Prasad M 11 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…Manoharan 65 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
All Active employees that receives no pay or $0 gross pay for any pay periodSummary: There is a requirement where client need a report having list employees receiving no pay or 0$ Gross pay based on previous 26 pay periods. We have a bi-weekly P…Rahul Saini 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)