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
-
Need to extract all OTBI/BI reports in custom folderSummary Can we use sql to extract OTBI/BI reports metadata? -
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …
-
customer balanceContent i need to create customer balance details report .can i find seeded report for customer balance details ?if not can i find query ?
-
supplier balance detailsContent i need to create supplier balance details report . can i find seeded report for supplier balance details ? if not can i find query ?
-
Can read-only users download Excel reports from Report&Analytics menu?Summary Is it possible for read-only users to output OTBI reports?Content I am considering to devide users into two role groups to minimize account licence fee. 1. read0…User_2025-02-08-06-23-38-301 44 views 3 comments 0 points Most recent by User_2025-02-08-06-23-38-301 -
Querying CST_COSTED_ONHAND_DAILY brings nothing.Summary CST_COSTED_ONHAND_DAILY is empty.Content I do retrieve data from other CST tables but querying CST_COSTED_ONHAND_DAILY brings nothing. Any suggestion? Thanks! Ve…
-
Best strategy for weighed FIFO item cost.Content Hi. In Oracle EBS we had FIFO layers that each one was being consumed. The item cost at a time was the weighted average of the value of the unit value of the lay…User_2025-02-07-06-48-26-537 40 views 0 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg…
-
User Logon IP AddressSummary User Logon IP AddressContent Hi Experts Is there any table where Oracle stores the IP Address of an user logon ? We are looking to putting some controls on the I… -
AR Transaction details with receipt details custom OTBI reportSummary Need to link Receipt Application subject area to transaction details subject areaContent Hi, I have created a custom OTBI report with all standard AR receipt det…
-
Subject Area for BMP Workflows / How long to approveSummary Subject Area for BMP Workflows / How long to approveContent Is there a subject area for BMP workflow? I'm looking for a query to tell how long project related ap…
-
Monthly Scheduled report did not runSummary Monthly Scheduled report did not runContent Hi Experts We have a monthly scheduled report scheduled in March and has run fine for first 3 months. The report has …
-
Goals Report - Quarterly reviewSummary Unable to find columnsContent Hi, I've been asked to build a Goals report that contain the following fields that I cannot seem to find in any of the Goals Subjec…User_2025-02-05-22-44-35-842 34 views 0 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
How to Extract Approval Rules Created for Contract Created in BPMContent Hello, We need to extract Contract approval Rules created in BPM. How to achieve that?User_2025-02-07-08-53-49-914 35 views 0 comments 0 points Most recent by User_2025-02-07-08-53-49-914
-
Subject Area for Receivables Recurring Bill PlanSummary Looking for debit authorization number in bill planContent Hello: I am looking for the subject area that will house the debit authorization number (bank account …
-
on cx how i get table for custom table ?Content in cx in service when create a work order , we created a field assign to and setup it in custom table. i need to create a report and get value for field assign t…
-
In what table is stored the transaction reference?Content Hi. Where is stored the inventory transaction reference accessed via the "Edit details" button in the "Create Subinventory Transfer" form? Thanks! Version Fusion…
-
Add Period Date to Parameter Default ValueSummary How to add current 'MMM-yy' in Parameter Default ValueContent Hi, I would like to set my default value for my Parameter as current 'MMM-YY', so in today's instan…
-
Unable to access oracle docsSummary Unable to access oracle docsContent Is anyone else facing issue with not being able to access the oracle docs links. We are unable to access the key pages such a…
-
Emailing report based on field on data model?Summary Send report to destination based on field on DM?Content Hi. I'm working on a simple report to show the quantity on hand of items based on subinventory. Each subi…User_2025-02-07-06-48-26-537 29 views 3 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
convert column data to rows(pivot)Content i create sql statement and the result is customer period No_of_invoices Cust1 Jan-2020 7 Cust1 feb-2020 9 Cust1 mar-2020 4 Cust1 apr-2020 6 Cust1 may-2020 3 Cust…
-
Subject Area - Payables Invoices - Transactions Real TimeSummary Not able to find taxes - Transaction Tax section under Subject Area - Payables Invoices - Transactions Real TimeContent Hi All i was building OTBI report for bus…User_2025-02-07-08-55-07-914 80 views 4 comments 0 points Most recent by User_2025-02-07-08-55-07-914
-
Scheduling Reporting & Analytics Analysis reportsSummary Need information on invoking an action to change subject description of emailed reportContent Hello: Can someone help with detailed information on how to change …
-
How to upload/update from Excel to Oracle Financial Cloud.Summary Which tools/methods are recommended to upload data from Excel?Content Hope everything is well with you. I want to upload and manage payment record and receivable…
-
Oracle R12 Customer wise Partno wise backorder query in Oracle Fusion.Summary Customer wise partno wise backorder query.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Orac… -
Avoid carriage return character at the end of each line in etext outputSummary Avoid carriage return character at the end of each line in etext outputContent Hi, We have a requirement to remove CRLF at the end of each line in extext output.…
-
Mandatory fields on Job SetsSummary Mandatory fields on Job SetsContent Hi All I have several scheduled processes that need to run each month and have created Job Sets for them. However the process…
-
Any webservice for Manage Data Access For UsersSummary Need to know if any webservice that tell me what user has access toContent Hello, Is there any webservice to find out what access the user has like what Business…
-
Where to find customer GST number field and from which tableSummary Where to find customer GST number field and from which tableContent I need to find customer GST number field and from which table to get it
-
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…User_2025-02-08-08-55-02-564 175 views 8 comments 0 points Most recent by User_2025-02-08-08-55-02-564