BI Publisher
Discussion List
-
How to default logged in user to BI report parameter?Summary: Default logged in user to BI report parameter Content (please ensure you mask any confidential information): Hi, We have a custom BI report, that has a paramete…Elena Tudor 72 views 14 comments 0 points Most recent by Elena Tudor Reporting and Analytics for ERP
-
FLA_ON_DEMAND_SCHEDULES_PKG not generating future period schedules after 25aHi, We had developed 5 Custom lease reports (Lease schedule details report same as the one attached in Lease Accounting schedule tab once lease is finalized) by using FL…
-
Employee Expense AttachmentI need to get the attachment from the header in the Expense Report. I am only getting the attachments from the Expense Items. Am I missing a table or join on this? here'…
-
add 2 columns in ExcelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…ScottSpivey 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 829 views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP
-
ESS Job > Schedule Report > Enabling of Request Delivery Status Notification and Read ReceiptSummary: Hi, We are having some issues with sending Invoice PDF to our customer from an ESS Job. The name of the ESS Job is Print Receivable Program. We were told that s…marc.joed.de.guzman 32 views 3 comments 1 point Most recent by Maricel Ortega Receivables & Collections
-
Can you explain the purpose of the BIPUBLISHER_V view and how the IAU_AUDITUSER column fits into itSummary: Can you explain the purpose of the BIPUBLISHER_V table and how the IAU_AUDITUSER column fits into it SELECT iau_resource , IAU_TSTZORIGINATING, IAU_INITIATOR , …KHALED IHADDADENE 42 views 2 comments 0 points Most recent by KHALED IHADDADENE Reporting and Analytics for ERP
-
What is the difference between Apply of the filter and Refresh of the report outputSummary: We have built a report within a Subject Area, for which we have created a Dashboard. In this Dashboard, there is a section for the Prompt and a section displayi…AnnelizeHenskens 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Duplicated Job Definition not creating privilegeSummary: I am duplicating a delivered job definition and updating it to the custom report created. Based on documentation, it should create a privilege in order to grant…
-
Collection Note table?Summary: Collection Note table?! Content (please ensure you mask any confidential information): I am trying to find the table that stores the data for notes related to t…Robert of STAU 232 views 6 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
SQL - GL Balances for IntercompanySummary: Can anyone help, I understand with subledger queries I can filter to accounting_class_code = 'INTER', is there any equivalent means of getting ONLY intercompany…Robert of STAU 41 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Which table holds the error details for failed records from "Customer Credit Hierarchy" conversion?Summary: Hi Team, In order to get the details of loaded and failed records when building a custom Reconciliation Report (BIP) for "Customer Credit Hierarchy" conversion,…
-
Oracle BI Publisher Errors with "Replacing Invalid junk char with inverted question mark"So, I am developing a BI Publisher report in Fusion Financials with an etext template to generate output in a flat file csv format. I have done this 30+ times at least a…Robert of STAU 23 views 3 comments 1 point Most recent by User_PZBRW Reporting and Analytics for ERP
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…Shahid Qureshi 23 views 5 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…User_2025-03-07-21-11-01-091 260 views 9 comments 2 points Most recent by Vasu Ramarathinam Reporting and Analytics for ERP
-
Project Budgeting is done at resource level or task levelSummary: Hi experts, Is there a way or a flag or field which indicates if the project budget is done on the resource level or task level ? we are trying to identify that…
-
Historic table for EFF "ego_item_eff_b_" is timing out.I am writing a very simple query to see historical EFF data for an item and It is timing out when I tried to search with the inventory Item ID. What is the issue with th…Ramsha Zameer 11 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Product Master Data Management
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur…
-
BIP Bursting output with CSV fileSummary: BIP Bursting output with CSV file Content (please ensure you mask any confidential information): I am trying to burst a CSV file to an FTP server and I am havin…
-
trigger a Oracle HCM Cloud BIP report based on an onlineSummary: There is a requirement in our project that once a certain transaction is submitted in the system (Newly created candidates' security verification custom field o…
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account Content (please ensure you mask any …Uma Scherer 347 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Matrix Report with Pre-Defined Excel FormulasSummary: Once the report is downloaded if user modifies any value in a column then the dependent columns should recalculate the values based on the new value and excel f…Ripendra Kumar-Oracle 11 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 116 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP
-
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…
-
where is the sql pruning switch in data modelSummary: oracle doc says to turn off sql pruning when getting unsupported with in Data Model in BIP. Cannot find that switch in properties Content (please ensure you mas…Kevin Gherlone 11 views 2 comments 0 points Most recent by Kevin Gherlone Reporting and Analytics for ERP
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe…
-
Deep link for changes failed to navigate to open up the correct page. BI Publisher ReportI have created a deep link for the Change Order in my report, but the URL opens a blank page and does not work as expected. I tested it by hardcoding a Change ID, but ev…Ramsha Zameer 11 views 2 comments 0 points Most recent by Ramsha Zameer Reporting and Analytics for ERP