Category 129
Discussion List
-
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 72 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 12 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 336 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 38 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 21 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 2 views 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 23 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 54 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 280 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… -
Getting the error 'ORA-31011: XML parsing failed' when calling the SAAS report through webserviceSummary: I am getting the below error when calling the SAAS report through webservice call from my pl/sql procedure. 400 Bad Request 400 Bad…
-
Time Lag when changes in Procurement appear in OTBIChanges made to PO's, Requisition do not appear immediately in OTBI but after a number of Hours? Is there a process that pushes through the Changes to OTBI?
-
How restrict custom BI report data based on flexfield segment valueSummary: How restrict custom BI report data based on flexfield segment value Content (please ensure you mask any confidential information): Hi All, We want to restrict c…
-
Can someone please help me know the table names for the below PVO's?RSI GL Config Job TopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.FiscalPeriodExtractPVO FscmTopModelAM.Fin…Srilatha Boddu 21 views 6 comments 0 points Most recent by Srilatha Boddu Reporting and Analytics for ERP
-
How to create a formatted CSV outputHi, The current CSV output format of any BIP Report Layout support only non-formatted CSV. Is there a possibility to get a formatted CSV as per the template designed, Pl…
-
How to export XML sample file from Purchase Order PDF data modelI am trying to export the XML from the standard Oracle Purchase Order PDF Data Model, so that I can import that XML Sample into the RTF Document (using the BI Publisher …Richard Nagle 114 views 3 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 44 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP