BI Publisher
Discussion List
-
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 14 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 2 views 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
-
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 784 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 486 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 938 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 71 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 42 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 171 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 32 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 16 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 2 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.5K 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 795 views 1 comment 0 points Most recent by Vishnu Vardhan Raju 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 14 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Unable to find validation status in AP_INVOICES_ALLWe are creating a custom report and we need to give invoice validation status as a parameter. I am not able to find anything with validation status. Need some help on it…KabirB 76 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
How to populate issued by in course completion certificateSummary: We have a seeded report called course completion certificate. Here there is a rtf which contains a field called Issue By field to indicate who is the certificat…
-
We are trying to customise the Standard Receivables Aging by General Ledger Account reportSummary: We are trying to customise the Standard Receivables Aging by General Ledger Account report and from the seeded output, we see that the accounted amounts has bee…
-
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) …
-
HCM Position extract from EPBCS not generating records in HCM view extractWe have downloaded the HCM extract from EPBCS and uploaded the extracts to HCM. When we run data extract for Position in HCM, there is no data being generated in HCM. We…
-
Big performance difference between the query in BIP data model and the pure querySummary: The issue below has been observed Performance of a custom BIP started to be extremly degraded post to the upgrade. The BIP used to run in a second, but it start…Sunghpark 31 views 3 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP