BI Publisher
Discussion List
-
Oracle BIP Report Not SummingI need your help in my RTF template that has a sum for every each segments. I added the field in the cell, set the Calculation to Sum and checked the Grouping. Generated…Sofia Danielle Sarmiento 29 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Splitting Of master detail records into new detail result if detail data exists more than 2k recordsSummary: Hi Team, We have a requirement to develop master detail report with master data set containing header level details of transaction and detail data set containin…Bhanu Priya 23 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to show the data label (Count) in all the colors of Stacked Bar Chart in the RTF Template?Summary: We have a requirement to display the number as data label in the RTF Template – Stacked Bar Chart. The count is being displayed only in one colour and it’s not …SARAVANA KUMAR T-Oracle 4 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Custom Report error out due to in put string ending with "."Hi - We have a custom report which uses XSL Stylesheet which errors out due to input string ending with "." which is a valid value. I would like to ask how we can modify…jhaira_18 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to send excel output to legacy systemHi, We have a custom ESS job and generates the output in excel format and can't enable it in csv format as it's exporting all the columns which we don't want. We have a …Madhu A 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
In Event Triggers: Alternative solution for passing multiple values into a single parameterIn event triggers, I need to pass a multiple values to a single parameter and upon research I realized that oracle does not provide such feature. I need a alternative so…navya Nallamotu 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential…Robert of STAU 55 views 8 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
็How to custom Trial Balance ReportSummary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential infor…Patumwadee 115 views 1 comment 0 points Most recent by community-dw-integration Reporting and Analytics for ERP
-
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …Kishore Kumar Reddy Bhushanam 66 views 1 comment 1 point Most recent by Lego Mathew-Oracle Reporting and Analytics for ERP
-
How to print "All" value in the output if BIP report is run for all parameter valuesHello Oracle Gurus, I have a requirement where the user is running the report with all parameter values. The parameter is Source. Currently if the user runs the report f…ShitalRamteke 695 views 8 comments 1 point Most recent by Sachin Dharmik Reporting and Analytics for ERP
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 3K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you! -
Hide Custom ESS Job Parameters LOV Seach FieldsHello, As the client requirement, we create a Custom ESS Job to run a BI Publisher Report. For this report, we need a few parameters, and for two of these parameters, ex…Arthur Teodoro 82 views 6 comments 1 point Most recent by Shashank_hegde-Oracle Applications Security
-
How to remove double quotes when getting output in csv pipe delimited from BI ReportHow to remove double quotes when getting output in csv pipe delimited from BI ReportLakshmiVanarasi 23 views 3 comments 0 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
Ability to get the Payment Approval Rule details defined on BPM by queries in Reports and AnalyticsIdea Number: 707234…Thomas De Leeuw 11 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
I need to find Frieght amount for purchase order line BI publihser sql,Summary: i am looking to figure out where freight amounrt for purchase order line is stored, can any one help me ? Content (please ensure you mask any confidential infor…
-
24C regression - scheduled reports are completing successfully for invalid email addressesSummary: Content (please ensure you mask any confidential information): If an invalid email address is provided as xyz@abc, Till 24B, the delivery was failing and delive…
-
BIP Data Source: Secure HTTP ConnectionSummary: While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching o…Pradeep Moganti 17 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
1Required The bank account suffix from Supplier site bank account Subject area OTBISummary: Required The bank account suffix from Supplier site bank account to enhance from exist supplier bank account subject area.. We have raised SR 3-38474138291 : CC…
-
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the view PAYROLL_FLOW that trigger a BIP report, but I'm unable to fin…
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…Sushan Peiris 1.1K views 2 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
Need the SQL query used in SaaS Service Usage Metrics ReportNeed the SQL query used in SaaS Service Usage Metrics Report (the one with PDF format extracted from MyServices) as we need to use it in a bursting program under BI Publ…
-
Insufficient space to include full field value in add help textSummary: For the BIP template trying to add a field to print the masked bank account number as below but it prints only upto…
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 1.2K views 8 comments 0 points Most recent by MangalThorat Reporting and Analytics for ERP -
Oracle will update BI Publisher-based notifications to Redwood-based BI Publisher.Summary: We have received the notification that in Oracle Fusion Cloud Update 25A, Oracle will update the few BI Publisher-based notifications to Redwood-based BI Publis…
-
How to Bind List of Values together so when either parameter is select the other auto populatesSummary: Wondering how to bind list of values together so that when a user selects one parameter, then the other is auto populated and then vice versa. So far all I can …
-
SQL Query for bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t… -
How to restrict schedule process page based on usersSummary: How to restrict schedule process page based on users Content (please ensure you mask any confidential information): Hi All, As of now who ever has access to sch…Venkatesan 33 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 35 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP