BI Publisher
Discussion List
-
How to enable horizontal scroll while creating/editing a xpt reportSummary: How to enable horizontal scroll while creating/editing a xpt report Content (required): Create a xpt report using data model having many columns, while trying t…Bhavna-Civeo 12 views 2 comments 0 points Most recent by PadmanabhamP Reporting and Analytics for HCM -
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?Hi everyone, I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to b…Karthik Adiga-Oracle 1 view 1 comment 1 point Most recent by Sivasekar Narayanan-Oracle Reporting and Analytics for HCM
-
Need sql query to join between subledger and fixed asset and asset invoicesSummary: We are pulling the general and sub-ledgers for fixed assets and asset invoices in order to create a custom BI report for fixed asset reconciliation. Since we ar…
-
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th…
-
From custom BI report Can we add 'From and To date' for seeing GL balances with backdated.Hi All, Business wanted to have one custom BI report for seeing GL balances and in that they want one parameter that is 'From and to date' to see the GL Balances with ba…Vasu N0897645321-Oracle 2 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Is there any way to send notification for the upcoming expiry courseSummary: Is there any way to send notification for the course which user has already completed and about to get expire course (60 days before expiry date) but that notif…
-
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 31 views 3 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security -
Required interface tables for the below tasksSummary: Hiteam, We are unable to find interface tables for the following tasks, we gone through the oracle docs but we could not find the below tasks interface tables. …Opkey PA 21 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to identify who removed a role for a specific userSummary: How to identify who removed a role for a specific user Content (required): Which table holds the details of who and when a specific user role is revoked for a p…Vinothkumar Somasundaram 349 views 2 comments 0 points Most recent by User_FPR9R Reporting and Analytics for HCM
-
Tracking Timely TerminationsHi Does anyone have or is aware of a report or dashboard that tracks the termination submitted for processing? We are having issues with overpayments to employees have s…Jose Guerra 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM BI Table to retrieve employees Eligible for a compensation planSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom BI reporting collecting compensation plan columns at the em…Valerio Curzi 42 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 52 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
I can't see report of import autoinvoceI can't click on republish and download the pdf of the import. Maybe I need a privilege, I don't know.
-
How does the ar_bpa_print_requests table get populated?Summary: We are getting timeout issue when trying to print an invoice using the Print Receivable Program. However, this issue only happens if the delivery method of an I…marc.joed.de.guzman 73 views 2 comments 0 points Most recent by marc.joed.de.guzman Receivables & Collections
-
Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher ReportContent Hi Gurus, Can we Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher Report? I Created BI Analysis report and then Agent to call Analysis …Sunnyrajarora-Oracle 93 views 4 comments 0 points Most recent by PranayBhargava13 Reporting and Analytics for HCM
-
How to print overflow checks on plain paper using different tray's in printer.Summary: Hi Team. We have a requirement to print overflow remittance pages of AP Check on a different paper than the check paper. For example, in the check template, if …Ramprakash09 288 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Ability to extract in bulk printed pdf attached against AR transactionsSummary: We enabled the feature allowing attaching printed pdfs against AR transactions . “Printed Transaction Copy” (Category) are all attached against printed AR trans…Oliver Lemaire 31 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Long running BI report send notification message to userSummary: Hi Team, we have couple of reports are running in production environment are very long running its not throwing an error can you please suggest how to set the l…
-
In the Customer merge How to get Original Party site details?We recently performed a customer merge activity in the non-PROD instance. To track the details of this activity, we developed a BIP report to display both the old and me…
-
Is there any settings for Check Print to print void at the last actual check amount on the 1st page?Summary: Standard check print Report is invoked as part of payment process request whenever payment is done automatically Format Payment Files program trigger and output…Sonal Umesh Jawalkar 241 views 7 comments 0 points Most recent by Yuko Asanuma Payables, Payments & Cash Management
-
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 15 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Excel template with multiple sheets in outputSummary: I require my excel template to push out multiple sheets. One for each business unit with underlying customer transactional data per business unit sheet. Content…Chez 306 views 10 comments 1 point Most recent by Ankur Jain--Oracle Reporting and Analytics for ERP
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 12 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Can I use responsive design when displaying BI?Can I use responsive design when displaying BI?