BI Publisher
Discussion List
-
How to create View Image in AP invoice pageSummary: How to create View Image in AP invoice page Content (please ensure you mask any confidential information): Hi All, We got a requirement to create one button and…Venkatesan 11 views 1 comment 1 point Most recent by Venkatesan Payables, Payments & Cash Management -
Unable to Cancel AP Invoice(I Supplier Portal) using Rest API.Summary: Hi All, Our business receives a lot of invoices thru Supplier Portal, and some of them are rejected in the approval process. However, if the rejected invoices a…K venkatesh 52 views 2 comments 0 points Most recent by K venkatesh Payables, Payments & Cash Management
-
How to check the which stage of TLSS workflow transaction got flagged incomplete?Hi Team, Could you please confirm Is it feasible to add a column to identify in which stage of TLSS workflow transaction got flagged as incomplete, for example while doi…
-
sql query to get resignation approval statusSummary: Hello , I need to add column "pending with " in BIP if Resignation is pending for approval with Line Manager then "pending with "column should display "pending …
-
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based…
-
BIP reportsSummary Apply data restrictions on BIP reportsContent Hi , Is it possible to place restrictions on a BIP report output based on Role ? eg: I have a BIP report to display…User_2025-01-30-00-14-06-021 91 views 12 comments 0 points Most recent by llnl_jtw Reporting and Analytics for HCM -
Does fusion have any MEXICO DIOT report readily available ?Summary: Looking for standard Mexico DIOT report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…
-
I am trying to add intermediary bank accounts to our Wire Payment formatSummary Trying to add intermediary banks to our Wire Payment format for boa using a BAFF file formatContent I am trying to add intermediary banks to the payment formats …ChrisKellogg 242 views 17 comments 1 point Most recent by Glen Ryen Payables, Payments & Cash Management
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
List of Approvers in Workflow NotifcationSummary: List of Approvers in Workflow Notification Content (required): Hi , I need a list of Approvers who are going to approve the transaction in below format. I have …
-
Cannot find GL_JE_LINE table when trying to create Data Model for BIP. "SELECT * FROM GL_JE_LINE"When I try to run this sql in a data model it says the record does not exist, but I'm positive it does. Any ideas why we can't select from it? SELECT * FROM GL_JE_LINEWilliam Jordan 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
how to group multiple datasets into single table in RTF template for HCM Global report extract?Hi I am trying to create RTF template from global report data model for HCM. there are 15 data sets into this data model. I need only 4 attributes from 2 data sets Basic…
-
Journeys - Application task type - Talent Profiles no longer worksSummary: Task type is Application and Application Task is Talent Profile. However, when clicked on Go to Application Task, page doesn't moves to Talent Profile Page Cont…
-
URL from HCM Cloud page with one of the parameters = NUL not opening BIP reportHello We had a requirement to open a report from HR Help desk page. Initially we had OTBI report with 2 parameters, Primary Person ID and Affected Person ID. Even if the…Naveen Jayaraman 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
How to Hide Row in BI Publisher Using Conditional RegionSummary: Hi Expert, I'm trying to hide a row based on a simple condition. We have three rows in the offer letter, and the condition is that if the attribute value is nul…
-
SQL Query based on date input value errorSummary: SQL Query based on date input value error Content (please ensure you mask any confidential information): We are trying to run the below query to be used in a va…
-
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 121 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP
-
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount…Ayoub AFRASS 11 views 2 comments 0 points Most recent by Ayoub AFRASS Reporting and Analytics for HCM -
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to add new project/budget related column in Expense approval notificationI suppose to add budget available amount in Expense approval notification where the Budget and Task names are displaying in the Expense Approval notification. I tried to…
-
How we can password protected a bursting BIP report?Summary I want to burst person Information and i want the output file should be password protected with person DOB(MM-DD-YYYY). How we can achieve this using burstingCon…Ashish Mangal 817 views 9 comments 0 points Most recent by Bhanuja Batra-Oracle Reporting and Analytics for HCM
-
Fusion Learn : BI tables for default access mode in offeringSummary: I need to find what default access mode has been set for Self-Service Settings>View Mode using a BI query for offerings. Whether it is no access/details view or…
-
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o… -
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to write a query to get accurate "when is the employee start date?" from the OfferSummary: Hi Team, We are trying to add value for "When is the employee start date?" in one of ours Offer accepted report. However when the employee start date is changin…
-
Learning courses linked to any of the communityHi Team, Anyone developed the report to link the courses under the topic community? If so, please share. Thanks,