BI Publisher
Discussion List
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…
-
How to wrap text in BIP report with excel outputSummary: Is there a possible way to wrap the text in BIP report? In the current setup, the description in the field is too long to fit within the cell, making it difficu… -
Update Learning Withdrawal NotificationSummary: Update Seeded Withdraw Notification Content (please ensure you mask any confidential information): How can we update the learning assignment withdrawal notifica… -
How to handle ESG Reporting in ERPHi, We have a requirement from a customer to include ESG reporting within ERP. They do not use EPM. What solutions have you implemented using standard Oracle Fusion ERP … -
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 514 views 13 comments 2 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management -
Approach to accurately identify active reports in Oracle Fusion CloudWe are trying to build an accurate inventory of all custom reports used in Oracle Fusion SaaS, including BI Publisher (BIP), OTBI, and Financial Reporting Center (FRC) r…KiranChittoor 15 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Can attachment content be copied on BIP Report outputSummary: Can attachment content be copied on BIP Report output Content (please ensure you mask any confidential information): Hi All, Greetings! We have a requirement ab…Parag Hiremath 20 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Update blue on blue colouring for BIP list of values in menu based promptsSummary: In BIP when we select values in a prompt where options are derived from an SQL query, we see a selection window where the selection shows in a shade of blue, bu…Ashish_Sahoo04 22 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Which table has the information for Rule Builder for Checklist Template redwood taskSummary: Hi team, Which table has the information for Rule Builder for Checklist Template redwood task. Need the table where Rule builder name stores for the checklist c… -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 6.4K views 18 comments 0 points Most recent by Ulfi Primawati Reporting and Analytics for ERP -
How to customize Disbursement Payment File FormatSummary: How to customize Disbursement Payment File Format Content (please ensure you mask any confidential information): We are looking to implement a new electronic pa… -
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 21 views 5 comments 6 points Most recent by Bejoylin Reporting and Analytics for HCM -
IFRS 18 Compliance- step by step instruction for setup for Hongkong ClientsHi, From January 2027 onwards IFRS 18 is going to be implemented, is it mandatory for Hongkong based clients? If yes, provide us the approach given by Oracle to acheive …Rachaiah Vadlakunta 21 views 3 comments 0 points Most recent by Rachaiah Vadlakunta General Ledger & Intercompany -
ORA-64203:destination buffer too small to hold to hold clob data after character set conversationSummary: I was using below logic for getting job profile responsibilities and it was throwing the error "ora-64203:destination buffer too small to hold to hold clob data…Ranjith1166 33 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we build a custom report or dashboard in FDI to view requisitions by locationSummary: Can we build a custom report or dashboard in FDI to access and view requisitions by location? Content (please ensure you mask any confidential information): Hel… -
Adding Parameter as of Date in Payables Invoice Aging ReportSummary: We want to get same report with adding parameter as of date in Payables Invoice Aging Report Content (please ensure you mask any confidential information): Vers… -
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus… -
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive… -
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 101 views 3 comments 0 points Most recent by AntoineSGSC Reporting and Analytics for ERP -
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti…Phani Sajja 111 views 4 comments 0 points Most recent by Edward_Cowne Reporting and Analytics for HCM -
Where can i download the font file oraMICR_V2.ttf for check printing in Oracle FusionSummary: Where can i download the font file oraMICR_V2.ttf for check printing in Oracle Fusion Content (please ensure you mask any confidential information): Version (in…Junaid Ali 11 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
HDL Attributes List QuerySummary: Hi - I'm looking for a query where it can pull all the Information from the below screenshot. I can run that query and export the results rather than going to e… -
How to know if we use CTX format for our ACH Payments?Summary: Hello, we need to find out if we use CTX format for our ACH payments? In our mapping of payment format, i see CTX hardcoded. But I am unsure if that would be en…Lovely Tamba 11 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
Can we differentiate custom verbiage for Emp & Payroll in Personal Info workflow FYI Notifications.Summary We are currently working on customizing the workflow notifications for Personal Information changes (specifically modifying the PersonalInformation_AddressPostRe…RajeevVeligeti 12 views 0 comments 0 points Started by RajeevVeligeti Reporting and Analytics for HCM -
PGP Encryption is producing a .tmp file at vendor's endWe are using the public key provided by the vendor to encrypt the file being sent to the SFTP using the HCM Extracts vis BIP delivery. When the vendor is decrypting the … -
How pull full description of department name using gl_code_combinations tableSummary: Trying to pull department name for custom report. When using fnd_flex_values_vl table the description displayed in the BIP report SQL results only contains 29 c…