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
-
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…
-
List of all seeded reports for SCM , Procurement and Procurement contractsI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…
-
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 … -
Not able to create a custoemr with Jan 1900 as starting date in PROD environmentSummary: When we create a customer in TEST and other non‑production environments, we’re able to use 01.01.1900 as the start date at party, Account and site level, withou…
-
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 …
-
How to schedule BIP report in application composer ?Summary: I would like to use the application composer to schedule a BIP report I have defined the (https://****/xmlpserver/services/ScheduleReportWSSService?WSDL ) webse…
-
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…
-
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…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…
-
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?