BI Publisher
Discussion List
-
Excel based Template Report- Does not provide PDF export optionSummary Excel based Template Report- Does not provide PDF export optionContent One of our BI Report, The Report was created using an Excel based template (Means: Created…Prabhu Krishnamoorthy 20 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…User_2025-02-11-13-25-48-351 28 views 2 comments 1 point Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 17 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557 Reporting and Analytics for ERP
-
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …Rama Pedamallu-193980 63 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
The best idea to notify employees who are working in a manufacturing environment and don't have acceContent Hi Experts, We have a requirement to notify employees working in manufacturing about their Learning expiry. The system provides alerts to be send using emails bu… -
What roles are needed to access the BI Data modelContent Hi, I created a custom role and assigned the roles: BI Administrator Role BI Applications Administrator Duty BI Applications Functional Developer Duty BI Publish…Valdir Dutra 61 views 3 comments 0 points Most recent by Valdir Dutra Reporting & Analytics for Sales -
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…
-
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 35 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 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