BI Publisher
Discussion List
-
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…Rohit Soni-259808 2K views 13 comments 0 points Most recent by Anil Rout-Oracle Reporting and Analytics for ERP -
Add Expense Account Segments to Printable Expense ReportSummary: We have a request to add the Account; aka Expense segment code to the Printable Expense Report. Content (required): We have a request to add the Account (highli… -
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR…Bhavik Shah 3.3K views 5 comments 3 points Most recent by N.V. Mehta Reporting and Analytics for ERP -
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. … -
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …Opkey PA 532 views 6 comments 0 points Most recent by Sammeta Srividya Reporting and Analytics for HCM -
Extract information related to custom report names, dashboard names, and data model namesWe need to extract information related to custom report names, dashboard names, and data model names created for an application, along with their paths and specified typ…Sanal-Oracle 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…User_2025-01-30-17-58-41-867 759 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…Opkey PA 60 views 1 comment 0 points Most recent by Poojitha Siddamsetty - Support-Oracle Recruiting, Opportunity Marketplace -
How to customize the sub template for Termination Report?Summary: How to customize the sub template for Termination Report? Content (required): Hi All, How to customize the sub template for Termination Report? Where I can find…Venkatesan 31 views 5 comments 0 points Most recent by Priyanka Ramesh Reporting and Analytics for HCM -
Tax Audit Report - Std report not following the data access setHello Everyone, I was running this standard report and noticed that it did not respect Data access set. To replicate this issue we can do the below: Navigate to schedule… -
We could see some extract sections from bakend for the task Profile Content Section AccessSummary: Hi Team, We are encountering an issue that there are some more sections in UI which we are unable to find functionally and technically where these extra section… -
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f… -
Is there a way to dynamically rename split rtf files using PDFZ output?Summary: We have a requirement to rename the individual pdfs that get generated from an .rtf report in BIP. I think I am "close", but I can't seem to get the XML tags co…Abrahamson, John 1 view 1 comment 1 point Most recent by Abrahamson, John Reporting and Analytics for ERP -
How to ensure date columns in BI Publisher Excel output use date filters instead of text filters?Our customer wants to download online versions of reports in Excel format, next they will be applying filters on the table for deeper review and analysis. There are mult…Sayan Jasu 64 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
BI Publisher Emergency Contact ReportSummary Building Emergency Contact Report in BI PublisherContent Hi Everyone, I am currently struggling in producing a BI Publisher report for emergency contacts, i know…User_2025-01-29-21-02-12-466 545 views 16 comments 0 points Most recent by TKB Reporting and Analytics for HCM -
How to record more than 350 Character in DFF fusion AR Cloud ?Summary How to record more than 350 Character in DFF fusion AR Cloud ?Content Hello This is the business requirement , we need to store QR code string in DFF which is gr…gabriel kinovisques-163562 59 views 5 comments 2 points Most recent by Vijayakumar66345 Receivables & Collections -
How to break down biweekly earnings and deductions into weekly earnings and deductionsSummary: Hi Team, Our payroll is currently biweekly. However, we have a requirement to create a custom report that breaks down biweekly earnings and deductions into week… -
write a sql query to fetch total No of Change StatementsSummary: write a sql query to fetch total No of Change Statements Content (please ensure you mask any confidential information): Version (include the version you are usi… -
write a sql query to fetch Total No of Active Bonus/STI/LTI PlansSummary: write a sql query to fetch Total No of Active Bonus/STI/LTI Plans Content (please ensure you mask any confidential information): Version (include the version yo… -
write a sql query to fetch Total No of Active Plans for Performance CalibrationSummary: write a sql query to fetch Total No of Active Plans for Performance Calibration Content (please ensure you mask any confidential information): Version (include … -
write a sql query to fetch total No of Active Plans for Promotion / Grade Step ProgressionSummary: write a sql query to fetch total No of Active Plans for Promotion / Grade Step Progression Content (please ensure you mask any confidential information): Versio… -
Write a sql query to fetch Total No of Active Salary review PlansSummary: Write a sql query to fetch Total No of Active Salary review Plans Content (please ensure you mask any confidential information): Version (include the version yo… -
How can we report Person Criteria used in Learning InitiativesSummary: We are working on a requirement where certain learning courses are mandatory for employees based on their Job or Position. requirement is: A best practice for s… -
Could not find the table link between Rating Model and Profile section nameSummary: We could not find the table link between Rating Model and Profile section name HRT_PROFILE_TYP_SECTIONS_VL - section names are available in this table HRT_RATIN… -
BIP Bursting is not delivered the emails to DLsSummary: Bursting emails from a BIP report are not delivered to any of the email ID's part of DL list, even though the Report Job History/Output & Delivery section indic…Priyanka_Ghosh 221 views 8 comments 2 points Most recent by abhinav.anand-Oracle Reporting and Analytics for ERP -
How to perform conditional formatting on Excel template when old value is not equal to newSummary: I have built a Changes only extract to get the employee Demographic information and getting data in Excel format in separate sheets. First sheet contains new hi…Sreenivasulu Kaveti 11 views 1 comment 0 points Most recent by Vijay_Huron Reporting and Analytics for HCM -
How do you manage consecutive check number using Remittance stub?Summary: When you use Remittance Stub and Void by Overflow in "ExternalCheck.rtf" template for PPR in Account Payables, you have check numbers for void check as well as …Yuko Asanuma 51 views 2 comments 0 points Most recent by Nandyala Harish Reddy Payables, Payments & Cash Management -
Create 'Buyer Assignment Rules' ReportGood Day Experts, Is there a way to create a report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Application. Col… -
German Characters are displayed as Junk.Summary German Characters are displayed as Junk.Content Hi All, We do have a Custom BIP Report to send the extract to External System. When we submitted the report manua…Uvaraja-Oracle 47 views 1 comment 0 points Most recent by Naveen_CCC Reporting and Analytics for ERP