Reports
Discussion List
-
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 3 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 32 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 17 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 1 view 0 comments 0 points Started by Vivek Makwana - Finance 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 15 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 197 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 33 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…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 25.9K views 91 comments 54 points Most recent by ravinat 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.2K views 52 comments 20 points Most recent by Ifeanyi Katchy-Oracle Reporting and Analytics for ERP
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…dennisepanopio 12 views 0 comments 0 points Started by dennisepanopio Reporting and Analytics for ERP
-
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…Abdullah Munaz 19 views 0 comments 0 points Started by Abdullah Munaz Reporting and Analytics for ERP
-
Create Customer StatementHi All, while calling Create Customer Statements ESS job same We Have requirement to pass 'cycle' and 'generate bill parameters' into Statement Generation Data Model. /s…
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 7.7K views 154 comments 44 points Most recent by Bob Sheldon-Oracle Reporting and Analytics for ERP -
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …marc.joed.de.guzman 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
System Accounts from per_usersSummary How to identify system accounts like FUSION_APPS_SEARCH_APPID from per_usersContent Hi Is there a way to query and get a list of system accounts like FUSION_APPS…Manish Mohan-96908 55 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…