Category 129
Discussion List
-
FRS- Need to display the output in excel in different tabs for different branch valuesSummary: There is a requirement for an FRS report (Income Statement with Budget). Currently, when a user selects a specific branch (e.g., Deloitte Delhi) in the paramete… -
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 1.5K views 37 comments 21 points Most recent by Srinivas Chilakamarri Reporting and Analytics for ERP -
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…
-
Standard Reports that include transaction number and Receipt NumberI would like to know If there are Standard Reports that meet the following requirements. 1)include transaction number and Receipt Number. 2)I need to confirm the clearin…
-
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the …
-
FRS branch wise bifurcation for calculated fields like gross profit and percentageSummary: I am taking branch in rows. I need to display the gross profit data branch wise and percentage should also be calculated branch wise. Content (please ensure you…Tanya Matani 21 views 3 comments 0 points Most recent by Tanya Matani Reporting and Analytics for ERP
-
Do we have any WebService to display the list of reports in Oracle Fusion ?Summary: Hi Team , Do we have any WebService to display the list of reports in Oracle Fusion ? ** i have used the table : GL_FRC_REPORTS_B , but its of not much use - as…Sridhar Gupta Yerram-Oracle 1 view 1 comment 0 points Most recent by Ayala01 Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Tax Audit Trail Report export to excel doesn't have transaction num but html and pdf does have it.Summary: Export to excel different than html and pdf export. Anyone else have that issue? Content (please ensure you mask any confidential information): Version (include…
-
can we get the amount/numaric value in words in Polish language for OTBI ReportsGenerally we uses the function iby_amount_in_words.get_amount_in_words to display the amount/numaric value in words in English language for OTBI Reports. I would like to…Yugandhar2249 11 views 3 comments 1 point Most recent by Yugandhar2249 Reporting and Analytics for ERP
-
Connect Oracle Database Actions to Oracle Fusion ERPSummary: Connect Oracle Database Actions (SQL Developer Web) to Oracle Fusion ERP Content (please ensure you mask any confidential information): Are we able to connect t…
-
Date filter in rtf templateSummary: Hi All, Good Day! The template is in RTF . need to see the output in excel. Can anyone help on this ! Content (please ensure you mask any confidential informati…
-
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission…
-
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…Janitha Perera 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…Pranita S 1K views 7 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
Is there a report to show users' roles and privileges or what's table of them?Summary: We want a report to show users' roles and privileges or we can customize a new if there's no statndard process, but we don't know the table for these infoematio…
-
how to show alternate account GL combination in BIP report?Summary: User requirement to show alternate account GL combination but cannot find correct field. Content (please ensure you mask any confidential information): When vie…CarolineH 12 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe…Andy McIlroy 31 views 4 comments 1 point Most recent by Andy McIlroy Reporting and Analytics for ERP -
Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI ReportI am using below code in data model to convert UTC to MT in report output. But column looses formatting when exported in excel and used in Pivots. How to achieve the sam…DeepankarGera 3 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle 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 171 views 7 comments 2 points Most recent by MYNagendra Reporting and Analytics for ERP
-
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …Rory Mullin 117 views 5 comments 0 points Most recent by Alek Strader Payables, Payments & Cash Management
-
How to convert WD attachment in the rtf into table formatHi everyone I want to check if there is any possibility to convert the attachment from Work definition screen into table format. Below is the attachment being printed in…Mazher Shaikh 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there a query to get job board (e.g. LinkedIn, Broadbean) posting status?Summary: Is there an SQL query to get job board (e.g. LinkedIn, Broadbean) posting status for a specific job requisition? Content (please ensure you mask any confidentia…TomaszWyszomirski 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
forgetaccount utility not working for one of the userSummary: Hi All, I am trying to use forget accounts from this document and it is not working How To Run renameAccounts/forgetAccounts When User is Unable To Login to Ana…LC2502 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OIC Gen3 Services calling in Fusion by using BIP/ Groovy AuthenticationSummary: We are tying to consume the OIC Gen3 REST/SOAP services by using BIP/Groovy we are unable to call them." Error while processing authentication at Trigger. Faile…
-
Hello, I need help with SQL query joining 3 subject areasSummary: Hi, I need some help to verify my query. I'm trying to join 3 subject areas: "Workforce Profiles - Person Profile Real Time", "Workforce Performance - Performan…
-
Ability to create OTBI analysis calling a APISummary: Ability to create OTBI analysis calling a API Content (please ensure you mask any confidential information): Is it possible to invoke a custom API from OTBI to …Jepson Erattuparmbil 22 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
Launch OIC integrations from the Oracle Cloud ERP ESS job using oAuth authenticationSummary: Is there a way to launch OIC integrations from Oracle Fusion ERP ESS job using oAuth authentication Content (please ensure you mask any confidential information…
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP