BI Publisher
Discussion List
-
Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num…Thulasi Ram 106 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
FND_SESSIONS recording delay?Summary: Is there a delay in the data recording for FND_SESSIONS Content (required): We created a report to get the user count of accesses, using FND_SESSIONS. We ran it…User_2025-02-12-18-16-11-815 31 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM -
Oracle HCM Cloud: Where can I see the seeded Packages for BIP?Summary: Does Oracle have a list of DB packages that we can use for BIP? I saw this one "pay_balance_view_pkg" but I wanted to know if Oracle have a full list of package… -
Provide Deep Link for a Performance Document inside a BI Publisher ReportSummary Refer to the direct Deep Link for Performance Document for Manager's feedbackContent Hi All, We are building a custom BI Publisher report that will generate Emai…Kalyan Amaravathi 145 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 708 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Restricting report access to read only using Application RoleHi, In HCM (Reports and Analytics), We are trying to restrict reports access to read only for particular users using Application role. For that created a new role assign… -
Custom Data Model - ProfileApprovalNotificationSummary: How to custom the seeded data model in order to add flexfields Content (required): Hi, I need to add flexfields from one Profiles section (Honor and Awards) in …Alice Gouzy 135 views 3 comments 2 points Most recent by Alice Gouzy Reporting and Analytics for HCM -
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 13 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM -
Provide Participant Feedback" link text needs to be changed in BI notification templateSummary Provide Participant Feedback" link text needs to be changed in BI notification templateContent We need to change link text in notification however unable to find… -
OTBI Agent Email From, Reply-to, CCSummary OTBI Agent Email From, Reply-to, CCContent Hi all: Using an Agent, is it possible to alter the "From" email address and add "CC" and "BCC" email addresses? The c…User_2025-02-04-23-32-05-891 144 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
BIP table for pending approval assignees?Summary: We want to be able to get the list of assignees from an approval process/transaction, before it is completed. Content (required): If an approval process is stil…User_2025-02-12-18-16-11-815 49 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM -
HCM Reporting Only Role - Both BI and OTBISummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …AshishERPCloud 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Cannot test custom notificationSummary: Content (required): Hello experts, I'm trying to test custom notification by going to Schedule. However when I go to History task, teh system return an error me…Valerio Curzi 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Image stored on Web content Server not getting displayed in the Email Output after scheduling ReportSummary: Hi, We have created a check-in on content server to store an image and we are using that link in a report. The link is working fine when tested directly. We als…Abhishek Bhawalkar 134 views 5 comments 0 points Most recent by Abhishek Bhawalkar Reporting and Analytics for HCM -
WebDAV bursting option configuration to access share pointSummary: Hello Team, I am trying to leverage WebDAV bursting option to access share point and place the files in the system. However, it is throwing error. Please share …Shiva Prasad M 43 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
BI Report on Notification Approvals StatusSummary Trying to create a BI Report on the status of Notification ApprovalsContent I've tried looking at a number of tables, firstly in OTBI, but the subject area "Huma…User_2025-02-06-00-01-08-606 100 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a … -
cmp_transactions doesn't track Override when Worksheet Overridden by Another Manager is disabledSummary: Content (required): Hello, we are configuring a custom Worksheet Overridden by Another Manager notification. When we extract user transactions on compensation p… -
XLA_TRANSACTION_ENTITIESSummary: Team, How to join XLA_TRANSACTION_ENTITIES with Payroll / Assignment Tables and Get Person Related Transactions. Any idea would be highly appreciated. Thanks in… -
Recruiting -Recruiting real time report relatedSummary: I have created two reports to fetch candidate details using Recruiting -Recruiting real time . I am getting duplicate data how I can restrict it , Also in one o…Rajib_Samanta 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to link Allocated tasks with questionnairesSummary: hello everyone, In order to create a report on the offboarding /exit interviews i need to link the allocated tasks with the questionnaires to get the allocated …Ayoub AFRASS 71 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
User Login report.Summary: Looking for report which provides number of user login into Oracle HCM Content (required): Version (include the version you are using, if applicable): Code Snip…Prabhu Krishnamoorthy 403 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
W_2 document delivery preference reportSummary W_2 document delivery preference reportContent Hi All, Recently we enabled W_2 consent functionality enabled. Is there any seeded report to get the details that …Peoplesoft 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to see how many API's are being called in an environment?Summary: Is there a way to see how many API's are being called in an environment? Content (required): Looking for a report or somewhere in the UI where we could see the … -
BIP: How to create 'Year' parameter?We have a requirement to provide Year parameter as a dropdown in BIP report. It should default to current year, and allow users to select any other year from the drop do…Anshul Rai 66 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to avoid overlap labels in BI Pie chart?Summary: Our customer is using HCM cloud and developed some dashboards and it has some pie chart and labels are overlapping each as shown in the attachment. How to fix t…Peoplesoft 55 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tables in BIPSummary: Hello does anyone know the table where I can get these? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…Hazel De Castro 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Learning Evaluations ReportSummary Genarating a report with Learning Assessment and evaluationContent Hello Team, I need a bi report for learning assessment and evaluations. I am done with the ass…Aditya Srivastava-Oracle 226 views 2 comments 2 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Report on Absence AttachmentSummary: Report on Absence Attachment. Is it possible to create a Report which will say who has attachment on Absence Content (required): Hi Experts, Is it possible to d… -
Accessing the content server data in BIPContent Is there a way by which we can access the content server data in BIP data model. We want to place certain number of person id in a csv file in content server and…