SQL
Discussion List
-
Standard Hours From per_availability_details.get_availability_detailsTeam, We have a requirement to get the standard hours for particular period. We have two parameters. Period Start Date and Period End Date. Ex. We are passing 03-Dec-202… -
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th… -
Get Scheduled Hours From Assignment Work SchedulesWe have a requirement to get the scheduled hours from Assignment Work Schedules. We are trying with the below code but its not giving hours. SELECT * FROM ( TABLE(PER_AV…
-
Can seeded flow Run Element Results Register be run secured by Business Unit ?Summary: Can seeded flow Run Element Results Register be run secured by Business Unit ? We have requirement to generate the output Run Element Results Register based on …
-
can we add filters for checklists tasks also in hcm extractswe wan to create DOR if the termination/resigantion checlists tasks are completed. Can we add filters for those also in HCM extracts. which bussiness object we need sele… -
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How many ways do I restrict the BIP reports and OTBI reports?Summary: How many ways do I restrict the BIP reports and OTBI reports? Content (please ensure you mask any confidential information): Hi Experts, Please tell me how many…Malak 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
No of days old in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Error on NLS_DATE_LANGUAGE code for Traditional and Simplified ChineseHello, We are editing a data model to update the date in a report for custom languages Traditional and Simplified Chinese and we are facing this error : "ORA-12702: inva…Lise_Rekik_Acc 31 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
query to get details of Potential assessment in talent review which is completed by the Managerneed to know the tables and links between the tables where to get the Manager Assessed Avg Performance, Manager Assessed Risk of Loss, Manager Assessed Potential, Manage…Sanduni Pathirathne 404 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 1K views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
ORA-20001:An internal assertion test couldnt be completed at location pay_balance_pkg.chk_rel_actionSummary: Custom BIP report is developed and It is not working from ESS job. Note: When it directly run from BI Publisher is working. Error: Waiting Time: 2 seconds Trigg…Bejoylin 404 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
address purpose Filed and table locationSummary: Looking to add the address purpose field into a previous BI report Content (required): I have a previous supply report i had built in BI publisher, a recent req…RJ Blankenship 111 views 6 comments 0 points Most recent by H.Chauhan Reporting and Analytics for HCM -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen… -
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 51 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…Anuroopa Sahoo 114 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Reporting and Analytics for HCM
-
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend …
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Pradnya_Pampatwar 411 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…Oriana L. 1 view 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need sql query to fetch the folder name in QuestionnairesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 21 views 2 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM
-
BI tables to retrieve employee assignment country and departmentSummary: Content (please ensure you mask any confidential information): Hello experts, we need to configure custom person security profile based on employee assignment c…Valerio Curzi 51 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Rollback of extract flow is not workingSummary: Rollback of extract flow is not working Content (please ensure you mask any confidential information): Hi Team, Greetings! We have a flow run which we want to r… -
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
Run Payroll Costing Report flow relation with Payroll Costing Report Extract?Hi All, I'm trying to understand if there is any relation between Run Payroll Costing Report flow and Payroll Costing Report Extract? My requirement is to modify Payroll…