To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Report Logo broken in Gmail but working in OutlookSummary: We are inserting the client logo for the Disbursement Separate Remittance Advice Report and it is working with Outlook but it is broken when being opened in Gma… -
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. … -
Unexpected Automatic Submissions of "ESS Job for Bulk Ingest to OSCS"We have observed that the "ESS Job for Bulk Ingest to OSCS" is being submitted multiple times daily by various users. Upon checking with several of the listed users, the…
-
Multiperiod Accounting invoices amortization detailsneed help in getting details of MPA invoices, query to get details of MPA Invoices with1) Monthly amortization amount 2) Current Month amortization amount 2) Accumulated…
-
Do we have any subject area for custom role creation start and end dateSummary: Do we have any subject area for custom role creation and end date Content (please ensure you mask any confidential information): Do we have any subject area for… -
otbi procurement subject areaSummary Has any one used procure to pay real time and pruchasing real time subject area togetherContent I am trying to get po number ,invoice number from procure to pay …
-
Missing Mapping for Attribute_Number1 from FUSION.GL_JE_LINES Table to BICC GL_JE_LINES PVOWe are unable to map the ATTRIBUTE_NUMBER1 column from the Fusion GL_JE_LINES table to any column in the BICC Journal Lines PVO (FscmTopModelAM.FinExtractAM.GlBiccExtrac…
-
Hi, does anyone have a query on how to pull invoiced and non-invoiced receipts?Hi, does anyone have a query on how to pull invoiced and non-invoiced receipts?
-
Trial Balance ReportTrial Balance Report output is blank, although balances can be seen in Account Inquiry Details UI -
How to create Custom ESS Job for a Schedule integration from FusionI am trying to create a Custom ESS job in Oracle fusion by creating report for a schedule integration. But not able trigger the integration with the Report. Please let m…
-
Which table contains the email addresses for users who log in to the Supplier Portal?Summary: Dear Experts, I would like to obtain the email addresses of users who log in to the Supplier Portal using SQL. However, I could not identify the correct table t…
-
What are the solution options for Audit Trail for Spend Classification?Summary: We need to have an Audit Trail for Oracle Fusion Cloud Procurement > Spend Classification. Oracle doesn't include the Spend Classification product as part of Ma…
-
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… -
Is there a Standard report in Oracle Cloud for ECD in Brazil? Does it show the previous year's?Summary: Is there a Standard report in Oracle Cloud for ECD in Brazil? If so, does it show the previous year's operations? What to do when starting to use the platform? …
-
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR… -
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
Embed OIC Monitoring Dashboard into OTBI DashboardSummary: Content (please ensure you mask any confidential information): Is it possible to embed the OIC monitoring dashboard on an OTBI dashboard? Version (include the v…
-
ESS Job (Copy of Accrual Reconciliation Report) throwing warning Too many matching records found."Hi, We have created a new ESS job by simply copying seeded Accrual Reconciliation Report. We did not touch any parameters and kept them as it is. We have just enabled bu…
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
How to Check PPR Approval History from AP Payment ScreenSummary: How to Check Payment Process Request Approval History from AP Payment Screen Content (please ensure you mask any confidential information): Version (include the…
-
Is there a way to dynamically rename split rtf files using PDFZ output?Summary: We have a requirement to rename the individual pdfs that get generated from an .rtf report in BIP. I think I am "close", but I can't seem to get the XML tags co… -
How to ensure date columns in BI Publisher Excel output use date filters instead of text filters?Our customer wants to download online versions of reports in Excel format, next they will be applying filters on the table for deeper review and analysis. There are mult…
-
Setting Tab Names in Excel When Downloading an FRS ReportSummary Setting Tab Names in Excel When Downloading an FRS ReportContent I have 60+ Company (Balancing Segment) values. When I generate a report in FRS and then download… -
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…
-
How to access the sample XML for the Printable Expense Report Template?Summary: I need to customise the Printed Expense Report Template to suit client's requirements. I understand that the seeded report does not have an associated Data Mode… -
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… -
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…
-
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…