Data Models
Discussion List
-
How do I adjust time zone ins rtf date fieldI'm configuring a RTF template to a term document, but here's my problem, in that document it must contain the from date of a compensation plan, but when I put the field…Lucas Gaspechach 11 views 0 comments 0 points Started by Lucas Gaspechach BI Publisher Learning Center -
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo… -
Need the last modification date of 'Generate Audit Report'Hi Cloud Community, Currently, we don't have access to data model/report for the seeded report 'Generate Audit Report' in Oracle Cloud Fusion. Business user has a requir…Tushar_Singhania 1 view 2 comments 0 points Most recent by Tushar_Singhania BI Publisher Learning Center
-
HCM Talk Radio: Localization Best Practices in HCM CloudSummary HCM Talk Radio: Localization Best Practices in HCM CloudContent Are you interested to learn more about localizations and translations in Oracle’s HCM Cloud Servi…Frank Cowell-Oracle 53 views 2 comments 0 points Most recent by Frank Cowell-Oracle Human Capital Management -
SQL Query to get Change Order TasksHi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot -
Is there a way to see what tables/views have data and which ones are empty in Oracle Fusion HCM?Summary: This is for archiving data from the production system. We are moving to SAP SuccessFactors so need to know data is stored in which tables/views. We are looking …
-
Report on Action Reasons per action and associated taskSummary: Our action reasons need to be reviewed so I would like to be able to report on the existing action reasons that are available for each action and ideally what p…
-
Need SQL Query/ table names to get termination and reverse termination details of an employeeSummary Need SQL Query/ table names to get termination and reverse termination details of an employeeContent Hi All, What I need is to get termination and reverse termin… -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing? https://us.v-c…Harish B Choctaw 44 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Can we burst multiple templates in BI Publisher?Summary Can we burst multiple templates in BI Publisher?Content Hi Team, I have a requirement where I am having two different templates based on a single data model. Eac…
-
CTE does not work for all casesI’ve received a request to create a BI Publisher report that meets the following business requirement: Given a date parameter (e.g., 31/12/2024), the report must return …
-
Create user account using rest apiDear All, I am attempting to create a worker using the REST API (/hcmRestApi/resources/11.13.18.05/workers). It automatically generates the user, but when I set the user…
-
Query to fetch HR Representative personHello All, Need to fetch data either by using BIP or OTBI, HR Representatives associated to a Person. I am able to fetch AOR's Associated to an Employee, But the require…Satish Golla 574 views 5 comments 0 points Most recent by ValentinaG-Oracle Human Capital Management
-
HCM Tables and Views MetadataSummary: Oracle has the below website with table and views metadata for HCM. How can I get this metadata as json files or another metadata format other than the browser … -
Segregating the success and error report to different email id through SOAP UI Request PayloadSummary: I did a POC , using the SOAP UI Payload request i'm able to get the email notification to multiple emails. but the expectation was like for success report we wi…Ankita Mohanty 21 views 0 comments 0 points Started by Ankita Mohanty Reporting and Analytics for HCM
-
Role Discrepancy in PER_USER_ROLES Table for Terminated EmployeesSummary: We observed that for a few terminated employees, roles appear to be assigned in the PER_USER_ROLES table when pulling through the report, even though the fronte…Pranav Kakaraparthy 51 views 3 comments 0 points Most recent by Parag Hiremath Human Capital Management
-
Need an sql query to get the latest leave approver or assignee details from transaction consoleHi Team, I am unable to get the approver or assignee details from the below tables 1. fa_fusion_soainfra.wftask 2. fnd_bpm_task_history_b So Please provide an sql query/…
-
Tasks sequence Number change in refine extract pageSummary: Hi Team, I'm currently working on the tasks under the Refine Extract page, and I am trying to update the sequence numbers. However, I’m unable to make the chang…
-
BI query to find the count of Failed, aborted and recovered transactionsWe are working on the list of Failed, Aborted and recovered Core HR transactions. We were able to get the failed and aborted transactions list with the available status …Kavya Sreenivasulu 12 views 2 comments 0 points Most recent by Kavya Sreenivasulu Human Capital Management
-
Kindly help me with SQL Query to get Hire Date of an employeeSummary: Kindly help me with SQL Query to get Hire Date of an employee If an employee has been only globally transferred, query should return enterprise hire date If an …AS 336 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
security role validationSummary: Content (please ensure you mask any confidential information): We have two instances presently test and a dev instance, the dev instance was recently refreshed.…Aishwarya_Saju 1 view 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Not able to print all clob data from BIP reportSummary: I'm creating one report for requisition and in that im fetching clob attributes and using group by function below trying to use To_char(irtl.EXTERNAL_DESC_HTML)…
-
Document of records - How to define primary attachmentSummary: Hi all, The business requirement is to attach multiple attachment to the same document of record. Only one of the attachments is considered primary by the busin…teresa.marciano 21 views 5 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
BI Publisher - Obtain YTD / accumulated payroll balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…Visvanath-Oracle 12 views 0 comments 0 points Started by Visvanath-Oracle BI Publisher Learning Center
-
Kindly help me with SQL Query to get contact (Spouse and Child) information of an employeeSummary: Kindly help me with SQL Query to get contact (Spouse and Child) information of an employee Content (please ensure you mask any confidential information): Versio…
-
How to pass Request Payload for POST Method in BIP DataModelI am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring the request payload for …
-
Query (sql) that brings the sequence logic the cost center in budget detailsQuery (sql) that brings the sequence logic the cost center in budget details How to query (sql) that brings the sequence logic of the information in this part of the cos… -
Export employee pictureSummary: Is it possible to export employee pictures in jpg/png format (not byte string)? Content (please ensure you mask any confidential information): Version (include … -
PER_EXT_SEC_PERSO_UE is returning duplicatesContent Hi All, We have an interface where we are using PER_EXT_SEC_PERSON_UE as Root data block as well as we are also using threading on this data block. We have used …
-
From which table can I obtain the name of the owner of a Succession Plan?Starting from this query, i try to obtain the name of the owner plan but without results. Can you help me with one suggestion, please? SELECT HP.PLAN_NAME, HP.PLAN_TYPE,…