Category 129
Discussion List
-
Unable to edit Data Model post Deployment using Oracle SOAP ServicesSummary: Unable to edit Data Model post Deployment using Oracle SOAP Services. Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dll?SoapImpl=…Ardhendu Santra 66 views 4 comments 0 points Most recent by Ardhendu Santra Reporting and Analytics for ERP -
Limiting access to folders in custom folderSummary: We want to provide access to only expense folders to expense auditors/expense managers within Custom/Financials and to AP Managers to AP folder and so on. AP Ma…Dibyanshu_Shekhar 36 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
How to pass KPI value dynamically to Agent subjectSummary: How to pass Metric value to OACS agent body like 'Thresholds by Customer Level @CUSTOMER_THRESHOLD ' . Content (required): How to pass Metric value to OACS agen…Viswanath-Oracle 12 views 0 comments 0 points Started by Viswanath-Oracle Reporting and Analytics for ERP -
What Table is the Role Code found in?Summary: Writing a query and Need to know what Table the Role Cod is found in? Content (required): -
General Ledger Trial Balance Report column detailsSummary: We are looking to use the General Ledger Trial Balance Report but would like to understand each column definition of the balances. Can anyone help? Content (req…Anne Cilia 66 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Trying to create an OTBI Filter to convert string to DATE with current YEARSummary: Hi, I am trying to create an OTBI analyses that takes a DFF ATTRIBUTE5 in text format with the month and day, and then compares it to the date of the current ye…
-
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…Mickel.Rmeily 56 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
Security Reporting: Who Logged in and When and did whatSummary: Content (required): We need to report on the following areas: Who logged in/out and When? What actions the user has done? Which Pages the user accessed? Which T… -
Backend table for Payment process request statusSummary: Need to fetch payment process request status from backend Content (required): Hi There, we are building a report where in the customer needs the payment process… -
What is the difference between Order Date and Creation Date?Summary: Content (required): What is the difference between Order Date (Time folder) and Creation Date in Procurement - Purchasing Real Time subject area? As per the ana… -
AP Check print BIP report output to be printed from 2 different printers using PCL .Summary: Actually, we have a requirement on AP Check print report in which the page 1(contains the Cheque) which needs to be printed from printer 1 and other pages must … -
Steps to Create BIP Reports type ESS Job with Table type value setSummary: Steps to Create BIP Reports type ESS Job with Table type value set Content (required): Hi All, We have a requirement to create ESS Job for BIP Report with multi…RupaliGahalot 133 views 2 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP -
BIP Security - Need to restrict user from modify and deleting the reportsSummary: Hello Everyone, All the users in our environment have BI consumer role. So they are able to navigate to different folders and they have ability to modify and de…Oracletechnofunctional 243 views 4 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP -
Asset Transactions Real Time'. Which subject area can be joined to get the project informations.Summary: Hello Team, I am using this subject area to get the asset transactional details. I need project information. Which subject area can we join so that we can get t…Suhitha K-Oracle 24 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
Excel generated from RTF template is giving wrong valuesSummary: Excel generated from RTF template is giving wrong values Content (required): I have developed a query to get TransactionDr field from GL Lines table. For a spec…Jaeyshree K K 108 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 52 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 185 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…Donald 405 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
OTBI Report parameters and export optionsSummary:. 1.Check to have the parameters section display always after report is run instead of having to go to catalog and come back again to rerun the report. Update OT… -
Need the Backend Table Details for Oracle SubscriptionSummary: I want to build a report to get what module/functions are used for my organization/company. Content (required): need the query if any one have handy. Attached i… -
How can i connect to Essbase in PowerBISummary: We used oracle fusion cloud and able to connect to Essbase using Smartview in Microsoft Excel but when i try to connect to PowerBI using url it gives me error. …Ibrar.bajwa 453 views 2 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
BIP output calling an external webserviceSummary: BIP output calling an external webservice Content (required): We have a report that we'd like to export the data to a third party, but to improve integration, w…Luis Gustavo 34 views 4 comments 0 points Most recent by Luis Gustavo Reporting and Analytics for ERP -
Privileges required to view output on a custom version of a seeded reportSummary: Privileges required to view the output of the Import Project Budget report when a custom copy of the seeded report has been created (relevant to any seeded repo…LawrenceKillick 145 views 3 comments 2 points Most recent by LawrenceKillick Reporting and Analytics for ERP -
Is there any query to get the outstanding invoices for the specified monthSummary: Query to get the outstanding invoices for the specified month Content (required): We need to send a csv report to a customer which contains the outstanding invo…sunny.k.singh 621 views 4 comments 0 points Most recent by sunny.k.singh Reporting and Analytics for ERP -
BICC costs to extract PVO from other serviceHi, As I am not sure on how particularly Oracle handles this area, I am trying to figure out the following scenario: we are trying to extract some data from Fusion using…
-
Bank Payment File FormatSummary: Bank Payment File Format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACC… -
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…Shrujal Patel 56 views 2 comments 0 points Most recent by Shrujal Patel Reporting and Analytics for ERP -
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us… -
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio…sailesh_cloudare 43 views 0 comments 0 points Started by sailesh_cloudare Reporting and Analytics for ERP -
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 995 views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP