BI Publisher
Discussion List
-
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 716 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… -
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…Stefan pettersson 41 views 3 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
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 143 views 3 comments 2 points Most recent by Alice Gouzy Reporting and Analytics for HCM -
expense Audit adding a dropdown list in Audit issueDear all I have a request when doing the audit of users expense and change the reimbursement amount I have to specify in the audit issue the cause there are just 2 optio… -
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l… -
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 22 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM -
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…Vipusha Chandrakumaran 537 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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 160 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Prepayment invoice detailsSummary: Prepayment invoice details Content (required): Hi experts, I got new report requirement to display prepayment invoice details based on as on date. 1. prepayment… -
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 51 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM -
HCM Extract xsl template to generate formatted XML Output that almost replicate original xml outputSummary: HCM Extract xsl template to generate formatted XML Output that almost replicate original xml output. We just need to get rid of the duplicate output that is usu… -
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 31 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 141 views 5 comments 0 points Most recent by Abhishek Bhawalkar Reporting and Analytics for HCM -
Account Receivable > Fetch "Payment Term" of a CustomerSummary: Account Receivable > Fetch "Payment Term" of a Customer Content (required): Hello All, Do you have an idea what are the physical tables to fetch the Payment Ter… -
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 41 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 99 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…