Reporting and Analytics for ERP
Discussion List
-
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou… -
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and … -
How to show PO Number from Lines PageSummary How to show PO Number from Lines Page -- rtf templateContent Hi All, We have an custom requirement of printing Purchase Order Number from PO lines pages from eve… -
Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Summary Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Content p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helveti…
-
TODATE Function not working in 'Budgetary Control - Balances Real Time')Summary TODATE Function not working as expected in mentioned SAContent When using the TODATE() Function in Subject Area 'Budgetary Control - Balances Real Time' an error…
-
How to join the tables and develop new report using PAAS and SAAS CloudSummary How to join the tables and develop new report using PAAS and SAAS CloudContent Hello, We have requirement to develop report by combining the tables in PAAS cloud…
-
Ignore Skipped Instances on resuming paused report BIP JobSummary Ignore Skipped Instances on resuming paused report BIP JobContent Hello all, We have almost more than 100+ Reports and ESS Jobs that are scheduled and as part of…
-
Accounts Receivable Report (transactions and receipts)Summary Need ad-hoc AR report identifying customer billing and receivable transactions (including accounting information)Content Boise State has a requirement to provide…
-
SQL Link between GL and ProjectsSummary Report which shows project transaction that have flown through to GLContent Hi Does anyone know the links/joins between GL and Projects, we are trying to build a…
-
Combine Saas and PaaSSummary Combine Saas and PaaSContent We need a develop a report which is the combination from SaaS and PaaS environment. We have OAC standard edition. Kindly let us know…
-
Extract Arabic words using regexpSummary I want to extract arabic words from a text.Content SELECT '
-
OTBI GL Balances with DFFSummary DFF shows in Subject Area but when selected, Balances will not displayContent We have a DFF on the Cost Center Segment. When that DFF is added from the Cost Cent…
-
Create Direct Database Query issue - R13Content Hello, I am new for Oracle Fusion BI and would like to run simple query to check this functionality but i couldn't able to find Connection Pool. How to find conn…
-
Outbound Emails (Sent to Customers) Extract in Oracle Fusion CloudSummary Outbound Emails Extract in Oracle Fusion CloudContent Hi, We have requirement to extract the outbound emails (Sender Email ,To Email, Subject,Status ,Sent Date e…
-
Data Security in Custom BI Reports in Oracle Fusion Financials CloudSummary Data Security in Custom BI Reports in Oracle Fusion FinancialsContent Hi, We have lot of Custom BI Reports developed across financials Module ( AP , AR, FA , GL …
-
Looking for a table which stores the parameter values in ERP cloud ESS schedule requestsSummary Need a table name which stores attached Attribute2 value in ESS Scheduling process screenContent Need a table name which stores Attribute2 parameter values, Norm…
-
Hide/remove default reports from LOV in schedule jobsSummary How to hide default reports so that they dont show and cant be picked in schedule job list?Content Is it possible to remove standard ess reports from showing up …
-
GL OTBI report with filter on segment tree code running very slowSummary GL OTBI report with filter on segment tree code running very slowContent We have a few custom GL OTBI reports that were running fine until a recent refresh of th…
-
GL Detail or Trial Balance Detail report for auditSummary What report will show GL detail and be formatted line by line in Excel, without a lot of formattingContent Our auditors are asking for a detailed GL report (I pr… -
Approval Workflow ReportSummary Completing an audit of approval workflow for expenses, procurement and budget transactions.Content I am completing an audit of our approval workflow setup for ex… -
Data provided in subject Area Procurement - Purchasing Real timeSummary Data from Purchase Order Pre-processing Days inconsistentContent I am having difficulty obtaining metric information. I am working with OTBI and trying to get th…
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat…
-
Can't aple to run General Ledger Trial Balance ReportSummary error file after submit proceessContent Hi when create schadual process for General ledger trial balance report error log file attached is comming Thanks -
contracts history tablesSummary need the oks contracts approval flow history in a reportContent Hello guys, My team need the approval flow history for contracts in a report and I am not able to…
-
Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataSummary Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataContent Expenses - Expense Transactions Real Time Subject Area di…
-
Standard Report - Process OptionsSummary Standard Report - Process OptionsContent Hi, When we try to run any Standard/seeded report, process options contains various options/LoV. In that what is the use…
-
Smartview Formatting does not apply for EPM Workspace (ERP Cloud)Content Hi All, Unlike EPM Applications,Smartview Adhoc analysis formatting does not work when connecting smartview to EPM Workspace (ERP Cloud). Is there a way to get t… -
BudgetSummary Is there a Actual versus Budget trial balance report already created in Oracle?
-
General Ledger LOB SecuritySummary Creating LOB Security for General Ledger ReportsContent Hi I am reaching out to see if anyone has solution for creating Line of Business security for users to ru…
-
Copy Oracle Standard Report as Custom ReportSummary Copy Oracle Standard Report as Custom ReportContent I am new to OTBI in cloud version and have tried to create a very simple OTBI report. However, how to copy ex…