BI Publisher
Discussion List
-
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens… -
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C…KabirB 653 views 7 comments 0 points Most recent by Koteswara Rao Kandula Payables, Payments & Cash Management -
Bill management portal link custom template not workingSummary: The welcome email has a portal link, we have customised this to pick the value from a profile variable but the custom template is not being picked. Content (ple… -
Blank line at the end of etext template output fileBlank line at the end of etext template output file.BASWANTH 11 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
How can we pull last day of current month in eText templateSummary: How can we pull last day of current month in eText template Content (please ensure you mask any confidential information): Hi Team, Our bank wants last day of m…Nidhi Chhajed 71 views 5 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 252 views 5 comments 0 points Most recent by AnushaDB-Oracle Reporting and Analytics for HCM -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages… -
is there a way to restrict the use of commas in receivables transaction line descriptionHi We are using Fusion Receivables , is there a way to restrict the use of commas in receivables transaction line description. Since the extract of transactions are sent… -
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 251 views 2 comments 1 point Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 321 views 5 comments 0 points Most recent by CharanBochker Reporting and Analytics for HCM -
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 44 views 4 comments 0 points Most recent by Muzammil_789 Reporting and Analytics for HCM -
cancel scheduled BIP jobs for inactive users in Oracle FusionSummary: We have users who are no longer active but have their scheduled jobs (including BIP) running. Is there any process to abort these scheduled jobs? Content (pleas…Chetan Banglorewala 1 view 5 comments 0 points Most recent by Chetan Banglorewala General Ledger & Intercompany -
Deep link for notification learning offer/courseSummary: Content (required): Hello everyone, We are experiencing a problem with deep links to be used within custom notifications for the Learning module. In particular … -
Custom template and Data model for Customer statement is not being picked in AR moduleSummary: We have used the seeded data model for Print statement and customised it with additional fields. This is placed in the custom folder (path similar to the seeded… -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please … -
BI Publisher - Bursting - Email Delivery Channel - HTML Message BodySummary BI Publisher - Bursting - Email Delivery Channel - HTML Message BodyContent All, Able to burst BI Publisher Reports and deliver them via email using: Email PARAM…User_2025-02-05-22-13-16-277 1.1K views 7 comments 3 points Most recent by Aditya Jena Reporting and Analytics for HCM -
How to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcmSummary: Hi Team I am looking for how to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcm Could you help me on this Content …Anup Karmankar 23 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM -
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …Mohak Kirtane 154 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
How to join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t… -
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not… -
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 812 views 8 comments 0 points Most recent by PiyasaMandal1 Payables, Payments & Cash Management -
4-Bucket parameter is not showing for Receivables Aging by General Ledger Account ReportSummary: 4-Bucket parameter is not showing for Receivables Aging by General Ledger Account Report Content (please ensure you mask any confidential information): Run Repo… -
How to replace invalid XML character (fffe)Summary: Due to invalid characters in Purchase Requisition header description (mostly likely due to requestor copied and pasted content containing this invalid control c… -
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo… -
Download Attachment File from Oracle REST API (HCM/SCM) without MiddlewareI was able to successfully retrieve the download URL from Oracle Fusion REST API within BI Publisher (Data Model only), and the link works correctly. However, when downl…