BI Publisher
Discussion List
-
Printing Asset barcode on RFID label form Oracle Fusion by using Zebra RFID printerSummary: We got a requirement to print a barcode on RFID label using Zebra printer for new assets. Let us know whether this is achievable or not in oracle fusion. -
How to enable BI for document fiscal classification fieldTeam, We are looking to enable BI for the field Document Fiscal Classification in invoice creation under the tax details. Enabling BI for the requested field will help u…
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 21.5K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Chart functionality in Word's BIP add-inSummary: I want to display data from different time periods on a radar graph, but I don't know the necessary setting Content (please ensure you mask any confidential inf…Keita Furuya 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 53 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to Embed an HTML Page in XSL for Report Generation?Hello everyone, I'm seeking guidance on how to embed an HTML page within an XSL file to include it in a report. I have attached the HTML for context to facilitate unders…Nando 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Purchase Orders Number and Requester NameSummary: What subject area to be used to create a report showing PO number and the requester name from the PO line. Content (please ensure you mask any confidential info…Ahmed Maher Kadeh 202 views 2 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
In which table can we find Reserve for Encumbrance Account value ?Summary: Im looking for the table where is stored the code combination (code_combination_id) of "Reserve for Encumbrance Account" Content (please ensure you mask any con…
-
Fusion HCM Table Column to fetch "New Hire Status"Please guide us with Table.Column to fetch "New Hire Status" information for an employee. PFA image for UI screenshot.Ranganatha_CV 43 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 52 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Someshvar Bansal 3 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job?
-
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie…Joe Dorrian 105 views 3 comments 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
How to join GL_JE_BATCHES and FA_FUSION_SOAINFRA.WFCOMMENTS tables in Oracle FusionSummary: What is the key column to join GL_JE_BATCHES and FA_FUSION_SOAINFRA.WFCOMMENTS tables in Oracle Fusion Content (please ensure you mask any confidential informat…
-
How to restrict Data Source in BI > Data Model > Data SourceSummary: Can we restrict the List Of Values from BI > Data Model > Data Source Content (please ensure you mask any confidential information): Customer is soon going to b…Dhananjaya Bhatta 151 views 3 comments 0 points Most recent by Dhananjaya Bhatta Reporting and Analytics for HCM -
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
All Scheduled Absences Report Not Pulling an EmployeeSummary: There is a custom BI publisher report that our HR department runs every pay period to view absences for that pay period. For some reason, in the last pay period…Henry Imgrund 1 view 0 comments 0 points Most recent by Henry Imgrund Reporting and Analytics for HCM
-
Is it possible to customize data model for check print reportIs it possible to customize data model for check print report to add additional fields.vikram khengare 3 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
To Hide the "Edit Distributions" task by using SandboxHello, Team. In the Manage Transactions Screen, the user wants to hide the 'Edit Distributions' option under Actions Item. Navigation to this screen-->Receivables-->Bill…Venkateswari 26 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
All AR transactions excluding vat and remaining balanceSummary: We need a report showing all AR transactions excluding vat and remaining balance including vat as at a date. If there is no remaining balance no need to be in t…
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 158 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
How to write SQL query to fetch the Tax value present in TransactionSummary: Needed to write SQL query to get total tax amount for a particular transaction shown in UI(please check below screenshot ) Version (include the version you are …Anoop Pillai 72 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Where can I find the create customer statements RTF to change to Logo?Summary: Good day, I am in the process of activating the create customer statements report because the Finance Team hasn't used it; However, I realize that the logo is n…
-
How to rectify No Access to BI Consumer RoleSummary: Hello Experts, In an attempt to remove catalogue access for Managers I have accidentally marked the custom folder in OTBI with BI Consumer Role 'No Access'. Is …Dan_Hinsley 111 views 2 comments 0 points Most recent by Dan_Hinsley Reporting and Analytics for HCM -
AP Aging The report will present the invoices payed and unpaid status as of the date selected?Parameter As Of date = Due date The report will present the invoices payed and unpaid status as of the date selected But we are facing an issue with the invoices that ha…Mohammad Hussein 25 views 3 comments 0 points Most recent by Mohammad Hussein Payables, Payments & Cash Management
-
OTBI Custom Dashboard look and feelHi Team, My customer has shared a requirement to customize a OTBI dashboard and wanted to view like attached image. Is there any option to make such graphical view? Plea…Mohan Murali P-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 127 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
GL Journal Lines reporting for Mexico's Electronic Invoice UUIDSummary: I have a requirement to store Mexico's electronic invoice number (aka UUID) at the GL Journal Lines level. The UUID is being passed from Oracle Cloud Payables t…NancyR_Bravo 121 views 2 comments 0 points Most recent by NancyR_Bravo General Ledger & Intercompany -
Help me to get the documentation for the standard extracts available in fusionSummary: We are getting the standard extracts which are all available in the fusion. But unable to get the extract details. like any documentation. Please help us to get…RANJITH KUMAR S 25 views 3 comments 0 points Most recent by RANJITH KUMAR S Payables, Payments & Cash Management