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
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i… -
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust…
-
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…
-
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi… -
FRS report is going into error after migrating to UAT instanceFRS report is going into error after migrating to UAT instance. The migration was done by two different methods. 1. Archiving from SIT and unarchiving to UAT. 2. Exporti… -
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…
-
BI Cloud Connector (BICC) do all incremental last_update_date columns need to be selected for PVOSummary: When there is more than one last_update_date object included in a PVO should all be included/selected for the extraction file. For example, with most of the 'vi…
-
Why do some scheduled processes have an External Job Status of WAITINGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …
-
Cloud ERP Guided Path and Configuration Best PracticesSummary Provides a guided path of Oracle ERP Cloud resources (documentation) and best configuration practicesContent Guided Path: Highlight key Oracle resources/best pra…G.Brett Beaubouef, PMP, CISA, ERP Author 287 views 9 comments 10 points Most recent by Soumya Prakash Parhi -
Industry field for otbi subject aresSummary: Please help in getting industry field for otbi having subject ares: 1.order management-fulfillment lines real time 2.order management-order headers real time 3.…
-
LACLS It is possible that DDF used in localization can be defined at the global attributes level?We are configuring the localization for Peru and have found that many of the descriptive fields are already in use by other companies operating in the system, so we have…
-
BICC Downloading Files from UCMSummary: We are investigating using BICC to schedule extract from Oracle ERP rather than relying upon our existing process of using Custom BI Publisher Reports then burs…
-
Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amountsSummary: Payables Invoices –Transactions Real Time Subject Area is not returning correct The OTBI Report with subject area Payables Invoices – Transactions Real Time has… -
Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amountsSummary: Payables Invoices –Transactions Real Time Subject Area is not returning correct The OTBI Report with subject area Payables Invoices – Transactions Real Time has…
-
Enable All or Multiple selections from a Pivot Table prompt in OTBISummary The Pivot Table prompt should allow the selection of all or multiple items.Content We have a requirement to allow the selection of All or multiple items from the… -
Is there a way to identfy open subledger transactions in the general ledger?Summary: We have a custom report requirement to extract account balances for specific accounts for open transactions only. These are either receivables or payables that … -
Financial Reporting Studio Report displaying Error when no data is foundSummary: Financial Reporting Studio Reports fetching #Error when no data is found. We don't want want to suppress the column or row, rather want to display the value as …
-
Tax Registration from Supplier Address out of Supplier Real Time OTBISummary Looking for Supplier's Tax Registration Linked to AddressContent I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempt… -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m… -
Need details on PVO: FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVOWe would like to request additional information regarding the PVO FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVO. Specifically, we are seeking clarity on the followin…
-
oracle cloud erp frs reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…
-
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r… -
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…
-
How to Obtain History of Last Updated Date and Owner for ReportsSummary: How to Obtain History of Last Updated Date and Owner for Reports Content (please ensure you mask any confidential information): Is there a way to obtain a list …
-
Equivalent Standard AR Report not available in Fusion although Business uses standard reports in EBSEquivalent Standard AR Report not available in Fusion although Business uses standard reports in EBS - Need Oracle confirmation on the availability of standard Fusion AR…
-
Unable to link multiple subject areas in OTBI reportHi, I created an OTBI report with PO and Invoice details such as PO number, PO lines, PO amount, Invoice number, Invoice amount, Transaction currency and Ledger/Accounti…