BI Publisher
Discussion List
-
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 64 views 1 comment 1 point Most recent by Rinku Gautam Reporting and Analytics for ERP -
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled … -
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 28 views 4 comments 0 points Most recent by Muzammil_789 Reporting and Analytics for HCM -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 62 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail… -
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 8 views 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 … -
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 46 views 2 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Reporting and Analytics for ERP -
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i… -
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… -
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… -
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 6 views 2 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management -
Is it possible to see the Old Value and New Values for Project Management Changes in Audit Data?Summary: I am trying to identify Project Management changes in BIP tables, specifically Project Org or "CARRYING_OUT_ORGANIZATION_ID" . We need to include the historic d…Kimberly Showman 8 views 0 comments 0 points Started by Kimberly Showman Reporting and Analytics for ERP -
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 … -
Sending the clearing date instead of payment date as part of BACS payment runSummary: BACS has 3 days of clearing cycle. My client has a specific requirement to select the day 3 in the payment date column while running the payment run. This is to…Pranshu Todaria 13 views 2 comments 0 points Most recent by Gaurav Kumar-100036 Payables, Payments & Cash Management -
CAMT053 Bank statement load failing with CE-660228 Despite custom JPM FormatSummary: We are trying to load JPMorgan chase CAMT053.001.02 bank statement files into oracle fusion CM using the Load and import bank statement ESS process. The file co…Prashant Prashant 5 views 0 comments 0 points Started by Prashant Prashant Payables, Payments & Cash Management -
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…Amit Baghel 19 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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… -
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 935 views 7 comments 3 points Most recent by Aditya Jena Reporting and Analytics for HCM -
26A Upgrade | Learning | Impact on Database value changeSummary: I have identified a potential impact following the 26A upgrade, based on the Community post (https://community.oracle.com/customerconnect/discussion/948343/data… -
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…Aseef Babujan-Oracle 4 views 2 comments 0 points Most recent by Shakkir K.K Reporting and Analytics for ERP -
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 18 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM -
Payment method details in the tables on the providersSummary: I need to identify which Oracle Cloud Fusion table stores the “Default” and “Payment Method” attributes within the Payments section of a supplier's main site (s…Cristian Rojas 21 views 2 comments 0 points Most recent by Cristian Rojas Payables, Payments & Cash Management -
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 140 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…