BI Publisher
Discussion List
-
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 780 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.… -
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 81 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 341 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 641 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? https://us.v-cdn.net/6034893/uploads/3YMOJ095ARMJ/public-keys-downl… -
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 51 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 81 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 22 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 727 views 24 comments 0 points Most recent by Yves Chassein Reporting and Analytics for HCM -
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires… -
Returing null while executing fnd_global.get_session_attribute('JOB_REQUEST_ID')Summary: select fnd_global.get_session_attribute('JOB_REQUEST_ID') from dual is returning null. Can you please how we can get the current job request idTejas Deshpande 22 views 2 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Addition of columns to U.S 1099 Payment reportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 1 view 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management -
Disable FYI Notification for LearningAssignmentCompletionApproval taskSummary: We have a requirement to disable the FYI Notification for the Creator (learner) in the LearningAssignmentCompletionApproval task. Any suggestions would be great… -
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo… -
Where is Source Reference stored in the Review Completed Txns screen?Summary: In the Review Completed Transactions screen we have a ‘Source Reference’ column. I am unable to understand where this is stored in the sql base tables. Content … -
AgingbyGeneralLedgerAccount_Understanding the Receivables Aging by GL Account ReportAgingbyGeneralLedgerAccount_The following three questions are asked about the Receivables Aging by GL Account report: ・There are 546 items when outputting CSV, but I wo…Yuma Suzuki-Oracle 2 views 0 comments 0 points Started by Yuma Suzuki-Oracle Receivables & Collections -
what is the difference between SQL bind and Post SQL bind.Summary: Hi all, I have a requirement where I have to make a dependent parameter in HCM extract. I used refine extract and now need to decide what to use SQL bind or Pos… -
Is it possible to insert a Deep Link for a custom BIP Report for the View Transcript Button?Summary: Is it possible to insert a Deep Link for a custom BIP Report for the View Transcript Button? Content (please ensure you mask any confidential information): Hi T… -
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…