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
-
Need number of asset transfers and modifications in 2020Content Hi, I need to find the total number of asset transfers and modifications made in 2020. Is there a BIP query that can return this information please? regards Nige… -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share. -
Is there a way to specify the e-mail destination when running a job from REST to BI Publisher?Content Hi, I am looking for a REST to specify the e-mail destination when running a job from BI Publisher? Is there some document or samples can refer to? Thank you so … -
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Substring Function in FRSContent Is it possible to use a Substring function in FRS reports? We have a requirement to Substring the Cost Centre values on one of our reports so I was just wonderin…
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
Table name of Remit to AddressContent Hi, When I look for remit to address for a country I get the details populated as in screenshot please let me know the underlying table name associated. Thanks -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
Updating non-logical OTBI to Logical SQL OTBI without rebuilding?Summary Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?Content I need to update an existing OTBI (non-Logical SQL) to use Logical SQL…
-
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the … -
ERP – Oracle Digital Assistant: Investment Strategy Update, 03 February 2021, 9 a.m. PT - Submit QuContent Submit your questions for the ERP – Oracle Digital Assistant: Investment Strategy Update session to have them answered during the live event. Post your questions…
-
Defaulting current month on reportsSummary A request has been made by our users to default the current month/date on report.Content Our issue is that the users have to hunt for the current period on a lis…
-
Physical or Soft Deletes handled in PVO DataSummary How are Physical or Soft Deletes handled in PVO Data ? Does it comes as a flag/identified along with incremental extract so that it can be deleted in the target … -
OTBI analysis timeoutContent Hi, we have a customized OTBI analysis report in sharefolder. Some users could run the report successfully serveral months ago, but recently they can't get the r…
-
BICC PVO Join ConditionsSummary How do we define joins between PVOs and is there any easier way of doing joins between PVOsContent On the older version of EBS one could have written their own q…
-
API to Manage Objects in BI CatalogSummary API availability to upload or download BI Catalog objectsContent Is there any working example of managing BI Catalog objects in terms of uploading and downloadin…
-
Add a custom calculation columnSummary I want to add a couple of columns into my analysis which contain custom formulasContent Hello, I am sure this is a very simple answer but I was hoping someone wo…
-
Do we have the same/similar reports from fusion cloudSummary Do we have the same/similar reports from fusion cloudContent All, Do we have the same/similar reports from fusion cloud Miscellaneous Receipts Register EBS R12 R…
-
Rx-Only: Other Receipt Applications ReportSummary Rx-Only: Other Receipt Applications ReportContent Hi All, Do we have the same/similar "Rx-Only: Other Receipt Applications Report" from fusion cloud.?
-
Receipts Awaiting Bank Clearance Report in EBS R12Summary Receipts Awaiting Bank Clearance ReportContent HI All, Do we have the same/similar functionality report as "Receipts Awaiting Bank Clearance Report" from EBS in …
-
Miscellaneous Receipts Register EBS R12Summary Do we have any standard report for the same from oracle fusion cloud.Content Hi All, Do we have any standard report for the same from oracle fusion cloud. for Mi…
-
query to get ar receipt reversal reason nameContent when i reverse receipt.i entered a reason i need a query to get a reason name
-
get balance for each rowContent invoice amount receipt amount balance 100000 30000 70000 40000 30000 30000 0 how can i get balance value using bi ?
-
Unable to edit scheduled processSummary Unable to edit scheduled processContent Hi, I have a couple of processes scheduled to run daily from February 2020 until February 2021. Since the schedule was se…
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr…
-
Best Practice for implementing Financials and then HCMContent My organization has decided to implement Oracle ERP Cloud Financials prior to Oracle ERP Cloud HCM. What considerations should be taken to ensure our minimalist …
-
Report timeoutContent Hi, One BI report is timing out in the shared folders. But the same report is completing perfectly fine in local folder. Any suggestions? Thank you. Added the be… -
Pass parameters from excel to BI Publisher reportSummary Pass parameters from excel to BI Publisher reportContent Hi, I run BI publisher report directly from excel by using soap and it works ok as long as i don't use a… -
Listing of all FIN reports in foregin languageContent Hi, Can someone let me know where we can find full list of reports ( jobs) available for Financials offering but with translation on Russian Language? When loggi… -
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust…