SQL
Discussion List
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column… -
Asking for some tips for these column in OTBI to BIPSummary: Hi there!. May I ask some idea where I could find these columns in BIP - Report Content (please ensure you mask any confidential information): Version (include …
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe_Cannova 45 views 2 comments 0 points Most recent by User_PFO2E Reporting and Analytics for HCM -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,…Barile Alberto 92 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for HCM
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 802 views 9 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…
-
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…
-
BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actualSummary BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4445, maximum: 4000)Content Hi, Can anyone please suggest a…Manisha Chakraborty 100 views 10 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
need sql query / table name to get system ip and host name Against transactionsSummary: i need to get system details against each transaction. ex: some one created 1 transaction then need to know through which system it got created (system ID , hos…Eswaraiah.chikkala 11 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Release 12 HCM OTBI Subject Area descriptionsSummary List of Release 12 HCM OTBI Subject AreasContent This spreadsheet provides the list of HCM OTBI R12 subject areas with descriptions, business questions answered …Raghavendra Raghunath-Oracle 943 views 11 comments 10 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …Shanna Oppenheim 112 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to retrieve 'Exempt from Long Term Care' associated with Washington tax card from backend table?Summary: I am trying to locate 'Exempt from Long Term Care' linked to the Washington Regional Tax Card in the backend table, but I cannot find the base name in the backe…Swapna Udaiyar 61 views 7 comments 0 points Most recent by Gabriela Ichim-Oracle Reporting and Analytics for HCM
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…
-
How to default the Location of Logged In User in Dashboard PromptSummary: 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 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
SQL Query for Learning Plans and ProgramsSummary: Hello I need a query that gives the following attributes in the Learning module: Program Name Plan Name Plan Profile Name Plan Profile Creation Date Content (pl… -
Report showing all ElementsSummary Need a report to show all element entries that have been created (Recurring and Non-Recurring)Content HI All, I hope this is a simple ask but I can't seem to fin…
-
SQL to Show Which Pay Frequency is Associated to Which Legal EntitySummary: I am tasked with producing a mapping document of which Pay Frequencies are associated to each legal entity. I can find the Legal entities in "HR_LEGAL_ENTITIES"…Mickey James 14 views 2 comments 0 points Most recent by Mickey James Reporting and Analytics for HCM
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Summary Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Content Hi AllWe have a requirement to build Employment letter, letter is in …Naveen Jayaraman-48236 15 views 8 comments 0 points Most recent by Bhardwaj Yash Reporting and Analytics for HCM -
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 11 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
element entry secured views queryIs there a query that contains a table to be used to get only the secured list element entries based on the element security profile. Similar to the table per_person_sec…bervin13 22 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 43 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 11 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 23 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Need table name for Business Object Type and its associated actionsSummary: Need table name for Business Object Type and its associated actions, as we are working on deep link for Job Requisitions page. So we are searching for actions u…GajavalliKoteswararao 11 views 0 comments 0 points Started by GajavalliKoteswararao Reporting and Analytics for HCM
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? PFA. Thanks,…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary sql statement to get the performance document current taskContent Can anyone help me on how to fetch the current task for the employee performance document , the…MahmoudAllam 2.6K views 9 comments 0 points Most recent by jatinl022-Oracle Reporting and Analytics for HCM