BI Publisher
Discussion List
-
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 144 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 85 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 867 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 22 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,
-
Issues with customizing Journal Entry Reserve Ledger Report / ESS JobSummary: Issues with customizing Journal Entry Reserve Ledger Report / ESS Job Content (please ensure you mask any confidential information): We are encountering report …
-
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 44 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales -
Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES TableSummary: Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES Table Content (required): Hi All, Can anyone please let me know the use of the column PAYROLL_CHG_FLAG in ANC…
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 484 views 2 comments 1 point Most recent by User_0P0CT Reporting and Analytics for ERP
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 286 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 47 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Positive pay files template migration through pasteItem2 soap APISummary: when using the pasteItem2 SOAP API to import the customized seeded report layout positive pay file, we encounter an issue: the report layout is successfully upl…Thyagaraju 11 views 1 comment 0 points Most recent by Thyagaraju Payables, Payments & Cash Management
-
Oracle SQL - Position at a point in timeSummary: Hi, I am just writing a query to get any employees that are on secondments, leave, etc at a given point in time. One of the key requirements is to get all the a…Simranjeet Singh 21 views 0 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" subject areaSummary: Duplication of "manager question text" and "manager response text" in "Workforce Performance-Performance Check-in Real Time" subject area. Content (required): A…kayoung lee 101 views 2 comments 0 points Most recent by Ilaria Petrosino Reporting and Analytics for HCM
-
How to embed/display the DOR attachments/images (blob data) in BIP reportWe have a requirement where employees signature needs to be captured in BIP template/report. So we are thinking of loading the employee signatures as an image via DOR ag…
-
Salary record deletion AuditSummary We have deleted a salary record for a person, is there any way to pull these information for audit through reporting or by any other means?Content Hi, Since we h…User_2025-01-29-01-34-30-592 102 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need API for User module name , Module key and module type under manage value setsSummary: Hi Team, We need a API to get User module name , Module key and module type under create value set as shown in below screenshot. Content (please ensure you mask…
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …Gurvinder Singh Gill 901 views 3 comments 0 points Most recent by Sravani Budde Reporting and Analytics for ERP
-
How to attach custom bi report to document of recordsSummary: How to attach custom bi report to document of records Content (please ensure you mask any confidential information): Hi All, We got a requirement to attach bi r…