BI Publisher
Discussion List
-
Too much SQL!Summary Prompt not limiting by another field - Support have advised too much SQLContent Hi I'm getting an "unexpected token" error message when trying to limit one field… -
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…Sian S 100 views 6 comments 6 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Empty spaces in RTF if there is condition not to show a sectionContent We are working on Talent Profile print and it has multiple section so we are creating an RTF template and having a condition to display section conditionally to …User_2025-02-08-10-09-54-910 356 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM -
Development Goals (individual) approval StatusContent How can I get the Approval Status and time approved into Development Goals Status Report. Saw a few recommendations but some seem to be for goal plan for perform…Mike Borghoff 35 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to…User_2025-01-28-21-18-43-496 71 views 4 comments 1 point Most recent by User_X612P Reporting and Analytics for HCM
-
Survey ReportSummary survey report subject areaContent I am trying to build a report on the on-boarding survey responses. I have tried building the report in Workforce Management-Che…
-
Need sample query to check if employee has location as on hire dateContent Hi All, I'm in need of a sample SQL query to check if employee has location as on hire date.Please share if you have the same. Thanks, Ravichandran Version R13
-
BIP - data model joining different data sourcesSummary BIP - data model joining different data sourcesContent Is it possible to join data from two different data sources 1) from a SQL query 2) from an Oracle BI analy…
-
Help BIP Report not pulling correct infoSummary We recently went Live with OLC. One of the reports we built is a BIP report with several parameters.Content Here is the WHERE Clause with parameters. For some re…Mike Borghoff 31 views 3 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
BIP Layout Data Formatting issueSummary When I use the Data Formatting option for BIP layouts the dates are wrongContent When I use the Data Formatting option for BIP layouts the dates never come out c…User_2025-01-23-21-24-21-434 29 views 6 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Join between WLF_RESOURCES_TL and PER_ALL_PEOPLE_FSummary Join between WLF_RESOURCES_TL and PER_ALL_PEOPLE_FContent Team, Please help me with Join Condition between WLF_RESOURCES_TL , PER_ALL_PEOPLE_F. We have requireme…
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary How to Find an IP Address of a User who has Logged in Fusion Application ?Content Hey, I have a requirement to restrict the data based on login IP address in BIP… -
Unable to get the Employee payroll calculation card details from Payroll - Calculation Cards Real TiContent Hi All, We are unable to get Employee payroll calculation card details ( State name, county name and city name details) from Payroll - Calculation Cards Real Tim…User_6I33I 260 views 2 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 70 views 7 comments 0 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
BI Parameter not picking up exact value from XMLContent We have a BIP report with three parameters Learning Item Name, Completion Date and Person Number. The report is working fine for more Learning Item Name's except…User_2025-01-31-00-25-12-234 17 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Dinamically printing contents in a RTF templateSummary does not work in one caseContent Hi, I am using a RTF template for a Report that should display different contents on the basis of the field named "ANNO", whose… -
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…HarishVummidi 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Output file is not getting multiple records using EText template.Summary Output file is not getting multiple records using EText template.Content Hi Experts, Output file is not getting multiple records using EText template. I am attac…Bala Kasineedi 46 views 3 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
DFF of invoice line in Payment Format fileSummary DFF of invoice line in Payment Format fileContent As DFF attributes of invoices line level are not in Payment format XML file? is it possible to cater through an…Sandeep Nihalani 186 views 3 comments 2 points Most recent by Satish Kumar Reddy Byreddy Payables, Payments & Cash Management
-
how to restrict infolet user wise?Summary how to restrict infolet user wise?Sidhartha Wadhwa 40 views 5 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM -
Set up an Agent to pull last 7 days of hiresSummary Set up an Agent to pull last 7 days of hiresContent Hello, We have an employee roster report that is widely used by our HR team for various uses. It does not hav…User_2025-01-23-21-37-42-476 46 views 3 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Specification for DOO_CROSS_REFERENCESummary Specification for DOO_CROSS_REFERENCEContent In the DOO, most of the views 'DOO_CROSS_REFERENCE' Pkg used to get shipment method, freight term...etc Where we can…
-
Issue: Fully Paid invoices need re-validationSummary cXML invoice are fully paid but in needs re-validation status.Content Hi All, Need help to understand what could be the possible reasons to have some of the cXML…Jain, Ankur 43 views 9 comments 0 points Most recent by JOEL DSILVA-Oracle Payables, Payments & Cash Management -
Oracle Fusion-Manage Allocation Formulas- Complex formulas to allocate fees calculated based on reveSummary I want to know what the most effective approach would be for automating fee/royalty calculations for different contract agreements.Content I am trying to help st…User_2025-02-10-23-58-22-465 101 views 2 comments 0 points Most recent by Rohan Kamat Reporting and Analytics for ERP
-
BIP Error MessageContent Hi all - have you seen this error message before? System encountered unexpected error during data processing. Please contact system administrator to enable debug…