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
-
BICC Mapping documentSummary: HI Team Please provide me the latest BICC View Object Mapping Sheet link Content (please ensure you mask any confidential information): Version (include the ver… -
How to get size of file running in ESS jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unusual behavior of OTBI report -Not displaying 'invoice amount' and 'discountable amount'Hi Team, We have OTBI report which displays invoice discount information. After 24A we are observing it is not displaying 'invoice amount' and 'discountable amount' for …
-
What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table?Summary: What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table? What is the use of this table in FAW? Content (required): MAYO Clinic Version (includ… -
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…
-
Getting corrupt XLS output for more than 100KB output.Summary: Report Name : AR Debtor Aging Report - MIRA Real estate.xdo Report Path : /shared/Custom/Transactional Reporting/Receivables/BI Publisher/Debtor Aging Template …Soare Oldrich Alexandru-Oracle 11 views 0 comments 1 point Started by Soare Oldrich Alexandru-Oracle
-
Unable to access attachments uploaded in workflow notification via hyperlinkAttachements uploaded in "Account Coding Workflow Notification" are getting saved as a content in BLOB column of a table rather than storing it as file in UCM. Hence it …
-
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…
-
how to store the manual input parameter values for multiple session in BIP report.Summary: User wants to run the BIP report with same input parameter values again and again and our report has around 20 manual input parameters. So is there any workarou…
-
SQL Query to get Transaction column from Review Completed Transactions Page for intransit shipmentSummary: I want SQL query to transaction, serial number from get reviewed completed transaction data for Intransit shipment transaction type. Content (please ensure you …
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide… -
Manage Administrator profile value acessHi, Which role should be assigned to access Manage Administrator Profile values? Please suggest. -
Schedule report option to deliver to email outside Oracle domainSummary: My client is looking at scheduling the reports via the report schedule Option in Oracle Cloud. How do we use the schedule report option to deliver to email if t…
-
Is intercompany invoice eligible for Mass Addition process?Summary: Hello, I created an Intercompany invoice with asset clearing account and want to transfer it through mass addition. I'm not able to do so. Please note that I've…
-
unable to get BIP Excel output and ends with error file format and extension dont matchSummary: when BIP Excel output is generated, the xls output ends with an error as "the file format and extension 'filename.xls' dont match. when the dialogue button is a…
-
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be… -
Oracle Fusion ERP Timeout IssueWe are currently attempting to satisfy controls that our Oracle ERP Applications timeout after 30 minutes of inactivity. Looking at the below link, it states that Idle s…
-
Moved: Invoice summary details table for APThis discussion has been moved. -
Subject Area to get real time ESS Job details for OTBI Analysis dashoboardHi, We have a requirement to create an ESS Job monitoring dashboard to show summary of ESS Jobs by status and few detail drill down reports. Is there any subject area wh…
-
Enterprise Contracts OTBI Fields - Couldn't find the notes on a contract field in the subject areaHi All, Is it possible to include the notes on a contract as a reportable field when creating an analysis? It is currently not an option. Can anyone please guide me on w…
-
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…
-
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t…
-
How to work with Multiple selection and NVL function In ParameterSummary: How to work with Multiple selection and NVL function Content (required): Hi All, Hope everyone is doing well. I have a below requirement for which i need you he…
-
Need a query to get accounting period of a POWe are unable to find a way to get an accounting period for a purchase order. Could you help with a query? I need the PO# and the accounting period as a column. Also, le… -
-
Performance issue with Custom ReportSummary: Dear All, We are facing performance issue with one of the report. This report provides the information about the Project Budgets along with Expenditures details…
-
List of All columns in VIEWSfor Oracle Fusion ERPSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Scheduled Processes Names in Fusion TablesSummary need to find the scheduled process names in the fusion tablesContent Hello guys, I need to build a BI Publisher report related to the scheduled processes in Orac… -
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…
-
How can we determine if the BIP report has reached/hit a certain number of billion logical I/O?Summary: We received a notification from Oracle that the one of our report is running for more than 5 hours or exceeding 4 billion Logical I/O. Hence, the report needs t…