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
-
Is there any query to get the outstanding invoices for the specified monthSummary: Query to get the outstanding invoices for the specified month Content (required): We need to send a csv report to a customer which contains the outstanding invo… -
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome… -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…
-
Understanding the 'Disallow Previous Password' in Oracle fusion ERP password policy setupSummary: We are enabling the password policy in our system and needed to understand below regarding the field 'Disallow Previous Password' in password policy setup: How …
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Is there an option to set the priority for a process or a job within a jobset in Oracle Fusion ESS?Summary: Just wondering, if there's any option to set the priority for a process or a job within a jobset in Oracle Fusion ESS. Content (required): I have come across th…
-
Automated Regression Testing in Fusion CloudSummary: Each month we perform regression tests - especially in a month when the 1/4ly release patch is be applied - which covers much of the business's standard process… -
Moved: Drill Down OTBI is not working correctly using Custom Column.This discussion has been moved. -
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us…
-
Moved: SQL - GL Balances for IntercompanyThis discussion has been moved. -
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…
-
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio… -
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…
-
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…
-
How to add new Column in seeded Subject area Receivables - Transactions Real TimeSummary: I need to add column as Ready for XML (select READY_FOR_XML_DELIVERY_FLAG from RA_CUSTOMER_TRX_ALL ) Content (required): Version (include the version you are us…
-
Legal report for Portugal to communicate the inventories once every year - Portugal localizationsSummary: Portuguese companies are required to communicate to the Tax Authority the inventory relating to the last day of the tax period, through a file with defined char…
-
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
ERP Scheduled Job behaviour while downtime as part of maintenance/patching activitySummary: Hi Team, Could you please suggest on the behaviour of scheduled custom or seeded ess jobs in erp, during system downtime as part of maintenance/patching activit…
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content… -
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
Error : ORA-01861: literal does not match format stringThis is my query : WITH details AS ( SELECT ppl.person_number, ppl.person_id , pet.base_element_name, pee.effective_start_date start_date, TO_DATE(peev.screen_entry_valu…
-
Approval rule on business creationSummary: Approval rule on business Unit creation not working Content (required): I want to apply approval rule when Business Unit is created/updated, and I used the task…
-
Customization of seeded "Supplier Balance Aging Report"Summary:Hi, I am looking for customization of seeded Supplier Balance Aging Report in Oracle fusion application where I want to add currency as a parameter to run the re…
-
How to find the start and end date for an expired ESS process?Summary: Is there a way to view the start and end date of a parent schedule after it ended or expired in Enterprise Scheduled Process? Content (required): Version (inclu… -
Does exist a Job to update data in OTBI ?Summary: Does exist a Job to update data in OTBI ? Content (required): Dear All, we need to know if exist a Job to update data in OTBI. Thanks, Elisa Version (include th… -
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…
-
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
Issue SQL against PVOSummary: Is it possible to issue SQL against a data store extract PVO like "FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO" Content (required): Version … -
customizing payables dashboard/Invoices requiring my attentionSummary: How do I customize the build-in dashboards, eg. Payables Dashboard? Content (required): I have a requirement to customize this dashboard: The only thing that I …