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
-
1099 Data ReportContent Are you reporting 1099 data based on accounting date or payment date? -
Logiacl sql for cross subject area analysisSummary Logiacl sql for cross subject area analysisContent Hello All, I am trying to create a cross subject area logical sql for receivables as below. However I still ge…
-
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…
-
OTBI usage tracking in 21ASummary OTBI usage tracking in 21AContent In this new subject area below, will that only track usage within the CRM subject areas or will that track report usage in the … -
SOAP request for BI Publisher report works for Test pod but not for Production podSummary SOAP request for BI Publisher report works for Test pod but not for Production podContent I am running BIP report by using SOAP request. the problem is that it w… -
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
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… -
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…
-
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI… -
ESS Schedule Process Job Name not availableSummary ESS Schedule Process Job/Program Name not able find any tableContent Hi All, We need to build a BIP Report for audit purpose with all ESS job details but unfortu… -
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.
-
Direct vs In-direct suppliersContent All - How to identify in Oracle Procurement cloud the direct vs in-direct suppliers? Also is there a field in OTBI that can tell direct vs Direct suppliers? I se…
-
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? -
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 …
-
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 -
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…
-
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…
-
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…
-
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 … -
Report on LicencesSummary Self licence audit processContent Hi All, I have a report that shows me the Users by Service we are subscribed to, but I am wondering if anyone has put together …
-
ERP – Introducing U.S. Federal Financials, 13 January 2021, 8 a.m. PT - Submit QuestionsContent Submit your questions for the ERP – Introducing U.S. Federal Financials session to have them answered during the live event. Post your questions by posting a new…Maria Centeno-Cloud ERP-Oracle 31 views 2 comments 3 points Most recent by User_2025-02-10-19-28-21-270
-
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…
-
Stop Email Bursting on Lower EnvironmentsSummary Prevent Seeded Process to Send EmailsContent Hi Experts, Need Help!! Recently we had got Production environment cloned to Test, so the data was also occupied, Th…
-
Ability to Act as another user in OTBISummary In OBIEE on premise we have the capability to 'Act As' another user is this available in OTBIContent Wanted to find out if anyone knows if the ‘Act As’ functiona… -
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…
-
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 ?