Data Models
Discussion List
-
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 31 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 33 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 …
-
Preferred nameSummary Preferred nameContent Most employees with a preferred name would want their preferred name shown and keep their legal first name private if possible. Can the sys…User_2025-01-28-07-47-26-775 397 views 15 comments 0 points Most recent by Shivani S2608 Human Capital Management -
We want to add new primary location under create job requisition which is not available in the listSummary: We want to add new primary location under create job requisition which is not available in the list Content (required): Version (include the version you are usi…
-
Can't access to his teamSummary: When a line manager tries to access screen "My team" and select one of them this error happens Content (required): Version (include the version you are using, i…
-
How to get module column (Finance or SCM) based on the users in user detail reportSummary: Content (required): Hi , I would like to get some query or sample reports to develop a custom user module report as this report is very important for business. …
-
How do we get length of service from backendContent Hi All, How can we get the Length of Service based on any specific date from backend. When we navigate seniority date screen (V3), seniority date is always calcu… -
SQL to extract GeographiesHi! Can someone share an SQL code to extract geographies? We want specifically to extract the values of Postal Code and Cities from Belgium. Kind regards, Pilar Version … -
SQL to extract list of all jobs currently runningSummary: SQL to extract list of all jobs currently running Content (required): Can anyone share the SQL to extract list of all ESS jobs currently running in the applicat…
-
RequestPositionChange notification is picking seeded report template instead of customized templateSummary: Content (required): We have customized the template and data model for UpdatePositionReport by following the steps from Oracle. However, we can see the notifica…Riya_Maithani-Oracle 123 views 18 comments 0 points Most recent by Priyanka Manuja Human Capital Management
-
Can we modify the warning message which generate through grade rate when we enter salary outofrange?Summary: Can we modify the yellow highlighted warning message in the below screenshot? Content (required): Version (include the version you are using, if applicable): Co…
-
Alert composer: Retrieving data for next 3 months from current date is not workingSummary: Hello we have a requirement to trigger a probation alert 3 months prior before the end date. We have created a sql query to test the data first before we move t…Tanusha_Ragooah 51 views 2 comments 0 points Most recent by Tanusha_Ragooah Human Capital Management
-
Calculate hire dateSummary: Calculate the hire date considering rehire within 3 months Content (required): Hi All, We need to calculate the hire date and years of experience in a report ba…Gayathri K M-Oracle 42 views 2 comments 0 points Most recent by Gayathri K M-Oracle Human Capital Management
-
How to get a workflow list that has SOA problem?Summary: Situation: The system sent an email on 04/06/2023 with information about the employee's dismissal, but this employee was dismissed on 11/16/21 in POD. We would …Maria Luiza Siqueira 42 views 4 comments 0 points Most recent by Maria Luiza Siqueira Human Capital Management -
Hi.. Can we generate XML output file using BIP Report and send it over FTP?Summary: I have a requirement to generate BIP report which output file format should be XML. From Data model we can manually get XML file with 200 rows at max. But I don…Mallikharjun Purilla-Oracle 130 views 6 comments 0 points Most recent by MandeepGupta Human Capital Management
-
Build report from HRC_TXN_HEADER and HRC_TXN_DATA that are truncated during P2T refreshSummary: As per Document 2929464.1 (oracle.com) HRC_TXN_HEADER and HRC_TXN_DATA that are truncated during P2T refresh, so the tables are having 0 rows. Any idea how to c…
-
System TIMESTAMP as a default value in BI report parameterHi, Is there any possibility to pass System TIMESTAMP as a default value in BI Report Parameter instead of Complete DATETIME. Thanks,
-
Is there a Table Mapping between EBS R12 and FusionSummary Is there a Table Mapping between EBS R12 and FusionContent Is there a Table Mapping between EBS R12 and Fusion for example MTL_SYSTEM_ITEMS_B--> EGP_SYSTEM_ITEMSAshish Vishwakarma-50607 452 views 4 comments 0 points Most recent by Nagendrababu Kanuru Human Capital Management -
BIP report chart shows months in alphabetical order, and not in sequence of monthsSummary: Content (required): This is the screenshot where I have to add '01-JAN' , '02-FEB' i.e. numbers in front of months to show it in sequence, otherwise it either s…Riya_Maithani-Oracle 31 views 0 comments 0 points Started by Riya_Maithani-Oracle Human Capital Management
-
EL Expression: Employee should be able to Edit even if they have Manager RoleSummary: We need to accommodate a requirement in Personal Details > Family and Emergency Contacts Page wherein in ESS, all employees should be able to edit while in MSS …Bianca Lei Villareal 43 views 2 comments 0 points Most recent by Bianca Lei Villareal Human Capital Management -
How to migrate my configuration from test environment to prod environment without copy data baseSummary: Hi dear community! i'm about to ending up my sets up from my test environment and i wonder how can i migrate these config to prod environment without using copy…
-
Query regarding worker numberSummary Query regarding worker numberContent If we set a worker number method as automatic and to start from certain sequence let say 100 and later I want to upload work…
-
Issue custom criteria in the person security profileContent Hello Everyone, I have created the following SQL query to be entered into custom criteria (person security profile). &TABLE_ALIAS.PERSON_ID IN (select distinct p…User_2025-02-07-06-30-13-200 202 views 3 comments 0 points Most recent by Jared Lonsbury Human Capital Management