BI Publisher
Discussion List
-
How to build query like audit report?Summary: Content (please ensure you mask any confidential information): I can run this Audit Report: Is it possible to query the database to obtain the same info? Versio…Stefano_Mazzocca 26 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM -
filter out html imputs in columnSummary: Im making a reporting for talent and need to filter out de html inputs in the Description field of the table HRT_CAREER_STATEMENT_ITEMS_V. is there a better way…Lucas B Maciel 11 views 0 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM -
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks…Valerio Curzi 21 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Ability to run trial balance report ESS jobSummary: Oracle fusion user should be able to run only trial balance report seeded ESS job through his login. Help me with all the required privileges I need to add to m…Aditi Agrawal2650 342 views 2 comments 0 points Most recent by Kumar 57 General Ledger & Intercompany -
In which table has the information of Manage Legal AuthoritiesSummary: SQL query or Table has the information of Manage Legal Authorities Content (please ensure you mask any confidential information): Version (include the version y…
-
Cannot get specific element entry values from XML data cache column for pending transactionSummary: We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entrie…Kaustubh Deshmukh 12 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Need query for Calculation card values to run result values in hcm fusionSummary: Need query for Calculation card values to run result values in hcm fusion Content (please ensure you mask any confidential information): Need query for Calculat…Kaustubh Deshmukh 11 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
How to convert WD attachment in the rtf into table formatHi everyone I want to check if there is any possibility to convert the attachment from Work definition screen into table format. Below is the attachment being printed in…Mazher Shaikh 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
I m getting below error on job run####[2025-06-04T06:47:38.908+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…Tejashwini K H 61 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is there a query to get job board (e.g. LinkedIn, Broadbean) posting status?Summary: Is there an SQL query to get job board (e.g. LinkedIn, Broadbean) posting status for a specific job requisition? Content (please ensure you mask any confidentia…TomaszWyszomirski 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
forgetaccount utility not working for one of the userSummary: Hi All, I am trying to use forget accounts from this document and it is not working How To Run renameAccounts/forgetAccounts When User is Unable To Login to Ana…LC2502 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…AvishekNandi 518 views 4 comments 0 points Most recent by User_0Z82M Reporting and Analytics for HCM
-
Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateSummary Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateContent Hi, I need to build i query to capture the response of ques…User_2025-02-01-06-00-15-095 764 views 4 comments 1 point Most recent by bhoomika pessay Reporting and Analytics for HCM -
User Entity to get deleted Absence Records - HCM ExtractHi, I have a requirement to extract deleted Absence Records using HCM Extract and send it third party payroll. Could someone suggest the appropriate User Entity?
-
Read xml file from UCM using BIPESS job “Process Expense Reimbursements and Cash Advances” generates file in xml format. Client requirement is CSV format file. It is not possible to change the output t…
-
Since redwood update in hcm the URL for reports are now not able to be shared as these get 404 errorSummary: Redwood has been updated into our production enviroment. The URL for the BIP reports, now no longer is able to be copied, shared as a link, and opened. Content …
-
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch…Aloka Bhattacharya 484 views 10 comments 1 point Most recent by Naresh Choudhary Reporting and Analytics for HCM -
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…User_2025-01-28-05-11-13-165 912 views 11 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
In which table has the information Manage Reporting EstablishmentsSummary: Hi Team, Need a table or sql query to get the information Manage Reporting Establishments as in below marked screenshot Content (please ensure you mask any conf…Opkey PA 73 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload…Martina Iovino-Oracle 44 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do …Parag Hiremath 21 views 3 comments 0 points Most recent by MitG-Oracle Reporting and Analytics for HCM -
Display Value for Time Entry Layout Component fieldSummary: Display Value for Time Entry Layout Component field Content (please ensure you mask any confidential information): Hello, I have a time entry layout component o…Irina Erhan 164 views 7 comments 0 points Most recent by Rob Williams Reporting and Analytics for HCM
-
Table to fetch evaluation selection field into BIP reportHi Team, I am trying to fetch activity evaluation details in BIP report , please let me know which table I should be looking into to get the Evaluation selection fiels. …
-
Underlying table for Configure Evaluations pageSummary: Hi Team, Is anyone aware of the underlying table for the Configure Evaluations page ? We would like to extract that information as part of a report. Navigation …
-
Embedded Reports not loading 1st time opening the screensSummary: Embedded Reports not loading 1st time opening the screens Content (required): Hello We have 2 embedded reports in the absence screens which are not loading on t…Helen Thomas 31 views 5 comments 0 points Most recent by David Chang R. Reporting and Analytics for HCM
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP
-
Payment File formatSummary: Payment File format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACCOUNT_…Venkatesan 31 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Custom Data Model Not Reflecting in Payment File – Fix?Summary: Context: We have set up a transmission configuration to transmit files to an SFTP server. Additionally, we have: Created a Data Model to extract the required fi…Sandeep cheerla 4 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.4K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac…Valerio Curzi 702 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM