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
-
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I… -
OTBI Action Link not passing parameter when complex logical query is usedSummary OTBI Action Link not passing parameter to another BI Content when complex logical query is usedContent In general, if we create OTBI analysis from a single subje…
-
show project number on GL reportsSummary we building a report to show subledger details like invoice number , supplier etcContent we would like to figure a way to show project number on the GL report we…
-
OTBI -Report OutputSummary OTBI -Report Output- GL Subject AreaContent We are trying to create a report using Subject Area "General Ledger - Journals Real time". My requirement is that the… -
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 32 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 151 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…