Data Models
Discussion List
-
Report related detailsHello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report Name, Fol… -
Extensible Flexfields not auto populating on basis of SQl QueryHi There, I am trying to auto populate Extensible Flexfields through sql. This sql contains recent action code transaction and shows its Effective Start date. In order t…Aviral Tripathi 101 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
we want to mask all NID Details how to do this anyone have any idea on thisSummary: we want to mask all NID Details how to do this anyone have any idea on this Content (please ensure you mask any confidential information): Version (include the …
-
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sqlSravan Kumar Meka 1 view 0 comments 0 points Started by Sravan Kumar Meka BI Publisher Learning Center
-
Create a Department Hierarchy - Organizational Tree or Department Tree?Summary Create a Department Hierarchy in Oracle HCMContent Hello everyone, Currently we are using the Organizational Tree area of Oracle HCM to drive security, meaning t… -
Mapping of Seniority dates after V3 Seniorty Dates migrationSummary: We are using PER_PERIODS_OF_SERVICE table's - ORIGINAL_DATE_OF_HIRE( as Enterprise Seniority Date) & ADJUSTED_SVC_DATE (as Legal Entity Seniority Date). After V…User_2025-07-18-06-45-42-477 152 views 3 comments 0 points Most recent by Nidhi515 Human Capital Management
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …Thulasi Ram 131 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center -
Table to get all the historical changes done in an employee recordSummary: We want to get all the changes done in an employee record. Could any one help us in getting the right table to fetch all the historical changes done till date i…
-
User Category Notifications - email to HR RepresentativeSummary: User Category Notifications. Is it possible to send an email to the HR Representative once an user account has been created for an employee? It seems like there…Consultant Ian 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management -
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
BI Report Logo not displaying when exporting report to MS WordSummary: BI Report Logo not displaying when exporting report to MS Word. Content (please ensure you mask any confidential information): I have created a BI report. I use…IanDeKoker 51 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM -
how to get the communication methodsSummary: 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 change application logo dynamically based on LE mapped to the user who login the application?Summary: Customer has logo for each of the legal entity and have requirement to change application logo dynamically based on LE mapped to the user who login the applicat…
-
unable to change incorrect date of birth and Hire date of few employeesSummary: For few employees the date of birth needs to be changed, when i try it through the application or HDL, it shows the error "You need to enter a date of birth tha… -
Change Salary/Admin Salary Transactions fail with BPM rule or approval issueSummary: we have noticed an issue with Change Salary/Admin Salary Transactions fail due to BPM rule or approval workflow is not triggering and failes Transaction. up on …
-
Dashboard data time to fillSummary: Hello Everyone I have issues with the dashboard data we have a total of 11 offer "time to fill", but when we filter with 2024 it shows only 2 offer letters. Can…Krishna Sigilipalli 21 views 2 comments 0 points Most recent by Krishna Sigilipalli Recruiting, Opportunity Marketplace
-
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the…
-
HCM Extract Completed with Alerts StatusSummary: Production Issue : We scheduled one of HCM Extract, which is completed with alerts error status. The generated log is showing FUNCTIONAL_ERROR at post processin… -
How to get the Work Terms Number for an assignment?Summary I am trying to use HSDL for correcting assignment information for some employees which requires the Work Terms Number and i am unable to find it outContent I am …Srikanth Ramaraju 7.3K views 9 comments 2 points Most recent by Parag Hiremath Human Capital Management
-
Can I retain reports or reports data when a module is retired?Summary: Can I retain reports or reports data when a module is retired? We have a requirement to access OTBI reports after a module is retired. Can we capture this in OC…
-
Offering Start DateSummary: How to get Offering Start Date in HCM Query? Content (please ensure you mask any confidential information): I have a report in development and we are missing of… -
24A BIP report performance issueSummary: We have created 2 reports (w4Federal and ADP Reconciliation) and this two reports completed with in 5 min before 24A patch. Now these reports taking more that 2…
-
Projected Start Date SQLSummary: I am looking to create a configurable form DFF field that pulls in a constant SQL for a worker's projected start date (specifically to use on a Journeys task). …
-
How to read content of the DOR attahmentContent (required): Hi, How can we read the content from DOR attachment? We would like to get the content of DOR attachment in report. below query gives me UCM id and fi… -
How to customize resignation email notificationSummary: We want to customize resignation email notification based on status of resignation. If Employee has submitted resignation, manager should get email notification…Arpit Dhalawat 262 views 1 comment 0 points Most recent by Cristina Greyling - Oracle-Oracle Human Capital Management
-
Need Oracle BI accountHi Team, We have registered as a Oracle Partner. We need Oracle BI reports account for creating and accessing data in it. Please provide us access to the account. Thanks…
-
HCM Extract attribute back end QueryHi All, We need your help in finding out the Actual query being used in the back end of Attribute in HCM Extract. We built a HCM Extract with data group using the user e…
-
query for receivables receiptsI wrote the query of receipts, but I need the receipt date, I think it's in the table AR_CASH_RECEIPT_ALL but I don't know how to join with the others. Can anyone help m…
-
Employee is unable to complete e-signature task of a checklistSummary: Content (please ensure you mask any confidential information): We have configured a checklist with a e-signature task within it. We have configured a report to … -
PROPOSED PERSON TYPESummary: Hi Team, Does anyone know what table can I get the value for Proposed Person Type? Thanks Content (please ensure you mask any confidential information): Version…