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
-
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…
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…
-
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…
-
Balance Sheet is displaying 0 figures when selecting Accounting/quarter as parameter in FRCWe have configured the Balance Sheet with parameter as per below But the figures when selecting accounting/quarter in the parameters are not appearing.
-
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…
-
Income Statement and Balance Sheet are returning error values for Net Income and Asset balancesWhat are the possible reasons for Net Income and Asset values showing error values in the Income Statement and Balance Sheet generated in FRS? Investigation performed so…
-
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…
-
How to Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…
-
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…
-
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…
-
OTBI Subject Area: Fixed Assets - Asset Depreciation Real Time data mismatchIn UI, Asset's Initial units were 100, And 66 units were partially retired and then Transferred out on Oct-24. So the current active units are 34 and the Depreciation Re…
-
Facing Error while generating Fixed Assets Data in OTBIHello, We have around 30 Asset Books, For my user all the Asset Book access given. I'm trying to do an analysis in OTBI by using the Fixed Assets Depreciation Real Time …
-
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…
-
Sources to connect/fetch ESS job definition details and ESS job request history tablesHi , I am looking for any latest resources available to fetch ESS job definition details like job name based on the job request history details like request id. Referrin…
-
BI publisher parameter bugHi, My colleagues and I have been experiencing a bug where some of the parameter list of values don't work when selected, we know they do when we try to schedule the rep…
-
Service Usage Metrics Report for EPMSummary: One of our customers has requested the Service Usage Metrics Report for EPM (Hosted Named User, Hosted Employee, Records, and Hosted Employee details) from OCI.…