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
-
Requirement to add Custom fields on EDI856 in Collaboration Messaging FrameworkSummary: We have done the setups in Collaboration Messaging Framework(CMK) in ERP Cloud Fusion for EDI 856 (Advance Shipping Notice). Our client is looking for few of th… -
How to schedule ESS Processes in bulkSummary: Business has yearly activity to schedule accounting jobs across financial modules for all accounting periods. This requires good amount of manual efforts. Is th…
-
CMK Message Processing RulesSummary: CMK Manage Message Processing Rules Description: We are working on Collaboration Messaging Framework process PO Inbound (EDI 850) to create sales order in Oracl…
-
How to add multiple formats while submitting ESS job?Hi, We have a requirement to send the output to the customer. We are able to send the output in PDF format without any issue. However; customer is looking for both PDF &…
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr… -
SQL query to fetch Purchase Requisition Audit History using BI ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Moved: We want to provide a deep link in email to supplier for purchase order acknowledgementThis discussion has been moved. -
Statement of Directions on FRS in Cloud ERP?Hi, Does anyone know if/when FRS is going to be retired in Oracle Cloud ERP and moved to Management Reporting like is being done in EPM? Trying ot understand if we wait …
-
How to get customer AddressType from background tableSummary: When I enter the url below in browser, I can get AddressType, I need to build a data model and get similar info for a customer. https:///crmRestApi/resources/11…
-
In which table I can find readable names from HZ_CUSTOMER_PROFILES_F.STANDARD_TERMS?Summary: I would like to get readable names from HZ_CUSTOMER_PROFILES_F.STANDARD_TERMS, how can it achieve it? In link HZ_CUSTOMER_PROFILES_F, it shows STANDARD_TERMS is…
-
Merging Prompts in Financial ReportSummary: Merging prompts from two grids in Financial Reporting Studio Hi I have a Financial Report developed in Financial Reporting Web Studio with two grids and I am wo…
-
Is there a Standard report in Oracle Cloud for ECD in Brazil? Does it show the previous year's?Summary: Is there a Standard report in Oracle Cloud for ECD in Brazil? If so, does it show the previous year's operations? What to do when starting to use the platform? …
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…
-
Can I have a link for data lineage for 24 A versionSummary: Can I have a link for data lineage for 24 A version Content (please ensure you mask any confidential information): Version (include the version you are using, i…
-
segment level security in Oracle Cloud FinanceSummary: We have a need to restrict the segment level security due to the reporting conflicts. Since this demand more than 500 or so custom data access set, is anyone aw…
-
date masking reverting date back a daySummary: We have customized the AP invoice approval report to add fields needed. Content (please ensure you mask any confidential information): Issue is that the date in… -
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …
-
How To get Cancelled Invoice Amount in AP Invoice in Oracle FusionIs there any ways to retrieve Cancelled AP Invoice Amount in Oracle Fusion Using SQL Script.
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…
-
Not able to create analysis report while using a enquiry role.We need to grant users an "enquiry" role, which allows them to create analysis reports but restricts them from editing pre-existing reports. As we have added all the ana…
-
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…
-
Sql query for Canceled Payment Report.I wanted to fetch the Canceled Payment details from the person results through SQL query.
-
OTBI report is taking very long time to complete.I have built one Payroll OTBI report. I have been able to run it successfully from my private folder in the Prod environment, but when we load it to the Payroll Team fol…
-
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …
-
Can we default a parameter with dynamic value in ESS Job definition?Hi, We have a custom ESS Job defined for a BIP Report with a parameter Period Name and attached a custom LOV data source defined which lists the periods from gl_periods.…
-
User should be able to create a new OTBI Report(Analysis) but will not be able to edit the existing.Our requirement: We need to create a custom role in which a user should be able to create OTBI Reports by using subject area "Procurement- Procure To Pay Real Time" but …
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want… -
Moved: can we audit Allowed Email Recipient DomainsThis discussion has been moved.
-
How to escape double quote character in .csv file of BIP ReportSummary: We have enclosed few columns of the BIP report within double quotes and output is expected in a csv file. This will overcome the columns having comma getting sp…