Data Models
Discussion List
-
How to keep rich text format bip report in Excel output.We are using rich text format for Questionnaire answer format. can we possible to fetch below like links & Bold format in excel output. -
General Letters for Document Record is not getting proper values in Draft file.Summary: Unable to get the values in the template in Draft version and final version(after approval created a auto generated file) Content (required): I have created a D…Ritu Surve 111 views 8 comments 0 points Most recent by Pavan Kumar Thummalapalli Human Capital Management
-
Need to extract clob field has html dataSummary: Hi Team, We need to extract the clob file that contains the HTML data. I wanted to know if the clob file could be extracted in the same way as the front end. Th…
-
how to delete bulk rows in User-Defined TableThere are 50+ records in the user defined table Column, Column can not be deleted when it has child rows. Without deleting the rows manually, Is there anyway which can b…Sugenthiran Dinesh 135 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management
-
Is there any way to store Signature image other than RTF template to use dynamically in lettersSummary: We have used Signatory using RTF templates where we are facing issue as it was dynamic for every update in signatory we need to change the signature more freque…RamyaK 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Organisation Structure Oddity (HR Reports)Afternoon folks, I have a weird one for you today. One of our HR Systems Advisors has encountered a bizarre malfunction in our data pull back. They (and one other) are c…
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d… -
How to call one particular data model query into another report's Data Model without repeat query.We had a requirement that I have to use the query written in report-1 in report -2 without writing the whole query. I just want to refer that report-1 query and will bui…Nalsoft Pvt Ltd 11 views 0 comments 0 points Started by Nalsoft Pvt Ltd BI Publisher Learning Center
-
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… -
Get Business Unit Name using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
Reporting on Workflow NotificationsSummary Want to be able to report on the number of open workflow notifications a user hasContent Is there a way of reporting on the number of workflow notifications a us…User_2025-01-30-04-35-17-090 134 views 4 comments 2 points Most recent by SERGIO BARRETO Human Capital Management -
ORA-01719: outer join operator ( ) not allowed in operand of OR or IN errorSummary: Content (please ensure you mask any confidential information): We are unable to see any information in the change address notification upoon debugging further w… -
What does the asterisks in table comments mean?Hi all When reading the table definitions, for example here: https://docs.oracle.com/en/cloud/saas/project-management/25a/oedpp/pjcexpitemsall-24862.html#Details there i…Anders W. Langholm 1 view 0 comments 0 points Started by Anders W. Langholm BI Publisher Learning Center
-
Delegation Notification Displays Incorrect Dates in HCMContent: The notification should accurately reflect the dates entered in the system, but it incorrectly displays one day less than the actual registered date. This discr… -
How to call a web service in BIP SQL queryI have implemented a web service call in Oracle Fusion. Is there any way we can invoke the web service within an SQL data model in BIP
-
Can we change the Start of the employee Contact ?Summary: Hi Team, Will it possible to change the Start date of the employee Contact by using HDL or HSDL or from front end which is storing in the per_all_people_f table…Sai Jahanavi Metta 11 views 1 comment 0 points Most recent by Mandavi Shrivastava-Oracle Human Capital Management
-
Display of Dashboard is not good in IphoneSummary: I have developed a dashboard the display of it is same in desktop and in android phones. I have arranged 2 columns side by side. Below these 2 columns I have an…Nazera Shabnam. 1 view 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Is there a way to delete the previous selected valued from the flex field.Summary: I would like the system to delete values from the DEI fields when a user changes their consent value from YES to No or Yes to Blank it is preferred that the del…Britika Kumari 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Requirement for Capturing User Details on Candidate Profile Label CreationSummary: Business requirement regarding the tracking of user activities on candidate profiles. Specifically, we need to capture the following details when a user creates…Nachiketa Das 31 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Recruiting, Opportunity Marketplace
-
a way to add additional person numbers to PER_EXT_SEC_PERSON_UE filter AND w/ SQLSummary: Hi forum: Cannnot remember SQL syntax to APPEND additional person numbers to PER_EXT_SEC_PERSON_UE filter without using 'IN' clause so extract XML file breaks o…
-
How to add an attachment in a BIP NotificationSummary: How to add an attachment in a BIP Notification Content (please ensure you mask any confidential information): Hi, we created a BIP Notification. We created the …Barile Alberto 51 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Is it possible to add an LOV behind the Value field on a Value Set?Summary: Hi Community, Our customer is looking forward to create a table of important setup for them inside a value set. This table stores specific codes for cities and …Pilar F. 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Is it possible to setup Unique Key's for DFF inside a Value Set?Summary: Hi Community, Our customer is looking forward to create a table of important setup for them inside a value set. This table stores specific codes for cities and …Pilar F. 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
How to send data from one dataset to another dataset?Hello guys, I have created one data model in which two datasets are there. is there any way to get data from one dataset to another dataset in bi publisher? for eg. I ha…Parthiv_Patel 223 views 3 comments 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
With Root = Person DG or Assign DG to get Comp DG ( to get Comp DBIs from PER_EXT_CMP_FEED_PLAN_UE)Summary: Hi forum Looking to pull these DBI attributes into /add to HCM Extract where root DG = 'PER_EXT_SEC_PERSON_UE' Or Assignment DG 'PER_EXT_SEC_ASSIGNMENT_UE' belo…
-
BIP report to fetch department changes record for employeeRequirement to fetch all the records where department attribute is being changed irrespective of action and action reason for an employee. For this we are comparing prev…
-
HCM Extract - Need help to get 'Previous' Job code / Job name SQL for VS/FFSummary: Hi I need to add these 2 columns in an HCM Extract (Assignment DG) that is sub to Person DG, Work Relationships, Work Terms hierarchy above Assignment DG Lookin…
-
to retrieve transaction details and log details for Error/Warning Messages appearing on Oracle UISummary: When business process change transactions are submitted with missing or incorrect information or for validation oracle displays the standard oracle error or war…sonawaav 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
For ICP failed transactions not able to get the plan name from the report diagnostic and by running.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 24D (11.13.24.10.0) Code Snippet (add…
-
I am attempting to End Date some Recurring Element Entries and need to find the Source System IDSummary: We are updating a number of Element Entry's for employees with updated information. I am attempting to do so through an HDL but have been receiving the error "T…