Data Models
Discussion List
-
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI? -
A scheduled BI report has been failed in one of it's scheduled runA scheduled BI report has been failed in one of it's scheduled run with below error: Waiting Time: 4.7 seconds Data Fetch Time: 0.4 seconds Total Execution Time: 1.8 min…Ritika.ray-Oracle 11 views 4 comments 0 points Most recent by Ritika.ray-Oracle Human Capital Management -
Which BI Template does the New Hire FYI notification use?Summary: We have added 2 fields to the New Hire notification (Business Title and Position). The fields were already in the data model to add to the RTF template. The "Ap…
-
Ability To Create Alert for Custom Visas and PermitsSummary: Ability To Create Alert for Custom Visas and Permits Content (required): Hello All, Is it possible to create an alert in HCM for custom permit such as Residency…
-
Edit time-out in Administration-> Runtime ConfigurationSummary: Hi Everyone, I'm trying to increase time-out for query and report but unable to edit the query time out in administrator Administration-> Manage Publisher-> Run…Hrushikesh Pentewad 21 views 2 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
Query to get the Highest level(One below CEO) of Manager for an employeeSummary Query to get the Highest level(One below CEO) of Manager for an employeeContent Hi Team We have our requirement where we need to fetch the highest level of Manag…
-
Can we apply passwords to Excel templates (.xls format) BIP reportsSummary: 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 calculate two dff date values in 3rd dff valueSummary How to calculate two dff date values in 3rd dff valueContent Hi, I am having two Dffs showing start date and end dates. I want to calculate the duration between …User_2025-02-04-15-20-16-786 100 views 5 comments 0 points Most recent by arwa Alsuliman-Oracle Human Capital Management -
How to remove buttons on approval notificationsSummary How to remove buttons on BPM approval notificationsContent We have requirement to remove buttons on BPM approval notification for security reasons. Kindly share … -
Add Pending Worker workflow notification subject not showing proposed start dateSummary Add Pending Worker workflow notification subject not showing proposed start dateContent Hi, Add Pending Worker workflow notification subject not showing proposed… -
OTBI - separate value into two columnsSummary: OTBI - separate value into two columns Content (please ensure you mask any confidential information): I am creating an OTBI analysis report and I want to separa…Nick Henderson 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Is There an way to Default BI report Text parameter to logged in user person id like in Date typeIs There an way to Default BI report parameter to logged in user person id like we default System data in Date type parameter {$SYSDATE()$}. We have a Text parameter whi…
-
Document of Records - Attachment is not updated when we are trying to correct/update the data.Summary: we have created a custom report for Document of records and given the path at Document Types. But when we are trying to correct/update the data of existed trans…
-
How to find redline change data in the OBI tablesHi Experts/Team, Is there any OBI table that stores if any attribute is redlined on a change order, redline information i'm looking for a specific attribute is redlined …Manohar Reddy2 21 views 0 comments 0 points Most recent by Manohar Reddy2 BI Publisher Learning Center
-
Third employment relationshipHello everyone, Our client wishes to manage scenarios involving employees with three employment relationships across three different companies. What action can be utiliz…
-
Payload file for Create Time Entries for Project and Task through REST APISummary: Need help on json payload file for Time Entries REST API in link (https://docs.oracle.com/en/cloud/saas/human-resources/24b/farws/Creating_Time_Entries.html for… -
Oracle HCM: How to add Prior Individual compensation details to Compensation workflow notificationsHi All, we have a requirement to add Prior compensation details to the existing Compensation workflow notifications. Can you please let us know how to achieve this Thank…
-
HDL Error on Assignment loadSummary: We are trying to perform a load to remove Position Value from Assignment & are running into an Issue with HDL for a subset of our Employees. HDL Error says: "Th…
-
Customer's infosec team wants to review how information is stored in cloudSummary: Customer's infosec team wants to review how information is stored in cloud (data on rest and flow covering end to end architecture). Request for sharing resourc…Maithraye Kambam-Oracle 21 views 2 comments 0 points Most recent by Maithraye Kambam-Oracle Fusion Applications Administration
-
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor… -
HCM Production data needs to be masked conditionallyRather than the non-production environment (we know that sensitive data can be masked in non-prod during P2T), we need to conditionally mask production data such as sala… -
sql query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date)Summary: Hi Folks, Do you have query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date when Standard Hrs is >=20) Thanks
-
Users Transaction DetailsHi Team, Greetings!! We are looking to get Users Transactional Data (When the user account got inactive or locked, Error message if user trying to login), time the appli…Anand-ST-Oracle 41 views 2 comments 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileSummary How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileContent Hi Experts, Can anyone please help me as to how to displ… -
List of Values SQL query with multiple columnsHello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End…
-
HDL Error in Termination CWK and creating NonworkerSummary: We are facing HDL error while Termination of CWK with Multiple lines and creating Nonworker. Below is the error message Error : You must provide New Start-Date …
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
query to get the due date in payment under invoices to payHi, Could you please advise in which SQL table can I find the Due Date in Payables → Payments → Create Payment under Invoices to Pay. Thank you.Elyse Meouchi 1.4K views 2 comments 0 points Most recent by Stephen Westerfield-Oracle BI Publisher Learning Center
-
How to retrieve bank account details on report with correct party ID?Hello, We have run the attached SQL query. However, we have noticed that for one employee, we were not able to retrieve the bank details as shown below: Currently on the…VDoolhur 815 views 5 comments 0 points Most recent by Stephen Westerfield-Oracle Human Capital Management
-
how to Retrieve the GUID of a row (global unique identifier ) using SQL ,not RESTsome apis require the GUID to update a record , not the id or rowid We can retrieve that value using REST api (/fscmRestApi/resources/11.13.18.05/invoices/1/child/invoic…