BI Publisher
Discussion List
-
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 581 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 222 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 885 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 41 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 92 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 11 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 371 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 … -
Getting error after scheduling BI Report with Bursting definitionSummary: I have resignation report based on transaction console. I'm scheduling the report with Bursting definition and i'm getting below error. Job processor caused exc…KeerthanaBaskaran 676 views 4 comments 0 points Most recent by User_ICD6K Reporting and Analytics for HCM -
Public Key for sharing with ADP Global View - same key across all environments?Summary: Can we generate the SAME set of public encryption keys across ALL our non-PROD environments? Content (please ensure you mask any confidential information): In t… -
Invoices incomplete status with yellow exclamation markSummary: Invoices imported by IDR are in an incomplete status. The lines on the invoices have a yellow exclamation mark, with type Item. We have a requirement to report …Narinder Sian 61 views 3 comments 0 points Most recent by Kanika Matta Payables, Payments & Cash Management -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to control the scheduled BIP report Output based on Row CountRequirement : BIP report schedule daily - which is configured to send an email - base don the configured emails. Is it possible to control sending an email based on the …Sridhar Gupta Yerram-Oracle 1 view 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
How to Include Supplier Site-Level Details in Payment XML generated by Oracle FusionWe are working with Oracle Fusion Payments and have a requirement to include supplier site-level information in the payment XML (Seeded XML generated by Fusion) and the …mauryapradhyumn420 156 views 2 comments 0 points Most recent by mauryapradhyumn420 Payables, Payments & Cash Management -
In Oracle fusion HCM learning module , Setup configure details are stores in which table ?Summary: Navigation: My client groups —> Learning—>setup—>Configure Catalog Defaults Example: would like to know Configure Catalog Defaults Page Show Enrollment Question… -
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…Debasish Saha 21 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM -
Is it possible to embed OTBI report and BIP report in one dashboard?Summary: Hello, I would like to confirm if it is possible to embed OTBI report and BIP report in one dashboard wherein both reports share with the same dashboard prompt?…Hazel De Castro 721 views 24 comments 0 points Most recent by Yves Chassein Reporting and Analytics for HCM