BI Publisher
Discussion List
-
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 3.1K views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM -
Any BIP reports to pull Tax withholding details. Federal, State, Local tax dataSummary: Any BIP reports to pull Tax withholding details. Federal, State, Local tax data Content (required): Version (include the version you are using, if applicable): …Prabhu Krishnamoorthy 69 views 6 comments 0 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
Dashboard with BI report linkContent Dear All, I have a requirement to create a dashboard with the direct links of BIP reports. Whenever user clicks on the link, it should directly generate the repo…User_2025-02-06-14-37-05-233 124 views 9 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BIP - Non Catalog Item Report (Learning)Does anyone know how to fetch creation date using BIP? Please see screenshot below:Hazel De Castro 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Unable to resolve " ORA-01427: single-row subquery returns more than one row"Summary: Hi Experts, When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery re…ShawShankk 1.2K views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 338 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
How to create .txt files using burstingSummary: Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria Content (required): We are having issue in gen…Arathi Devi H 362 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 33 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
-
Is it possible to generate csv file with column labels of child records even when they don't exist?Summary: Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist. Example: Data Model queries: Data Set…User_2025-02-11-06-12-35-024 31 views 4 comments 0 points Most recent by User_2025-02-11-06-12-35-024 Reporting and Analytics for ERP
-
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…Robert of STAU 62 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…PrJohns-Oracle 31 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to extract the last update author for document record fieldsSummary: Hello experts, please, could you share the query to execute in order to find the author of the last update on document record fields? Thanks in advance for your…Valerio Curzi 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…
-
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 92 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to restrict custom folder created in dashboardSummary: How to restrict custom folder created in dashboard Content (required): Hi Experts, We have created one custom folder and included all the custom reports in the …
-
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Link external data inside BIP reportSummary: Hi! I have an external data that is in excel file, is there a way to import this data into BIP and access it inside the data model? If yes, kindly share a docum…RenzelkeithCoquia 93 views 6 comments 0 points Most recent by makarandamondikar Reporting and Analytics for HCM
-
Calendar year is not populated in 1099 ReportSummary: Calendar year is not populated in 1099 report output Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code …Surya01 121 views 4 comments 1 point Most recent by Jeff Rich-Terillium Payables, Payments & Cash Management -
SQL query statement to get all unaccounted transaction in AR with full GL StringSummary: Require query to extract all unaccounted transaction in AR with full GL String to review all incomplete Invoices (transactions), credit memos, and on-account cr…Rajesh_BR 2.8K views 1 comment 1 point Most recent by Veronica Stefan-Oracle Receivables & Collections
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…Sahil_Makhiza 1.6K views 7 comments 0 points Most recent by Anjana Das-Oracle Reporting and Analytics for SCM
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 41 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 644 views 7 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…