Data Models
Discussion List
-
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 392 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 11 views 0 comments 0 points Most recent 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,…
-
How to update a DFF field from a BI publisher report?We need to modify Generate Extensible Work Order Traveler Report and accommodate a print counter, last print date, last printed by at the top of the report. The purpose … -
DoR Approval Notification: ‘Date/Time’ Flexfield Displayed in UTC Time instead of Iraq Time (UTC3)Summary: Document of Record Approval Notification : Flexfield of Data Type ‘Date/Time’ Displayed in UTC Time Zone instead of Iraq Time Zone (UTC+3) Content (please ensur…
-
SQL Sample Query for Native Electronic SignatureI am looking for help on modifying the SQL query I'm using in a data model for the native electronic signature task type. I'm looking to add a parameter for job title an…
-
How to create a document of record from a BI report and add it to employeeSummary: we have a bussiness usecase to add service certificate as document of record in the employee document of records. We already have a BI report which is sending s… -
Can you please provide the HCM extract UE to use for fetching element entry with costingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a table where I can find the name of a deleted Document of Record attachment?Summary: Hi. I'm trying to create a custom audit report that lists any attachments that have been deleted from a Document of Record type. I can't seem to find any table …
-
What are these apps and what is the use of itApps Available Under Others Tab What are these apps : Resource Directory and My Dashboard What roles have access to them?Mohammed Khair 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Is it possible to add the Parent Position Code Field to the Workflow Notification/Approval window?Summary: Is it possible to add the Parent Position Code Field to the Workflow Notification/Approval window that is generated from the delivered Workflow Notification Dat…
-
need HDL to load workday definitionSummary: after clicking on working hours(i have marked as yellow) this assignment hour details comes, for that we want HDL to load workday definition is there any templa…
-
Displaying Data from Multiple Datasets in BI Publisher RTF Template with Hyperlink SupportWe have a business requirement to include hyperlinks in the output of an Oracle Fusion BI Publisher report, enabling users to directly navigate to specific application p…Tauseef-Oracle 56 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
BPM Worklist Transaction Report based on BPM worklist transaction statusHi, We are building a report to pull the list of transaction from BPM Worklist including Transaction information, Person information, assignment information along with a…Haryi 72 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
To track HCM Key Configuration changesSummary: Hi , Looking for ways to capture HCM key configuration changes like setup data , what configuration changes are made , the user who made the changes and all. We…Phani S-Oracle 22 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Human Capital Management
-
Report organizational chart - as ConnexionsHello, I would like to get or create an export that would reflect my organization chart (as an extract of Connexions). Ex : Manager level TOP Manager level -1 Manager le…Jacqueline GRANDIN 1 view 2 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
How event changes being tracked in HCM cloud HRC_EVT_OBJ_CHANGES table?Summary How event changes being tracked in HCM cloud HRC_EVT_OBJ_CHANGES table?Content Hi Team, Am trying to understand how an event change is being tracked in Oracle HC…
-
Query/SQL for datamodel in BI Publisher of Other Addresses in Location PageSummary: Hi, Do you know via datamodel/BI Publisher in what table other addresses for locations are stored? We do not find them either in: HR_LOCATIONS_ALL_F_VL or per_l…Pilar F. 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management -
globalReportDataset driven HCM Extract is not producing outputSummary: Hi Experts: My hr_archive HCM extract (using a dummy Root DG) is not producing XML output. The Report is using globalReportsDataset - > actionID > GradeRates DM…
-
i want to restrict future termination record in HCM Extract im using per_ext_pay_empployee_ueSummary: actually i'm using per_Ext_pay_employee_ue UE and i want to restrict all future termination and all assignment updated record in future dated record that one al…
-
How to remove new Line from a clob column?Hello experts, I am trying to write a report which includes a CLOB column. But in the table there's blank line in every row, and getting an issue in excel output where t…
-
Person Name Style for Germany: need to use Birth Name fieldSummary: We have a requirement for Germany to user "Birth Name" or Nam_Information3. Why can't we use this field in Person Name Styles? This field has been part of Germa…Bianca Lei Villareal 51 views 3 comments 0 points Most recent by User796018-Oracle Human Capital Management