Category 129
Discussion List
-
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 21 views 2 comments 0 points Most recent by Vaishnavi Agrawal Reporting and Analytics for ERP
-
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 11 views 0 comments 1 point Started by PiyushRathi1234 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 24 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 868 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 5 views 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
-
Setting default parameter as "Current Period" while creating a Batch for Email bursting of FR StudioSummary: We have a requirement for sending FR Studio reports through Email Bursting. We have multiple FR Studio reports which have Prompt as "AccountingPeriod". While cr…
-
Enter prompt variable in SOAP executeXMLQuery requestSummary: We have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report…
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 20 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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 18 views 3 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
How to minimize the input parameters for the multiple Grid in a single FRS ReportSummary: Hello Exports, I have Created the complicated Income statement (IS) in (FRS) and the same/single report having 4 different Grid (Child) with in a report. While …