BI Publisher
Discussion List
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 2K views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 43 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
E-Sign Policy documentSummary E-Sign Policy documentContent Hi All, We have a requirement to create BIP template using provided Onboarding Policy template(.RTF). In the Template we need to ad…Prabhu Krishnamoorthy 39 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, … -
Remove duplicate rows for AR BIP report to improve performanceContent I've created a query that pulls all AR transactions for a parameterized transaction date and matches our IBAN record in the customer with any IBAN found in the b… -
BIP SQL to show the Emplid, Name and Today's date of the Login userSummary BIP SQL to show the Emplid, Name and Today's date of the Login userContent I am creating template report which should automatically show Emplid and name based on…Prabhu Krishnamoorthy 89 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
per_addresses not having dataSummary per_addresses not having dataContent I don't see PER_ADDRESSES TABLE GETTING POPULATED, Instead the tables like per_addresses_f is having data but the per_addres…Prabhu Krishnamoorthy 553 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
List of Core HR Audit Tables - For Building Audit report in BIPSummary List of Core HR Audit Tables - For Building Audit report in BIPContent Can anyone provide me the List of Core HR Audit Tables - For Building Audit report in BIPPrabhu Krishnamoorthy 47 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need help in restricting infolet in Legal Employer Transfer PageContent Dear All, I have created an OTBI infolet on Legal Employer Transfer UI in Assignment section. Now this infolet is visible in all the pages where Assignment secti…User_2025-02-06-14-37-05-233 43 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
BI Publisher - tracking of an email notificationSummary Schedule Report JobContent Hi All, One of users has complained about some of their scheduled processes not sending email notification even though she filled up t…Alvaro Couto 79 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Log for emails sent through scheduled Reports jobContent Hi, We have scheduled a report job. So some are going under failed. Can i know how to fetch log daily how many reports are successfully sent and how many were fa…User_2025-02-10-17-13-07-021 40 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…User_5F4G3 543 views 10 comments 0 points Most recent by User_2025-02-11-18-46-39-346 Reporting and Analytics for ERP
-
Issue with "Workforce Management - Absence Real Time"Content Hi Team, We have designed a specific report using the OTBI "Issue with Workforce Management - Absence Real Time". This was working fine till last month and now w…Kiran Kancherla 23 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 50 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
Setups and BI format for Wire SDPSummary How to setup automated wire PPP for Wire TransferContent We currently use PPP's for ACH and Outsourced Checks. Our wires are done manually. We want to automate t… -
"Sales - CRM Sales Activity"."Business Unit"."Business Unit Name" is nullSummary I am trying to do an Activities report but the Business Unit Name field is nullContent I am using the subject area "CRM - CRM Activity Real Time" but when I adde…Edgar11 44 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to validate the flexfield of a page on another pageContent I created a flex field in the header called type: This field has 3 options I choose the type in the header and now I'm going to create items, the system opens an… -
Ho Do I Call a BI Publisher Report from a Tile on the SpringboardSummary Ho Do I Call a BI Publisher Report from a Tile on the SpringboardContent Hello, We would like to call a BI Publisher report from a tile on the springboard. Does …Daniel McMillian 37 views 8 comments 1 point Most recent by Daniel McMillian Reporting and Analytics for HCM
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 330 views 2 comments 1 point Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Getting Error "the User request exceeded the maximum query governing Execution time" while running tSummary Getting Error "the User request exceeded the maximum query governing Execution time" while running the OTBI reportContent Hi All, I have created one OTBI analysi…User_2025-02-06-15-04-02-124 100 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
OTBI report to fetch all details of Direct and Indirect reports details based on Line Manager sessioSummary OTBI report to fetch all details of Direct and Indirect reports based on Line Manager session userContent Hi All, I am trying to fetch all the (direct+indirect) …User_2025-02-06-15-04-02-124 63 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need out of box reports for Oracle recruitment(ORC)Summary Need out of box reports for Oracle recruitment(ORC)Content Hi Team, We are looking for Oracle recruitment(ORC) out of box reports. This is the new module for us …Harish Kumar Kovi 60 views 1 comment 3 points Most recent by Craig Hennessy Reporting & Analytics for Sales
-
How to display the thousands separator point in the BI extraction tables for pay elements and goalsSummary How to display the thousands separator point in the BI extraction tables for pay elements and goalsContent Hi, We are experiencing an anomalous behavior. I enter…Alberto Barile 18 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Employee Headcount by Business Unit BI Publisher reportSummary Employee Headcount by Business Unit BI Publisher reportContent Hi Experts, I'm looking BI Publisher ( not OTBI since Headcount is not properly setup in our organ…User_2025-02-07-19-03-14-525 48 views 6 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
Custom alert is not working as expectedSummary Custom alert is not working as expectedContent Hello experts, We had created a alert to be sent when learning assignment is withdrawn within 40 days from offerin… -
Need to know KFF Deployed person nameContent Hi All, We have "Deploy Flexfield" option in cost Allocation Key Flexfiled. We need to know the person name who deployed the flex field. In "FND_KF_FLEXFIELDS_VL…