BI Publisher
Discussion List
-
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 92 views 0 comments 0 points Most recent by Carlo Reyes-59977 Reporting and Analytics for HCM -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 555 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…
-
What is the link between batch name and ESS job Import Journals ?Hello, We need to query the details of a journal batch (Batch name) with the schedule process (ESS Job 'Import Journals') that created that journal batch. We obtain the …
-
Cannot generate "Open Purchase Order Analysis Report"When I tried to run the standard "Open Purchase Order Analysis Report," I noticed that it doesn’t have a layout and the data model appears to be empty. I’d like to under…
-
SQL for ENABLED code combinations that have a disabled segment included.Summary: SQL for ENABLED code combinations that have a disabled segment included. Content (please ensure you mask any confidential information): SQL for ENABLED code com…
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man…
-
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a…UrvashiJ 561 views 1 comment 0 points Most recent by Basavaraj Navalagi Reporting and Analytics for HCM
-
In the BIP report I require Virtual Classroom Type from Learn ModuleSummary: Content (required): I need to fetch " Virtual Classroom Type " and respective Virtual Classroom/Classrooms.Which table field is to be mapped to get the below re…
-
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 223 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Print Receivables Transactions – Historical Delivery Details Retrieval (Older than 1 Year)Hi All, Need to check if there’s any way to retrieve delivery details (email, timestamp, etc.) for invoices sent via the Print Receivables Transactions job, specifically…
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
Table / Columns name to report the Evaluation and typeNeed the table / column information to report the below highlighted fields in custom BIP to review the feedback basis the evaluation attached to the offering against the… -
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…Lakshmi Bandlamudi 1 view 2 comments 2 points Most recent by Mohanasindhu Dhiraviyam Reporting and Analytics for ERP
-
Difference between Date_created column and creation_date column in GL_INTERFACE TableSummary: Difference between Date_created column and creation_date column in GL_INTERFACE Table. Name Datatype Comments CREATION_DATE TIMESTAMP Who column: date and time …
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 21 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Which table is used to extract the offer price data?Hi all, does anyone know which table is used to extract the offer price? We need to retrieve this information for a report. I'm also attaching a screenshot of the data. …
-
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e…Sriharsha Devraj 795 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …User_2025-03-07-05-28-28-079 61 views 10 comments 0 points Most recent by Choudhary Punit Reporting and Analytics for ERP
-
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.…Sunil Pradhan 34 views 0 comments 0 points Most recent by Sunil Pradhan Reporting and Analytics for ERP -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 93 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Job Requisition Audit report neededHi Team, We have a requirement to create a report to bring Requisition Audit report, The client is trying to fetch each transaction that occurs with a requisition , any …Sushant95-Oracle 12 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Budget Override DateSummary: Which Table Stores Budget Override Date Column Content (please ensure you mask any confidential information): Hi Experts, I can see Overrider and Override justi…
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 362 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…
-
Oracle Fusion BI Publisher - Excel Template - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …