BI Publisher
Discussion List
-
Need a table or query to get Latest open period column in Manage Intercompany Period StatusSummary: Hi Support, We need a table for the column's "Latest open period" and "Open Transactions" under the setup Manage Intercompany Period Status. We have the table F… -
BIP Bursting report failsSummary: Creating a report that will be emailed (bursting) to employees that have outstanding PCard charges that need to be added to a report for reconciliation. The rep…Kaz Myskiw 106 views 9 comments 0 points Most recent by Cosmin Foslea Reporting and Analytics for ERP
-
Exist a report that show all page composer in the ERP?Exist a report that show all page composer in the ERP?Cristian Gonzalez S 4 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is…
-
Is there any way to send UCM file to email/sftp though bursting ?Hi All, I would like to send the attachment of negotiation messages to others. I can get the document id of the attachment( non-pdf) in UCM, Is there any way to send the…
-
Blank pages in my BIP ReportSummary: Student Statements with 0 balances printing blank page Content (please ensure you mask any confidential information): I have developed a custom student statemen…
-
How to change newline characters in BIP reportI have created a BIP report using RTF template. When exporting the report to CSV, the newline character is line feed, but I want to make it carriage return and line feed…
-
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss https://commu…
-
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 23 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
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 … -
Feasibility Check and Help for a OTBI ReportSummary: I am creating a new OTBI Dashboard for the Payroll Reconcillation Details. The Dashboard will have multiple sections including 2 waterfall charts and once pivot…VaibhavChavan20_ 5 views 0 comments 0 points Started by VaibhavChavan20_ Payroll and Global Payroll Interface (GPI)
-
Download Excel template BIP Report using SOAP Web ServicesThere was an error rendering this rich post. -
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 276 views 10 comments 1 point Most recent by Ankur Jain--Oracle Reporting and Analytics for ERP
-
RTF Template with multiple sheetsSummary: RTF Template must push out results in Excel with mutiple sheets Content (please ensure you mask any confidential information): I have put in place a rtf templat…Chez 597 views 4 comments 0 points Most recent by Ankur Jain--Oracle Reporting and Analytics for ERP
-
Need the mapping of Job Application Names EarHcmEss and FscmSummary Need the mapping of Job Application Names EarHcmEss and FscmContent We have a requirement to create a custom report of the ESS Job Execution details. We want to …Vinay Gharge 63 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP Bursting - Zip Multiple text/csv files and burst to Content serverSummary: Hi All, We have a requirement to push zip files (multiple text/zip files) to UCM. This has to be accomplished in Oracle ERP Cloud SAAS tools. Please let me know…
-
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an…
-
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 94 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 12 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 882 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 35 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 91 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 13 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 291 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 45 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany