Category 81
Discussion List
-
SQL How to get point information for questions at manage activities -> (i) information -> ViewSQL How to get point information for questions at manage activities -> (i) information -> View Content (please ensure you mask any confidential information): Version (in… -
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…luke.syv8 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
url enrollement link otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to retrieve data from excel dataset into Fast formula?Summary: How to retrieve data from excel dataset into Fast formula? Content (please ensure you mask any confidential information): I have this data model with excel base…
-
Unable to add table or link to a oracle analytics deliversWe have the next análisis with the next details: this is the text in the notificatión: [u] Hola, @2 [/u][br/] Recuerda que debes registrar tus vacaciones en la plataform…
-
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 33 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
I am unable to find out the table which stored the frequency of the workflow remindersI am unable to find out the table which stored the frequency of the workflow reminders in oracle hcm fusion.Kindly let me know if any one is aware of the sameUser_NQOB7 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Oracle HCM Fusion Cloud - Data Retention and Back-up on License Contract expirationOur Oracle HCM Fusion Cloud License is about to expire ; we have decided to move to an alternative HCM Solution Provider; could someone please guide on the documentation…ARUNGTA 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Mail notification sending limitSummary: Hi Experts, Using Oracle Fusion HCM Cloud, is there a limit on the maximum number of people a BIP report can be sent using bursting? Regards, Sumit Upadhyaya Co…Sumit Upadhyaya 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Flow Ess job definition running long time.Hi, We have created a flow which will execute HCM Extract, While we ran the Flow it taking too long time, but separately if I run that Extract it is completing with in s…Kiran Kollamsetti 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Dynamic Fields Not Fetching in Journeys Report for Tuition Reimbursement TaskDear Oracle Community, I'm seeking assistance with a report issue I'm encountering in the Core HR module. I've created a report and linked it with a data model for the "…
-
Is there any report code for identifying special characters within a field?Summary: Currently some of our addresses contain commas or other special characters. Is there a way to identify these records within OTBI? Content (required): Address Li…Mark Stoker 22 views 3 comments 0 points Most recent by Robert-Jan H. 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 111 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Formula to pull two months data for automated reportSummary: OTBI Formula to pull two months data for automated report Content (required): Hi we have a task to automate the report which pulls termination for the current a… -
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
-
Unable to test Connection while using SFTP serverSummary: Hi Team, While is try to add a new connection with SFTP server, by giving all host, port , username and pwd and try to establish connection , it is getting fail…Dhilipkumaar-Oracle 51 views 2 comments 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for HCM -
How to retrieve audit reporting details concerning attachments like f.ex. Document of RecordsHi, Our client would like to have an Audit Report that generates the creation, update or deletion info of a Document of Record (with related user data of course; resp. w…
-
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…NusratB 31 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Worker Data Load (HDL) TIPS requiredSummary: Need a checklist while loading Worker data Content (please ensure you mask any confidential information): Hello Everyone, I'm new to loading HCM data, including…Lucky Sharma 23 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL) -
I am looking for the field.Summary: Hi, I am looking for the column/field of "Does not meet the required criteria for the role" in ORC. Content (please ensure you mask any confidential information…Robb 61 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to get Requisition Template name in ORCHi, I have requirement to get Requisition Template name from Basic Information. navigation --> My Client Group - Hiring - Requisition (number) - Details - Basic Informat…Rajdeep Chavda 242 views 10 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
Analysis of employees assigned performance goals and not assigned performance goals for a goal plan?I have created an analysis using the Workforce Goals - Goals Status Overview Real Time subject area. I have selected the following subject areas and applied filters (scr…Adrian Clarke 53 views 2 comments 0 points Most recent by Adrian Clarke Reporting and Analytics for HCM -
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
-
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 91 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM
-
Running an AOR report that includes who is assigned to the AORSummary: Is there a way to run an AOR report of who is assigned to each AOR and include whether the assignee is included or excluded from contacts. Content (please ensur…Angelique Cole 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 23 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM
-
Protecting Sensitive Data in Custom ReportsWhat is the most effective way to provide managers with access to custom reports without exposing sensitive employee data, such as ethnicity, date of birth, home address…Rashi_Churiwala 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle 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
-
Public Holiday Report in BI PublisherSummary: Anyone has a sample SQL Code for the Public Holiday Report using BIP? I am currently having trouble connecting the PER_CALENDAR_EVENTS_VL to Node IDs to get the…User_2025-02-04-07-19-57-588 61 views 3 comments 0 points Most recent by Robert A Reporting and Analytics for HCM