BI Publisher
Discussion List
-
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 11 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 53 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 65 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 32 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 436 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 826 views 6 comments 0 points 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 76 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 22 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 13 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 12 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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…Siv 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 805 views 5 comments 1 point Most recent by User_4LY05 Reporting and Analytics for ERP -
BIP Bursting is not delivered the emails to DLsSummary: Bursting emails from a BIP report are not delivered to any of the email ID's part of DL list, even though the Report Job History/Output & Delivery section indic…Priyanka_Ghosh 133 views 6 comments 2 points Most recent by Apeksha Mayekar 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 889 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… -
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 …
-
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 895 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 34 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 12 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP