Category 129
Discussion List
-
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 …Dian Minshan 42 views 1 comment 0 points Most recent by Dian Minshan Reporting and Analytics for ERP -
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…Hannah Dorman 235 views 2 comments 0 points Most recent by Hannah Dorman Reporting and Analytics for ERP -
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…Jeff Hare CPA CISA CIA 12 views 2 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
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. ThanksMohammed Rafi 32 views 2 comments 3 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
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…Jeff Hare CPA CISA CIA 12 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP
-
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?…Rahul Kumar Gupta.-Oracle 31 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
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…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
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…Anthony Cambria 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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…Geert Buyckx 31 views 3 comments 0 points Most recent by Geert Buyckx Reporting and Analytics for ERP
-
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, JamesJames Coles 32 views 2 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
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…Noelle Bartlam-Oracle 349 views 0 comments 1 point Started by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
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…Mahgoub S.Mohamed 95 views 6 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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_2025-02-04-15-40-21-120 51 views 0 comments 0 points Started by User_2025-02-04-15-40-21-120 Reporting and Analytics for ERP -
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 …Brad Kirschner 11 views 5 comments 0 points Most recent by Brad Kirschner Reporting and Analytics for ERP
-
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…Vinay Gharge 116 views 2 comments 0 points Most recent by Vinay Gharge Reporting and Analytics for ERP
-
Download BIP Output based on Report Job IDSummary: Download BIP Output based on Report Job ID Content (required): Is there any API to download the BI Publisher output in XML format based on the "Report Job ID" w…
-
Payables Invoices - Withholding Real Time - OTBI Not getting resultsSummary: Payables Invoices - Withholding Real Time - OTBI Not getting results Content (required): We are tying a build a quick OTBI analysis on the seeded subject area P…Balachander G-Oracle 72 views 0 comments 0 points Started by Balachander G-Oracle Reporting and Analytics for ERP
-
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 42 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Attempting to Extract GL Journal Workflow ApproversSummary: Asking how to access the workflow metadata around assigned approvers in Oracle ERP. Content (required): I am attempting to create a report with BIP that extract…Jonathan Keller - UCD 14 views 0 comments 0 points Started by Jonathan Keller - UCD Reporting and Analytics for ERP -
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…Dian Minshan 1.3K views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
Which table will hold the information of period of an Asset BookSummary: Which table will hold the information of period of an Asset Book Content (required): Which table will hold the information of period of an Asset Book Version (i…Lydia Jayasingh 12 views 4 comments 0 points Most recent by Lydia Jayasingh Reporting and Analytics for ERP
-
I need a query to obtain Review Budgetary Control Balances screen informationSummary: I am kind of new with Oracle fusion budget control module and We require to create a report where We need the information that appears in the Review Budgetary C…Robinson Antunez 1.3K views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Send remittance advice report querySummary: Send remittance advice report query Content (required): We want to customize send remittance advice process. And we need the seeded report data model query acce…Priyanka More-Oracle 107 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …Swapnil Kashid 72 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
LOV for Analytics show nullSummary: Hello, i have analytics report read from general ledger transaction real time subject area this report is request from HCM user he need information about overti…Mahgoub S.Mohamed 21 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Last closed period in Fixed Assets - Transactions Real timeSummary: There is no data in the fact column "Last closed period" in the subject area Fixed Assets - Transactions Real time. Content (required): We do have some closed p…Anders W. Langholm 11 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Report Time out IssueSummary: There is an issue on report execution time out. When a long period report run on any finance side. Then after sometime an error occured on time out. Same report…Rohan Raghuvanshi 42 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Error while joining"Journal Batch" from GL Subject area with Receivable subject areas Fields in OTBISummary: The expected OTBI report requires multiple fields from the following multiple Subject areas : - General Ledger - Journals Real Time - Receivables - Transactions…Ekta Nayak-Oracle 13 views 1 comment 0 points Most recent by Ekta Nayak-Oracle Reporting and Analytics for ERP