Category 129
Discussion List
-
Reports and Analytics - Catalog - usage numbersSummary: Need to identify usage nubmers of reports in the ERP Tools and Analytics catalog Content (required): We are trying to identify the frequency and usage of report…Marko Puskac 41 views 4 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP -
Report in FRS showing different resultsWe created a report in FRS "Etat Balance interactive" so the client can check the balance of each account and interact with the data by clicking on drill-through so he c…Elyse Meouchi 24 views 2 comments 0 points Most recent by Elyse Meouchi Reporting and Analytics for ERP
-
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…Antony P Patrick -Oracle 101 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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…
-
Print Receivable Transaction not generating output for Intercompany invoicesSummary: Print Receivable Transaction not generating output for Intercompany invoices Content (please ensure you mask any confidential information): Hi All, Why Print Re…Venkatesan 23 views 2 comments 1 point Most recent by Eain Cathcart-Oracle Receivables & Collections
-
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically …Kishore S-Oracle 602 views 6 comments 3 points Most recent by Sudhan Reporting and Analytics for ERP -
Invoice History ReportSummary: Is there any report that shows payment information and the invoice number related? Version (include the version you are using, if applicable): Oracle Fusion Clo…andrea.bautista 31 views 4 comments 0 points Most recent by andrea.bautista Reporting and Analytics for ERP
-
Ability to restrict access to specific FAH Subledger tables for creating new data modelSummary: Ability to restrict access to specific FAH Subledger tables for creating new data model. This is needed to restrict personal information which is coming from so…
-
Need document on Localization for Israel, Switzerland and Portugal in Oracle Fusion ERPSummary: Need document on Localization for Israel, Switzerland and Portugal in Oracle Fusion ERP Content (required): Need document on Localization for Israel, Switzerlan…
-
Is there a list of Essbase cubes and fields available for Cloud ERP?We are trying to find a list of all Essbase Cubes and the fields in those cubes so we can create reports more effectively in SmartView. Does anyone know where we can fin… -
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val…
-
Issue to get PO Lines accounting details from GL sideWe need to retrieve the PO Lines accounting details along with the net balances. But we are unable to obtain the PO Lines accounting details from the GL-level tables. We…Sushan Peiris 71 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Does the END_DATE field in PER_USERS table get populated when the user is made inactive?Summary: Does the END_DATE field in PER_USERS table get populated when the user is made inactive? Searched this filed and no values populated Content (required): Making …
-
How to add a deep link to items ?I have attempted to use the Deep Link SCM document to create a deep link for Items, but unfortunately, it didn’t work as expected. Could you kindly assist me with a step…
-
OTBI Receivable transactions- Real Time- Trying to get the warehouse/ship from detailsHi Team, Trying to create OTBI Report using Receivables transactions Real time. We need to add warehouse/ship from organization details for each of the invoice line. Una…Garima Arora-Oracle 11 views 1 comment 0 points Most recent by Garima Arora-Oracle Reporting and Analytics for ERP
-
Display modification in SmartView ad hoc analysisIn SmartView ad hoc analysis, I want to display hierarchies in a way where the parent value appears first, followed by the child value. How can I change this setting?yuyano-Oracle 11 views 2 comments 0 points Most recent by yuyano-Oracle Reporting and Analytics for ERP
-
Extracts General Ledger Cube Balances - Error out as QUERYRESULTLIMITHi, From EPM application, ESS job "Extracts General Ledger Cube Balances" is called, which error out as below. Kindly let me know how to fix this issue. Error: Execution…Bharath Kumar Madupuru 386 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co…Lucky Sharma 43 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …
-
Access Values in mapping set for reportingI'm working on a BI publisher report that is a crosswalk from a legacy system to their new values in Oracle Fusion. The report is around deliver-to locations and in Fusi…
-
My ledger currency and reporting currency is different.Summary: Need a report from Oracle cloud financial module that provides month end FX rates. Content (please ensure you mask any confidential information): My ledger curr…PiyushRathi1234 23 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Are there any options available to pull the GST tax code/classification into the report?”Summary: In GL Custom Report, we require GST Tax Code and Classification information from the Payable Line level. Kindly advise on the feasibility. Content (please ensur…Saumyashri 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Payables, Payments & Cash Management
-
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
Synchronize Hierarchies from EPM to ERPIn EPM, we have established a project hierarchy under an "All Projects" node, with dimensions assigned by department. Our goal is to ensure these hierarchies are accurat…
-
QUERY TO GET ESS JOB AND SCHEDULE JOB HISTORYSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mohan Gawade 67 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can you share Expense Reports OTBI including Approver information ?Summary: Can you share Expense Reports OTBI including Approver information ? Thank you Content (please ensure you mask any confidential information): Version (include th…
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
Limit rows displayed on template in Bi Publisher.Summary: We have a rtf contains 3 paragraphs. The second paragraph should display a maximum of 10 employees per page, and the third paragraph should be displayed on all …Salma Mohamed Salem 281 views 5 comments 0 points Most recent by NagarajuKunchala Reporting and Analytics for ERP
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the…