Category 81
Discussion List
-
How can we give view only(Read only) access to Personal Details page in HCMSummary: How can we create custom Data Security Policies to give view only access to Personal Details(Redwood page) page PII information? Or we can give the access throu… -
Scheduled absences not showing in Absence OTBI ReportSummary: Hi All, Scheduled absences ("Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Scheduled Absences") not pulling any data in my OTBI report. Could a…Sai Krishna Chelikani 33 views 2 comments 0 points Most recent by Sailajad Reporting and Analytics for HCM
-
How to bulk update location namesSummary: Need to bulk change location names and location codes. We have thousands of records but have not found an effective way to make these updates. Content (please e…
-
NULL values in OTBISummary: I think it is generally best practice to suppress NULL values in OTBI, but client wants to keep them in report. But in their case, it's selective. Can we enable…
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, …AjayKumar Maddipati 13 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …Swapna Govind 50 views 3 comments 0 points Most recent by Swapna Govind Reporting and Analytics for HCM
-
Add a hyperlink to an image in a BI Publisher Interactive reportSummary: In an interactive report, it is possible to add a link to text using the appropriate icon, but how do you do it on an image? Thank you Content (please ensure yo…Guido Masciello 35 views 6 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
Restrict insertion of salary records with no changesSummary: Whenever we do transfers, promotions, and local/global transfers that do not have any changes to salary, salary records get inserted and the inserted record app…
-
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…Vasco 423 views 10 comments 1 point Most recent by Prasanth Subbaiahh-Oracle Reporting and Analytics for HCM
-
How to remove extra rows in report?Summary: Hello, I need help on removing these extra rows. These are my filters. Can you help to check what's wrong? Content (please ensure you mask any confidential info…
-
How to Access Oracle HCM Cloud User Activity Audit data via API or any method ?Summary: Customer has a requirement to track the activities logs data performed by HCM Cloud User via API or any other method. They are interested to fetch the user even…RBM 359 views 8 comments 1 point Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Smartview Error - "Unable to get property 'open' of undefined or null reference'Summary: I get the following error when running a macro to generate a report in smartview: "Unable to get property 'open' of undefined or null reference. Any assistance …
-
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…Barile Alberto 28 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to fetch attachment report from document of recordsSummary: Hi Team, How to fetch report for attachments of each employee. Content (required): Documents of records - Documents type- COVID 19 Version (include the version …AjayKumar Maddipati 171 views 10 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM
-
How to enable dynamic password while generating the payslipSummary: Hi All, Requirement: I need to make payslip dynamic password protected. For Example - Date of birth of the employee. Thanks. Content (required): I followed the … -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 23 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How can we add Date Prompt to DB prompt without using column from Subject areasSummary: We need to add a Dashboard prompt for Start Date and End Date. These two fields are just a Date parameter. We dont want to use any OTBI analysis column. How can…Abhishek Jois 31 views 6 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
Query to get Goal Approval StatusHello, For our report, we already have performance goals being listed in each row for every person. For each goals, we would require their approval status. However, when… -
Will the process Import User Login History affect performance?Summary: Client is asking if the process Import User Login History will negatively affect performance of the system or will it be negligible? Kindly let us know before w…
-
what does below hint mean?Summary: SET VARIABLE OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') GATHER_PLAN_STATIS…Pritha 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)Summary: We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are …SarthakRohilla 5 views 0 comments 0 points Started by SarthakRohilla Reporting and Analytics for HCM
-
How to add manager’s manager in OTBIWorking on a requirement to setup a report for any managers with incomplete performance documents. Eventually this will be sent as an alert to the manager and the 2nd le… -
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t…
-
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee…
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En…
-
Is it still available to use the ORA_ASSN_REC_COMPLETE_PENDING - LOOKUP CODE from HR_LOOKUPS table?Summary: Content (please ensure you mask any confidential information): I am working one report and i need to know all sub status for one learner. I used the following q…ClaudiaManea 1 view 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM