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 extact segment 2 from code_Combination_description in my xml fileSummary: How to extact segment 2 from code_Combination_description in my xml file Content (please ensure you mask any confidential information): My xml stores the code c… -
Customization of 'Print Receivables Transactions' and 'Print Receivables Transactions: Invoices'Summary: Content (please ensure you mask any confidential information): Hi, This is regarding ESS Job 'Print Receivables Transactions' which in turn calls another ESS Jo…
-
Output tab when scheduling a processHello On some standard reports, they don't have Output tab when scheduling the process but some do. Anyone know if we can set the Output tab to display or this is what i…
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
Moved: BI Report Migration Not Captured in Audit LogThis discussion has been moved.
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …
-
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 download SOC(System Organisation Control) Reports for Oracle Fusion Cloud finance ERPSummary: Hi Team, Could you please suggest on how to download the SOC(System Organisation Control) Reports for finance ERP. Earlier, users having access to my service on…
-
Option to display Preferred Name in ERP ScreensHi, We would like to know if there is an option to display Preferred name in the List of Values in ERP(Finance and Procurement) Screens(Eg: in List of Values pertaining …
-
Alert or Notification for sandbox mode in oracle erp cloudSummary: Hi Team, wanted to know if there is any alert or notification configuration available in ERP Cloud to notify if a particular user login in sandbox mode reaches … -
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…
-
How can we add a widget or train stop custom on ERP page?Summary: Our client would like to have a widget or train stop feature on the ERP Customers page or other ERP pages. Is it possible in ERP and if there is a manual or ste… -
Sql Query to get data security applied on Chart of AccountsHello, I need an sql query to get my user's data security on the chart of accounts values. Thanks,
-
Cash to General Ledger Reconciliation ReportSummary Cash to General Ledger Reconciliation BI ReportContent Hi Friends, Did anybody Customized " Cash to General Ledger Reconciliation Report" or developed new report…
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
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 …
-
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …
-
How to find latest record in table PJO_PLAN_VERSIONS_B for projectSummary: Hi Team, I want to know how to find the most recent record in PJO_PLAN_VERSIONS_VL as version_number is same for all 3 rows. Regards Nidhi... Content (required)…
-
Duplicate descriptions across summary vs postable valuesSummary GL_SEGMENT_HIER_INTERFACEContent Will it cause issues if there are duplicate descriptions on a Summary/Non Postable value vs a Non Summary/Postable value? I've m…
-
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…
-
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…
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…
-
Moved: Hide Custom ESS Job Parameters LOV Seach FieldsThis discussion has been moved.
-
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… -
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …
-
Performance issueSummary AR | Performance issue with ra_cust_trx_line_gl_dist_all tableContent Hi All, Table ra_cust_trx_line_gl_dist_all is taking long time to run query when we use gl_… -
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 …
-
Report output name incorrect when downloading scheduled job outputs after upgrade to 23DSummary: We scheduled reports and when downloading it is generating name with % instead of space , but when republished it gives correct name for output file after upgra… -
Moved: We want to provide a deep link in email to supplier for purchase order acknowledgementThis discussion has been moved.