BI Publisher
Discussion List
-
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know…VarunG 464 views 8 comments 0 points Most recent by Govind Kumar Reddy S Reporting and Analytics for HCM -
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA -
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 5 views 0 comments 0 points Started by Velidi Supraja Reporting and Analytics for HCM -
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,… -
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 15 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM -
Which table contains 'Collaborator' for Oracle Recruiting CloudSummary: Which table contains 'Collaborator' for Oracle Recruiting Cloud Content (please ensure you mask any confidential information): Hi, we would like to have a BI Re…Barile Alberto 17 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How can I force FND_FLEX_VALUES_TL to update to the latest values for Description?After updating the Name of Department from '60508-East Operations-508' to '60508-Operations-508' via Setup & Maintenance > Manage Departments > Update > Submit The FND_F…Matt_C. 13 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple AssignmentsHi Navigation: Calculation Cards > Benefits and Pensions I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report. If not…Nilesh D Patel 23 views 0 comments 0 points Started by Nilesh D Patel Payroll and Global Payroll Interface (GPI) -
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)… -
Tables Name to Access to the employee's Compensation historySummary: Tables Name to Access to the employee's Compensation history Content (please ensure you mask any confidential information): Hi, we are looking for the tables wh…Barile Alberto 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con… -
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing … -
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …Priya J N Singh 20 views 2 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM -
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f … -
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,…Stefano_Mazzocca 12 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.4K views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 55 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 39 views 1 comment 0 points Most recent by Srikanth Nakka Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…User_2025-10-31-00-42-31-597 223 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 29 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need help in Fetching Arrear Balance Value with pay_balance_view_pkg.get_balance_valuesHello Hope everyone is doing well! I need to use the below query to fetch Inception to Date Arrear Balance for Benefits Deductions in a existing BI query, the below quer…Gaurav Bhardwaj 20 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…Gundllapally Sagar 125 views 2 comments 1 point Most recent by Showstopper09 Human Capital Management -
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a … -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont… -
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer… -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 8.8K views 10 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact…G. Class-Peters 4 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM