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
-
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust… -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…
-
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …
-
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…
-
Audit Reports History Retention for Work Definitions – How many days?Hi all, I’m trying to understand the retention period for audit reports history, specifically regarding work definitions / records. I know that audit history is not kept…
-
Manage Audit Policies enabled but output shows 'There are no records to display'Summary: We have enabled 'Manage Audit Policies' for Payables >Invoices (attributes also SELECTED and added) last week. 1) However when we run the "Generate Audit Report…
-
Sourcing BIP: Cannot fetch multi option supplier bid responsesSummary: We need to create a custom reportfor the supplier requirements bid, in Sourcing. To achieve that, we are creating a report on BIP, having the RFP number and Bid… -
Access Violations within a Single Role [Intra-Role] Report not syncing resultsSummary: Hi I first ran the controls > Ran "Access Violations within a Single Role [Intra-Role] Report" > Identified the conflcting privilges > Removed the privileges > …
-
Capture SaaS Usage Metrics for FinancialsSummary: We have noticed that ESS job 'Capture SaaS Usage Metrics for Financials' is scheduled in production instance. It seems it is auto scheduled in the environment a…
-
FRS Reports erroring out intermittentlySummary: FRS Reports erroring out intermittently Content (please ensure you mask any confidential information):These are the errors received trying to run the Fin report… -
Error message while defaulting the value for DFF: FND-FND_VS_VALUE_INVALID, cannot be accessedSummary: Hi, While setting the default value of a DFF, facing an error: FND-FND_VS_VALUE_INVALID, can not be accessed. Attaching screenshot for the same. Content (please…
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. … -
I need to find a way to Audit who deleted a folder in Reports and AnalyticsWe are live on Oracle Fusion, and we have a bunch of Reports and Datamodels in Custom folder in Reports and Analytics. Someone deleted one of the folders and we need to …
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …
-
Is there a function to get lookup meaningsSummary: I am creating a report and the users require the displayed values for the lookups, I know I can do multiple links to the fnd_lookup_values_vl view (see code sni…
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…
-
How to filter analysis date within current dateHi Experts, We're currently using "Receiving - Transaction Real Time" to create an analysis. and we want to filter on transaction date field that only display date on cu…
-
What is Retention period for audit trail reportSummary: We wanted to know the retention period for audit trail report. Content (please ensure you mask any confidential information): Version (include the version you a…
-
A Custom Requisition Report not bringing back all results.Summary: We have a Custom Requisition Report and it is not bringing back all results for a filtered cost centre. I cannot see why it is not finding the results expected.… -
Why do some scheduled processes have an External Job Status of WAITINGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Required Table to get "Add Organizations to Tree" under Manage Project Organization ClassificationsSummary: We are unable to get the right table where the Add organization tree information stored. We tried to link the table PER_ORG_TREE_NODE_RF, PER_ORG_TREE_NODE, FND…
-
How can Fusion BI Report generate two different PDFs for same data at each ESS run.I have a requirement where my report should have two outputs one with all price columns other without for same data. Based on my bursting logic I can generate two emails…
-
Merging Multiple PDF Attachments as Additional Pages in a Single PDF Output BIP ReportI am working on a BI Publisher report in Oracle Fusion and would like to understand whether the following requirement is technically feasible. For an AP Invoice, there m…
-
List of standard approval workflows in the Fusion ERPSummary List of standard approval workflows in the Fusion ERPContent If anybody have the complete list or document that give the list of standard Approval workflow avail… -
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates?Summary: How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates. Content (please ensure you mask any confidential information): To…
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
Query to get Contract Financial SummarySummary: Dear All, I'm need a report that gets data from the following table in the Contract Financial Summary. What are the oracle tables or Views to get this data from…