Category 129
Discussion List
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?Reshma Eldho 23 views 3 comments 0 points Most recent by Bhaskar Konar 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 …
-
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 32 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…Valter Pilan 698 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
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…
-
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… -
OIC Gen3 Services calling in Fusion by using BIP/ Groovy AuthenticationSummary: We are tying to consume the OIC Gen3 REST/SOAP services by using BIP/Groovy we are unable to call them." Error while processing authentication at Trigger. Faile…
-
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 26 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
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 3 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…
-
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?
-
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 12 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…
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 22 views 2 comments 0 points Most recent by Vaishnavi Agrawal Reporting and Analytics for ERP
-
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 25 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 11 views 1 comment 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…
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 875 views 31 comments 7 points Most recent by Rahul Sood-Oracle Reporting and Analytics for ERP -
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…
-
RTF XDO_METADATA setup not working despite mirroring other setup that is workingSummary: We have customized an RTF to where the results are broken out into different tabs. We used the same for each loop as the other tabs, but the new tab is putting … -
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 197 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…Fernando Chavez 1 view 1 comment 0 points Most recent by nothingname Reporting and Analytics for ERP -
conditional formatting in RTF for duplicateSummary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any co…
-
Can someone help on how to setup to print directly from Oracle to a network printer?Summary: We want to print some reports directly from Oracle. Is there a way to use a printer in the network to have the output of the report print to a printer? Content …
-
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…
-
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an…
-
Keyboard Accessibility Tab Order in Oracle Analytics Cloud Fusion Data IntelligenceIs it possible to set a tab order for a Keyboard Accessibility requirement in Oracle Analytics Cloud part of Fusion Data Intelligence? It currently take 30 tabs to get t…
-
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?
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 9 views 0 comments 0 points Started by Emma Fayos García Reporting and Analytics for ERP