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
-
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… -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary Smart View error using ExcelContent Hi, I'm using Smart View version 11.1.2.5.910 with Microsoft Office Standard 2016, I'm constantly receiving this error "Smart… -
BI publisher - controlling developer access to folders - write access to My Folders only but not toSummary We need to be able to control report developer access so that they can only create reports, data models etc in their local (My Folders) folders; everything else …
-
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
Roadmap features of 20C Version ? Addition & Existing Feature's deletionContent Hello All, I have figured out an warning message that, Oracle will no longer use FBDIs for converting the data of ERP and HCM process groups after 20C upgrade. I… -
Planning & forecasting in oracle fusionSummary Planning & forecasting in oracle fusionContent Hi, Is there any financial planning & forecasting feature (like hyperion functionality )in oracle fusion. Regards,…
-
rtf template - summarize column within groupSummary rtf template - summarize column within groupContent Hi, I created simple table ( see attached files ) and i want the column values to be presented on one row. wh… -
Customer Balance ReportSummary Customer Balance Report show me balance for All customerContent Hello i need report show customer,Transaction Type(Invoice,Credit Memo,Debit Memo,Receipt),Debit,… -
Table and Field to show date role was added to a userSummary Table and Field to show date role was added to a userContent looking for the sql table and field to show the date a role was added to a user. thanks.
-
Configuring SPF Record for Oracle Cloud Email Verification in ERP cloudContent Hi all, Is it possible to take advantage of SPF or DKIM e-mail verificatoin for Oracle ERP Financials notifications? I believe it is available for EPM, not sure … -
How to create an ESS job using PerlJobTypeSummary We want to create a scheduled process to change the default buyer of an ItemContent Hello guys, We're trying to create a ESS Job / Concurrent to change a default… -
Positive Pay Template ConfigurationSummary I'm looking for detailed instructions for how to break down and configure a positive pay template.Content By and large I'm looking for a guide for setting up a P… -
Attend The Premier Oracle Technology Conference—ODTUG Kscope20Summary Your ODTUG Kscope20 conference pass includes access to over 300+ technical sessions, all-day symposiums, lunch and learn panels with Oracle experts, and hands-on…User_2025-02-05-00-37-00-120 29 views 0 comments 0 points Most recent by User_2025-02-05-00-37-00-120
-
Lookup Details from Subject AreaSummary Custom Lookup Details from Subject AreaContent Is it possible to fetch any custom lookup information from any Subject Area? The use case is like below: An analys…
-
Drill down GL to subledgerSummary Drill down GL to subledgerContent Hi all, Is there any standard OTBI reports to drill from GL to subledger like AP and AR? or not possible customize is the work …User_2025-02-04-05-26-22-197 155 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197
-
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…
-
How do i put in multiple columns in the x axis of a rtf chart?Summary X axis contains values coming from a column and rtf does not allow multiple entries into the x axis label.
-
report accounts payable with cut-off dateSummary A report of accounts payable with cut-off date is requiredContent Does anyone know if in OCF version 19D there is a report of accounts payable with cut-off date …
-
Bi Publish can't export get an error.Summary oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODms…
-
Financial Reporting Center - Not sync'd real-time with OTBI?Content When creating an Analysis, Dashboard, etc. in OTBI it does not show up in the Financial Reporting Center for some time (many hours). Is this by design? Is there … -
XML output using RTFContent Hi, As the data model is ready I would like to have report output in XML as shown in screenshot what is the best possible way to develop the report. Attached scr… -
Customized Trial Balance ReportSummary Users are unable to run Customized Trial Balance Report from Scheduled ProcessesContent We have customized the layout of the standard Trial Balance Report and ar…
-
Cash Flow StatementSummary Availablity of out-of-box Cash Flow StatementContent In 19D version, is there any out-of-box report (BI or FRS) available for generating Cash Flow Statement? Sam…
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…
-
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
Risk Management Results by Control Summary ExtractSummary For a specified control, show the last time it was run, by who and how many results it returned.Content * Download the zip file attached to this post * Unzip and… -
Risk Management Users with Access Violations by Control ReportSummary Lists users that have violated a specified control.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example o…
-
Risk Management Result Summary ExtractSummary For a specified control, list common result attributes you would find in both Advanced Access Controls and Advanced Financial Controls.Content * Download the zip…
-
Risk Management Intra-Role Violations by Control ReportSummary List of roles that contain violations within itself for a specified control.Content * Download the zip file attached to this post * Unzip and you'll find 2 catal…
-
Risk Management Access Violations within a Single Role (Intra-Role) ReportSummary List of roles, users and conflicting access points with conflicts by control. Only roles that contain violations within itself are listed.Content * Download the …