Category 129
Discussion List
-
Our customer needs to identify the report path in OTBI related to an Infolet.Our customer needs to identify the report path in OTBI related to an Infolet. Please see the attached document (Infolet-OTBI.docx and HELP-OTBI-PATH.docx) attached here.…Oscar Chahestian-Oracle 8 views 0 comments 0 points Started by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 11 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Convert SYSDATE from UTC to the local timezoneSummary: Hi, I s there any way to convert the returned sysdate value from UTC Timezone to local TimeZone in Oracle Fusion BIP reports? We tried many recipes for that, bu…Taha.Elsisi 7 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Print receivables transaction Ess job bursting queryHi all, I have a requirement to edit the email body of the invoice email that is being sent after the ESS job has completed. As standard it is sending the email and the …
-
How can we see the Reports which are there in My folder of Other UsersSummary: We want to see the reports which are there in My Folder of all other Users. Is there any other way we can do this without logging into each individual user and …Shrikrushna 64 views 15 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
MSC_HVGOP_WEEKLY_ALLOC_REPORTSummary: How can i join this table with Item related Tables Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
Report combining Subject areas Project Costing - Actual Costs and Project Costing - CommitmentsHi, Has anyone created an OTBI report that lists all costs related to a specific project and the tasks designated to that project? I was able to get almost all the field…
-
How to use 2 subject areas in same formulaSummary: Using Analysis Report type, is it possible to have data from both subject areas in the same formula? Content (please ensure you mask any confidential informatio…Justine Klemetson 16 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for ERP
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
Issue with RTF Template – Pivot Table MergingSummary: we are using a Pivot Table to display invoice data for suppliers across different legal entities over a six-month period (from the given reference period). Issu…
-
Budget Override Request NotificationSummary: How to customize Budget Override Request Notification Data Model to enhance the Notification? Content (please ensure you mask any confidential information): Cur…Kalyani-Oracle 84 views 2 comments 0 points Most recent by Mohamed Bahgat AbdelFattah Budgetary Control
-
how can we remove Account Value from Account Description Column? From Inquire: On Details BalancesWe are facing a discrepancy when running queries in GL Detail Balances: General Ledger: Inquiry and Reporting > Inquire on Details Balances The account description colum…
-
Are there any roles to provide read-only access to a data model in oracle fusion?Summary: Hi, I want to provide read-only access to one data model to one of our users. Is there any roles or configurations that will help in providing read-only access …NagarajuKunchala 16 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Are there available audit reports to track master data changes?Summary: Client wants a report to track master data changes - customer, supplier, system configurations. Are there available seeded reports to cater to this requirement?…len.baetiong-Oracle 17 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe…Nicole Deleon 13 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to get FCCS data to BIP?We have a requirement to get data from FCCS, to create a BIP report. Is there a way to add FCCS as a data source in BI?Abhilash Baggam 12 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 26 views 2 comments 0 points Most recent by SRIKANTH DEVARASHETTY Reporting and Analytics for ERP
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
How to calculate EOD balance for the last day of Previous month based on accounting date in OTBII'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis. Sub…Sri Sai Kiran Tekumudi 46 views 2 comments 0 points Most recent by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP
-
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti…
-
How can we identify the list of BIP/scheduled reports that are currently being transmitted to FTPSummary: We need a list of reports from Fusion that are currently being transmitted to the FTP server as part of the requirement to transition to a more secure SFTP serv…Naga Peddiraju Chennu 44 views 3 comments 0 points Most recent by Viraj Padwal-Oracle Reporting and Analytics for ERP
-
Customization of Standard Contract Preview ReportSummary: Hi Team, I am writing to request guidance on a customization for the Standard Contract Preview Report(Enterprise Contracts --> Contract Printing --> Contract Pr…Saumya Mani Tripathi-Oracle 40 views 2 comments 0 points Most recent by Saumya Mani Tripathi-Oracle Reporting and Analytics for ERP
-
Do we have any option to download CSV File - rather than getting displayed in browser output ?Hi team, Do we have any option to download CSV File - rather than getting displayed in browser output ? Our data output file size is more than 100 MB , we want to downlo…Sridhar Gupta Yerram-Oracle 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Need Sample and Confirmation of AnalysisSummary: Hi We have requirement to create analysis of procure to pay process (PR-PO-Receipt-Invoice-Payment). We need your help to give sample how to create analysis wit…
-
ZATCA verified XML embedded inside PDF outputSummary: We have a requirement to embed ZATCA verified XML inside Invoice PDF output. When user runs the report this XML should be attached within the PDF. Content (plea…S Usman ali 16 views 0 comments 0 points Started by S Usman ali Payables, Payments & Cash Management
-
How do i know which field in the fusion frontend is related to which table column in backend?Hi Experts I am new to BIP report development. Customer sometimes just give screenshot from fusion and ask to create report with those field . Is there any way where i c…Mainur-Oracle 13 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to link GL journals to external cash transactionHi Team, I would like to create a custom BIP report to link GL journals to external cash transaction. How can I trace back from GL journal to external cash transaction? …
-
Excel template - with CSV Output -- Do we have an option to hide parameters ?Hi team, Excel template - with CSV Output -- Do we have an option to hide parameters ? -SridharSridhar Gupta Yerram-Oracle 22 views 3 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Excel template- Why the column header is not copied into other sheet- for rec# > 65KHi team, When the output has more than 65K records - Excel output is getting generated with multiple sheets, but only the first sheet has column name, remaining sheets d…Sridhar Gupta Yerram-Oracle 2 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP