BI Publisher
Discussion List
-
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 3 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP -
Purchase Order PDF report issueHi Team, We have customization in Purchase Order PDF report by adding customer logo and also setup the confirmation in configure procurement Functional business unit tas…Chanikya Neelam-Oracle 7 views 2 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for ERP
-
How to create Custom ESS Job for a Schedule integration from FusionI am trying to create a Custom ESS job in Oracle fusion by creating report for a schedule integration. But not able trigger the integration with the Report. Please let m…Harsha Karanam 5 views 0 comments 0 points Started by Harsha Karanam Reporting and Analytics for ERP
-
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…
-
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 185 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 3.9K views 54 comments 20 points Most recent by User_48JZP Reporting and Analytics for ERP
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …
-
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…Shireesha 33 views 7 comments 0 points Most recent by SrinivasaRao Davuluri Reporting and Analytics for ERP
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 135 views 5 comments 0 points Most recent by Angela Valcelli Reporting and Analytics for ERP
-
How can I edit parameter in standard ESS job?Summary: I want to edit (hide/remove/default to a specific value) the parameters of a standard ESS job. Please share steps to do it Content (required): Version (include …Priyal Pareek 613 views 2 comments 0 points Most recent by User_W68FG Reporting and Analytics for ERP
-
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem…
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Project Comments in query output FormattingSummary: User created a comment on Project level (might have been copy pasted from some other source), when a sql is written to extract the information, it has all sorts…
-
Need to enable GL Date From and To as parameters in Account Analysis ReportSummary: Need to enable GL Date From and To as parameters in Account Analysis Report Content (please ensure you mask any confidential information): Account Analysis Repo…Deepa Lakshminarayanan 41 views 2 comments 0 points Most recent by Nathanieal General Ledger & Intercompany
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 12 views 3 comments 0 points Most recent by Andres Celis-Oracle Reporting and Analytics for ERP
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 5.7K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP
-
Timezone - BIP Report schedule defaultSummary Timezone - BIP Report schedule defaultContent Hello All, When we schedule any BIP report, in Output tab we noticed that below is the default timezone for all use… -
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 651 views 3 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…JayaramK_yash 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Hi All, Can you help me with SQL Query for BIP Report Status and report name?Hi All, Do we have any SQL query for BIP Report Status ,report name and report history and the status of the Report?Sunil Kumar C 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…Jepson Erattuparmbil 11 views 2 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for ERP
-
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…Khushi 31 views 2 comments 0 points Most recent by Antima Rai-Oracle Reporting and Analytics for ERP
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil Makhiza 468 views 25 comments 0 points Most recent by NeenaS25 Reporting and Analytics for ERP
-
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …user12232237 115 views 7 comments 0 points Most recent by User_WAU4B Reporting and Analytics for ERP
-
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…Sean-B-01 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany