BI Publisher
Discussion List
-
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… -
Lease Accounting - Generate Full Amortization Schedule on DemandHi ERP Reporting Gurus! I'm trying to build a report that effectively recreates the full lease detail report that is generated when you create the lease or make an amend…Patrick Northcraft 6 views 1 comment 0 points Most recent by Patrick Northcraft Reporting and Analytics for ERP -
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 127 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
Otbi report to compare budget revenue, baseline cost to project funded amountI am triying to create a report to ocmpare project planned cost, budget revenue against the funded amount in contracts module by combining Project Finacial plan with Pro…
-
Need to show or hide details in po approval notification based on the approversSummary: Hi Team, We have modified the PO approval notification to add few details. We would like to display some contents in the notification report only to few approve…
-
GL-HUB-AP report takes too long to runWe have a report which pulls GL, Hub and AP data by journal line level, it takes a long time to run since it is going back into Hub, which has +1mn transactions per day …
-
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …
-
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…Lavina Bansal 355 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 1.9K views 11 comments 3 points Most recent by Luke Quell Reporting and Analytics for ERP -
Is there a way to display the full content of a Text Attachment on a Purchase Order/PO PDF report?Summary: Full Text Attachment content is not being displayed on PO or PO PDF print report. Content (required): The table and column which stores the PO text attachments …Gaurav Rochwani 235 views 4 comments 1 point Most recent by User_J815D Reporting and Analytics for ERP
-
Delivery Filename in BIP Bursting definitionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Utkarsh_Upadhyay_HCG 15 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp…Harrison Jacob 12 views 0 comments 1 point Started by Harrison Jacob Reporting and Analytics for ERP
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…
-
Which table holds the error details for unsuccessful imports of Customer Credit hierarchy data?Summary: Hi Team, I am in the process of importing "Credit Hierarchy" data through "Import Management" (Object = Hierarchy & Hierarchy Member) and am working on a BIP re…Dhilip Kumar P. 2 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…
-
PO PDF Report Showing Truncated “Text to Supplier” – Full Attachment Name/Text Not Printing CompleteHi all, We’re facing an issue with the PO PDF report where the Text to Supplier (or text from the URL attachment) is not printing completely. When we open the attachment…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 543 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 817 views 9 comments 0 points Most recent by Adnan Saleem Reporting and Analytics for ERP
-
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.User_DDXB9 71 views 11 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…Vinay Gharge 141 views 5 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP
-
Default Multiple Value for Multiple Selection ParameterSummary: Is anyone know how to pass the multiple default value in multiple selection parameter. Content (please ensure you mask any confidential information): N/A Versio…Yeung Shing Keith 14 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 6.4K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 27 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 38 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t…
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…