Data Models
Discussion List
-
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dynamically parameterized OTBI for journeysSummary: Content (please ensure you mask any confidential information): Hello everyone, We have created an OTBI report on the subject area "Workforce Management - Checkl…
-
Is it possible to use different BI templates for different Legal Employers in one report?Summary: Is it possible to use different BI templates for different Legal Employers in one report? Content (please ensure you mask any confidential information): Is it p… -
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
The custom dashboard in the UI of the DEV environment is redirecting to the PROD dashboard.Summary: When I try to open the custom dashboard located in My Client Groups in Dev it is redirecting in Prod Custom Dashboard Content (please ensure you mask any confid…
-
SQL query for absenceSummary: Hi, I have to create a query with 2 types of abcence. The data model is ready but i have to show each absence day in the seperate row,example: E123123 2023-10-2…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and…Pedro Teixeira 171 views 0 comments 2 points Most recent by Pedro Teixeira BI Publisher Learning Center -
Data Removal - How to treat records with Work Relationships in multiple countriesSummary: Hi all So we have been configuring a process to remove data with the Person Removal Tool. This works amazing for those who have one or more Work Relationships w…
-
Document of Records Letter Generation Does Not Have Proper Values or Has No DataSummary: The issue can be reproduced at will with the following steps: 1. Employee adds a document record by navigating to Me > Document Records 2. Select Document Type … -
How to add logo inside approval notifySummary: Content (please ensure you mask any confidential information): Hi everyone, We are customizing the approval notifications that reach a customer's employees to a…
-
We need a value set through which we can auto generate the incident numbers.Summary: We are looking to setup a value set through which we can auto generate incident numbers where incident number is a DFF on DOR. We are trying to create a Value s…Pravesh Jain 61 views 6 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Can we rename notification button.Summary: Hi Expert. Good day! Just wanted to know can we rename the "Reject button" Example - for inida Legal entity it should (Revoke) and for US legal entity it should…
-
which table has VISA Comments and Notes?i need to create a BIP report including Visa information. But i can't find the right table for VISA Comments and Notes. Does anyone know about it please?
-
Mass Update ChangesSummary: Content (please ensure you mask any confidential information): Hi everyone, We are configuring the actions and fields relating to the Mass Update action made av…
-
In which table is the Document of Record attachments stored?Summary: In which table is the Document of Record attachments stored? Content (please ensure you mask any confidential information): In which table is the Document of Re…
-
-
-
HDL Template to convert Non Worker work relationship to Contingent WorkerSummary: Hi All, Can someone please provide the SQL query and HDL template for the below requirement. 1. We need to update the "System person type" from "Non worker" to … -
Is there a way to update HZ_PHONE_COUNTRY_CODES in UI?Summary: Is there a way to update HZ_PHONE_COUNTRY_CODES in UI? Content (required): Hi community, There is a Kosovo country code missing. So I am curious if there is a w… -
Address fields Unique Identifier required for PolandSummary: We require the Unique Identifier for each of the address fields, like code for Address Line 1, Address Line 2 etc and also the Unique Identifier for the values … -
Regex to extract text from html documentSummary: I need a regular expression to extract words from a html document (or any document which comprises of tags). Content (required): For example, given the followin…
-
adding data access by roleSummary: Added a data privilege to a security current custom role but need data access to go with that Content (required): we added a data privilege to a security role t…Bernadette Dorris 21 views 2 comments 0 points Most recent by Bernadette Dorris Human Capital Management
-
How to remove ORA_BIP_APPROVE_START, ORA_BIP_APPROVE_END displaying on NotificationSummary: Resignation Custom/Configurable Notification - How to remove ORA_BIP_APPROVE_START, ORA_BIP_APPROVE_END and ORA_BIP_SUBMIT_START not to display on notification(…
-
Change Full Name format in Performance Document to Preferred Name or Display NameSummary: Is there another way to change the Full Name format in printable Performance Documents? I attempted to configure the data model for the predefined report, but i…
-
How to remove the document link from the Notification pages?Summary: How to remove the document link from the Notification pages of Document Records? Content (required): Hi, we have a requirement that on the FYI notification page…PavanDuvuri 41 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Human Capital Management
-
Where are absence statuses stored in the tables?We are wanting to add the status of Absences to our reports but we are having difficulty locating them. We have found ANC_PER_ABS_ENTRIES to view absence statuses and Ap… -
Missing create Data model option under Published Reporting?Summary: Missing create Data model option under Published Reporting? Content (required): Missing create Data model option under Published Reporting? Let me know if any r…
-
How to get the original termination date when person is global transferred in fast formula?Summary: Employee joined organization on Jan 2015 and worked till Nov 2020. Later, he got global transferred on 1st Dec 2020. Need to write fast formula to get his termi…
-
Who has implemented Oracle HCM Cloud and Oracle ERP Cloud on different production instances?Summary: Who has implemented Oracle HCM Cloud and Oracle ERP Cloud on different production instances? Content (required): We would like to discuss the pros/cons and 'les…Santo Campione 41 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Human Capital Management
-
Need unsecured tables/views for PII related data for open ended reports.Summary: Need unsecured tables/views for PII related data for open ended reports. Content (required): Hi Team, We need to understand how can we have these PII tables(or …