Reports
Discussion List
-
Inconsistent running time of BIP reportsHello Everyone, We have an existing Custom BI Report that we are monitoring, running this report thru Scheduled Jobs 10 times to check how long this report run. Sometime… -
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 8 views 0 comments 0 points Started by Sofia Danielle Sarmiento Reporting and Analytics for ERP
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management -Oracle 134 views 3 comments 2 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Connect GL Location Segment to Location AddressHi, we have Locations in Oracle we need to associate with the Location Segment in the GL Account String. Scenario: We have Account Aliases we are using to decrement our …Becca Edwards 33 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Deeps links for payable invoicei want to create a payable report when i click on invoice number open a new windows have the invoice deatils i want a deeps link for the payable infoices
-
Unable to select parameters in a Manage Job SetWe want to create the Job set and with job parameters itself so that every time we run the job set, we do not have to fill the parameters again. Can you tell us how we c…
-
Can we get the UCM file download link in BIPHI All, I'd like to build a report with UCM file name and download link. SQL can extract file name and file id. But how can I get the file download link? Thanks in advan…
-
Need to fetch the amount( Debit - Credit) from XLA tablesSummary: Need to fetch the amount( Debit - Credit) from XLA tables Content (please ensure you mask any confidential information): We developed the query to fetch the amo…
-
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the …
-
FRS - Option to get the 'Prompt' of the COA segment in the POV instead of the segment nameSummary: Hi All, We had a requirement to change the segment name of the Future segment. Since it had multiple implications as suggested in the forum we have only changed…Vipusha Chandrakumaran 7 views 0 comments 1 point Started by Vipusha Chandrakumaran Reporting and Analytics for ERP
-
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 33 views 3 comments 1 point Most recent by Shashank_hegde-Oracle Applications Security
-
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each …
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 19 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Trial Balance Report IssueIn Report credit side are just totals wherein it should have been broken according to each related account, like shown in the debit side, below is the 2 SS with wrong on…Vivek Makwana - Finance 9 views 0 comments 0 points Started by Vivek Makwana - Finance 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 383 views 22 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 2.4K views 14 comments 0 points Most recent by Charan K Reddy Reporting and Analytics for ERP
-
Is there a way I can concatenate addresses in HZ_LOCATIONS?In EBS, you could call a package (hz_format_pub.format_address()) which would concatenate the address elements when passed the location_id as an argument respective to t…Innovate.Matt 11 views 2 comments 1 point Most recent by Innovate.Matt Reporting and Analytics for ERP
-
How can I replicate data from a pivot table in an RTF report (BI Publisher)?I have a report for transaction build using BI publisher what is giving is the customer X is shown just once with multiple transaction what i want is to have the custome…
-
Is it possible to develop BI report to fetch data from VBCS pageSummary: Is it possible to develop BI report to fetch data from VBCS page Content (please ensure you mask any confidential information): Hi All, Is it possible to develo…
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
Print Receivable Transaction not generating output for Intercompany invoicesSummary: Print Receivable Transaction not generating output for Intercompany invoices Content (please ensure you mask any confidential information): Hi All, Why Print Re…
-
Query to find instance refresh /clone date in FusionContent Hi All, Like we used to have below query in EBS to get instance clone date , what table is used in fusion. SELECT resetlogs_time FROM v$database; Any help is rea…Nidhi Chhajed 2K views 7 comments 0 points Most recent by User_TYNC0 Reporting and Analytics for ERP
-
Oracle Procurement Punchout Definition tableNavigation - Procurement - Catalogs - Manage Catalogs - Punchout Catalog We are trying to build a bip report to query all the punchout catalog information. We are not ab…
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
Sorting in eText templateSummary: We have a requirement to sort data based on a tag from XML using eText template Content (required): In eText we can sort based on tags but here we have to sort …
-
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…Sudha KOVURU 194 views 6 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
Is there a way to predefine calculations in oracle cloud ERP for FRS reportsMost of our Financial reports built using Oracle FRS Web studio are driven by calculations. Managing custom reports becoming more and more difficult whenever there is a …Priya Mandava 32 views 2 comments 0 points Most recent by Priya Mandava Reporting and Analytics for ERP -
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…mmjohnson0522 44 views 7 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for ERP
-
BICC PVO Join ConditionsSummary How do we define joins between PVOs and is there any easier way of doing joins between PVOsContent On the older version of EBS one could have written their own q…Upendra Nayak 464 views 5 comments 3 points Most recent by CSINGH_KCC Reporting and Analytics for ERP -
How to join requisition and purchase order tablesI am using POR_REQUISITION_HEADERS_ALL and PO_HEADERS_ALL to get requisition data and related po data if present. But there is no join between given tables. Please sugge…