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
-
Is it possible to have manual input option with LOV menu?Summary: Researching the ability to manually input bulk values while keeping LOV search functions. Content (required): When you open the search box for dropdown paramete… -
Delivered Asset Transaction History Report runs to error if From/To Asset fields are blankSummary: If we run the Asset Transaction History Report, and only entering the required parameter of Asset Book, it runs to Error within a minute. The "From Asset" and "…
-
How do I manage, see, & edit existing scheduled BI Reports I set to run monthlySummary: I have 5 BI Reports that I've scheduled to run every month. I used to be able to see/edit the list of my scheduled reports in the "Report Jobs" link in the left…
-
How are you managing OTBI AgentsSummary: We have some analysis/dashboards that we want to schedule and send out as specific times using agents. Question is there any best practices around the managemen… -
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…
-
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…
-
The business unit doesn't take the legal entityContent (required): I want to make the "assign business functions" for the configuration to "procurement" but when I try to put the "primary ledger" I can't take the cor…
-
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…
-
BICC - How do you remove a datastore/pvo from a job?Summary: How do I remove a datastore from a job; disassociate it. I have a custom offering where I had added a datastore/pvo that I no longer want included in the job th…
-
Year-End closing processSummary What are the Year-End closing processes best practice?Content We are in the process to close the year in the system (for the first time) wondering what are the Y… -
Account Description is as the code in General Ledger Analysis and error when the columns are addedSummary: Content (required): Trying to build up an analysis report but when extracting the account description it is the same as the account code. But in the value sets … -
Allow Scheduled Jobs to send to a distribution ListContent We would like to be able to send job failures to a group of people instead of individuals on Job notifications. This is needed for these reasons: 1. Oracle doesn…
-
Document Number in OTBI Receivables - Transactions Real TimeContent I am building an OTBI report using Receivables - Transactions Real Time, and I'm looking for the column for 'Document Number'. Does anyone know if this column is…
-
OTBI - Convert Entered Amount to USD for Non Usd LedgerSummary: Is it possible to convert an Accounted Amount to USD for Non USD Ledger in OTBI (General Ledger Journals Real Time)? Content (required): I have business require…
-
Need the table name for SOA Suite Audit Policy configurationSummary: There is a bug in the Transaction Console that allows someone to enable / disable approvals via the Bypass Approvals and this activity is NOT included any of th… -
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly excuted) Is there any way to find. Thanks -
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…
-
OTBI_EXM: No data for Transaction/Billed/Posted Amount Columns on corporate card expenseSummary: When querying corporate card expenses that have not been added to an expense report, no data is populated for fact columns Transaction Amount, Billed Amount, an…
-
In OTBI Report, can we have details in single row per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?… -
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB… -
Is there a report that shows how a workflow was approved?Summary: Requirement is to see the how many users approve in the application versus workflow email Content (required): Version (include the version you are using, if app…
-
How to properly use an excel function in an rtf template?Summary: I added an excel function in my RTF template but when the report is created in excel it shows the function and not the result of the function. Is there an solut…
-
How to audit the consumption of reportsHello, Is there a way we can view who is consuming OTBI and BIP reports? is there some sort of usage stat or which user is running the reports? Many thanks, James
-
R13 Higher Ed and Public Sector Cloud OTBI subject area to database lineage mapping spreadsheetSummary: This spreadsheet documents R13 Higher Education and Public Sector Cloud OTBI subject areas to database lineage mapping and subject area security Content: This s…
-
BI publisher report show blank pageSummary: Hello i have customize report in BI and this report is work perfect with all user using windows and Firefox browser , but have one user is have MAC and Safari b… -
Uploading to BI keeps loadingSummary: Specifically in Firefox browser, whenever I upload something (layout, datamodel, report,..) the loading popup keeps loading and doesn't do anything. Content (re… -
OTBI - General Ledger - Data extraction of Journal description details not populating for some linesSummary: OTBI - General Ledger - Data extraction of Journal description details not populating for some lines Content (required): A query is used to extract data from OT… -
User does not see a delivered reportSummary: User does not see a delivered report Content (required): User clicks on Schedule New Process, and types "Reserve". She only gets results for the Reserve Detail …
-
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Display Report Job ID INSIDE the BIP ReportSummary: Display Report Job ID INSIDE the BIP Report Content (required): Is there any way we can display the "Report Job ID" INSIDE the BIP Report? or use it in the burs…