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
-
How to get module column (Finance or SCM) based on the users in user detail reportSummary: Content (required): Hi , I would like to get some query or sample reports to develop a custom user module report as this report is very important for business. … -
Enable Audit Log/System PerformanceHello All, We are interested to enable the Audit log files in Production and we want to know that what is the impact on system performance audit log is enabled once. We…
-
Is the Oracle Analytics Cloud Professional Government is specific to the Government Cloud?Summary: Trying to determine its applicability to city government. Content (required): Is the Oracle Analytics Cloud Professional Government is specific to the Governmen…
-
Error Message from RTF Template - Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001Content Hi Please can someone assist witht the below error: Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001 This error is recvieved when running custom templ… -
Where is the retention period of ESS jobs maintained ? Can we modify it to 7 days .Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Is it a best practice to enable audit log in all the object attributes of a business object?Summary: External audit requires us to enable audit log. Is it a best practice to enable audit log in all the auditable object attributes of a business object? Let's say…
-
How can we call a BI report through REST APIs?Hi, We need to call a custom BI report, through API. Can you please provide us an example of how to have/prepare the report path? And how the whole URL should be like? K… -
How to pass 10K records in IN clauseHi, I would like to pull journal information for 10K batches. I have 10K journal batches in the csv file and need to pull journal information(creation date, category, et…
-
How long are the ESS Jobs history and output files are retained on the server?Summary: How long are the ESS Jobs history and output files are retained on the server? Content (required): ESS Job History along with Log files and Output Files Version… -
How long are the report jobs and outputs retained on the server?Summary: How long are the BIP Report Jobs and output files are retained on the server? Content (required): N/A Version (include the version you are using, if applicable)…
-
Getting remittance message columns in OTBI before payment is madeWe want to create a report which we can use to check whether all payment details are filled correctly for large batches of payments before creating them, to prevent down… -
Table that holds ESS Job Display nameSummary: Hi We are trying to create a bip to fetch ESS job details. we looked into ess tables for display name but looks like they store only short name. fusion_ora_ess.…
-
Is there a report which can track the provisioned/deprovisioned and deleted roles for a user?We are unable to find any report that helps us track the audit history of a user account regarding when the roles were/are assigned and when the roles were/are removed f…
-
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real…
-
Include URL in BI Publisher report to allow viewing of invoice attachmentsSummary: I am trying to find a way to include a url link to a scanned invoice images stored as pdf attachments in Oracle from a BI Publisher report. Content (required): …
-
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver… -
Project Detail not showing up in Subject Area: Financials - Asset Transactions in FAWSummary: In Fusion Analytics Warehouse: Subject area: Financials - Asset Transactions: when we are pulling Asset Detail: Asset ID, Asset Number and Asset Name with Proje… -
How to map one parameter value to the multiple columnsHi, I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value. Data Model Query select * from supplier where usage1 …
-
Dynamic Legal Entity Name heading in FRS ReportSummary: Hi All, Can we have company or legal entity name derived dynamically in FRS reports based on selected legal entity at page level? Thanks, Content (required): Ve…
-
Customize 'Usage Metrics Drill-Through Report'Summary: Customize 'Usage Metrics Drill-Through Report' Content (required): We need to be informed if it's possible to customize the 'Usage Metrics Drill-Through Report.…
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …
-
Is there a delivered report on percentage of candidates that turn down offers for specific positionsSummary: Job offer rejection rate for fiscal year. Content (required): I have a report request for % of candidates that turn down job offers for specific positions. If a…
-
What are the advantages and disadvantages of audit policies in Oracle ERP?Summary: When enabling Audit trailing in the Manage Audit Policies in Setup and Maintenance, what are the advantages and disadvantage of audit policies Content (required… -
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…
-
Issue SQL against PVOSummary: Is it possible to issue SQL against a data store extract PVO like "FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO" Content (required): Version … -
Supporting Details Option Not Displaying On ReportsSummary: Upon setting the "Supporting Details Option" to display after the Parent member for my report, I am unable to see the supporting details when viewing my report …
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi…
-
Impersonation auditingContent Hi, I want to know if it is possible to know what a user did on behalf of another (as a proxy) I read that document about impersonation auditing and did the conf…
-
What is MRC compliant in Fusion Reporting?Summary: How to check if the reports built is MRC compliant or not Content (required): Version (include the version you are using, if applicable): Code Snippet (add any …
-
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…