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
-
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 … -
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,… -
Carriage Return in scheduled jobSummary Manual run of report has no Carriage return - scheduled run of job does - Tab delimited file.Content Hi all, Has anyone seen this behavior and overcome it? we ar… -
Report that List All Users and Assigned RolesSummary Looking for a report that provides a list of all users and their assigned roles.Content Hi. Does anyone know of a report that list all users and their assigned r… -
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,…
-
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 145 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 -
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… -
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… -
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 48 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271 -
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… -
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 -
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… -
BIP PO rtf Template archive querySummary Displaying the Line Level Notes to Supplier in the PO Template in BIPContent Hi, I have a requirement to display "Notes to Supplier" field on to PO rtf Template …User_2025-02-05-10-39-37-202 38 views 8 comments 1 point Most recent by User_2025-02-05-10-39-37-202 -
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 … -
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… -
Reports ListSummary get the list off all reports under CatalogContent Hello all, I am not sure this is the right section to ask this question, but I will give it a try: Does anyone … -
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… -
GL Valueset DFF's are not available in OTBI subject areasSummary GL Valueset DFF's are not available in OTBI subject areasContent I confirmed the context and segments are BI enabled then ran the processes: Create Rules XML Fil…User_2025-02-06-00-15-19-515 52 views 3 comments 2 points Most recent by User_2025-02-06-00-15-19-515 -
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, Nishanth -
How to Pass parameter from ess job to BI Publisher reportSummary How to Pass parameter from ess job to BI Publisher reportContent Hi, I created BI Publisher report with the following parameters: P_BUSINESS_UNIT P_CUSTOMER_NAME… -
Adding LOV in ESS Bi Publisher ReportSummary Adding LOV SourceContent Someone can help in Adding LOV of BiPublisher Report in Custom Enterprise Scheduler Job with LOV Source -
OTBI bar graph formatting for gradient not workingContent I've created a dashboard and saved the supporting analyses and prompts in My Folders. When I copied it to a shared custom folder, no one in my company could view… -
Smartview reports include disabled CCID data or not?Summary Our Smartview reports were out of balance after removing the check mark on "Enabled" in "Manage Account Combinations" for some CCIDs back in 2016.Content In 2016… -
BIP extract needs to be split into multiple files for a specific range.Summary Is it possible to split BIP extract file into multiple files for a specific range.Content Hi All, I need to extract Projects and related task information from Or… -
How to Publish New DashboardContent Hi i have new dashboard in BI and i need to publish after finish and i stuck in below error Destination same as source: /shared/Custom/_portal see in attached Th…
-
Oracle Operational reports - CSV exportSummary Oracle Operational reports - CSV exportContent All, We are reviewing the OOTB cloud ERP operational reports (BI Publisher) with client and what they really like … -
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks. -
Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionSummary Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionContent Can we still use API - APPS.iby_fd_extract_ext_pub to add…