BI Publisher
Discussion List
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH … -
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.2K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP -
Asset Source Lines TablesContent Hi All, What are the tables associated with Asset Source Lines? I'd assume a PK of Source_Line_ID / Addition Identifier, but am mostly looking for the data links…
-
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj…Pedro Teixeira 25 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How many columns can report based on Excel Template have?Summary How many columns can report based on Excel Template have?Content Hello. I am busy creating a data migration extract (BI Report) that contains a lot of fields. I …IanDeKoker 25 views 4 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM -
How to add more descriptive flexfields in Business UnitsSummary How to add more descriptive flexfields in Business UnitsContent Hi We would like to ask if there is a way to add more descriptive flexfields in Business Units? T…User_2025-02-11-12-30-38-982 34 views 1 comment 0 points Most recent by Vaishnavi Aryasomayajula-Oracle Reporting and Analytics for ERP -
Oracle Documents of Records linkContent Hi Guys, Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. tha…User_2025-02-05-11-53-59-507 32 views 2 comments 1 point Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
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 556 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