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
-
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an… -
We need an SQL query to retrieve all scheduled ESS jobs from the backend in Oracle Cloud Fusion.We need to extract and get the list of all scheduled jobs and programs from the backend in Oracle Cloud Fusion. The extract should include the following details: Job Nam… -
Help finding the audit product id for middleware applicationsIn order to call the API endpoint /fscmRestApi/fndAuditRESTService/audittrail/getaudithistory you have to pass "product". The products for regular fusion modules are eas…
-
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… -
Transaction Number in Account Analysis reportSummary: Can you please help to determine where we get this transaction number for payroll in Account Analysis report? Content (please ensure you mask any confidential i…
-
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, …
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
Scheduling OTBI report to store report output daily in sharepoint locationSummary: Scheduling OTBI report to store report output daily in sharepoint location where user can access directly instead of downloading it seperately from report Conte…
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…
-
Custom job set not requiring custom privilegeSummary: user guide is very clear on this topic: https://docs.oracle.com/en/cloud/saas/financials/24b/fafcf/create-job-sets.html but reality is different. Created a cust…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re… -
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …
-
Custom FRS Reports not showing up in Financial Reporting center post P2T RefreshSummary: Our Custom FRS Reports are not showing up in Financial Reporting center post P2T Refresh but we are able to access reports using EPM Workspace. This is working … -
sql query to fetch serial number per every transactionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…
-
ESS Job Report Output File NameSummary: After running the ESS job in Oracle Fusion 'Default Document', we can see the output name. Can we set this output name to reflect the order number or invoice nu…
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.
-
Any SOAP or REST calls available to see status of scheduled BIP reports?Hello Gurus, I am looking for SOAP/REST calls that can tell me whether the scheduled BIP report failed or succeeded. The navigation is Reports and Analytics → Home → Rep…
-
Create custom role to files in UCMI need the ability to view files in UCM, we have a report which runs via an ESS job but its erroring because users don't have the relevant privileges to access UCM. The …
-
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio… -
Unwrap Text in BIP Report Panel LayoutSummary: Please let me know if anyone worked on below functionality. I have a BIP report that uses a template designed using Oracle Fusion Reports and Analytics. The rep…
-
OTBI analysis on duplicate expense linesSummary: How do you do this? I'm new to OTBI and Fusion ERP. I need to report on duplicate expense lines, meaning an employee accidentally submitted their expense twice …
-
FRS reporting issues- dimension placement making huge differencesI’m having an issue with an FRS report. When I place the scenario in the columns, the trial report doesn’t match the one from the generated from scheduled process, but i…
-
Is the number of rows retrieved from OTBI analysis is increased from 75K?Summary: OTBI analysis can retrieve maximum rows of 75K. But users are now able to retrieve around 160K records from the analysis. Is there any update/change happened in…
-
To identify last modification details in Item Master , Item Locator and SubinventorySummary: We want to identify last modification details in Item Master , Item Locator and Sub inventory other than the 'last update date' , 'creation date', 'last updated…
-
Locating PVOs and Data Stores for ar_batch_sources_all and ar_credit_memo_amounts Tables in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Tracing bursting processSummary: We are currently sending mails to customers through the bursting process. Could you please confirm if it is possible to trace, from the backend, the details of …
-
Edit template and add new column in the existing excel templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Query to retrieve list of bi publisher jobs in oracle fusion.Summary: Hello Team, Could you please help in providing the query to show all the scheduled jobs from BI publisher page. Content (please ensure you mask any confidential… -
OTBI - Display the row of SUM onlySummary How can I edit the OTBI report to display the row of count and SUM only?Content I built a report to display the 'count of invoice number' and 'SUM of invoice amo…