Reporting and Analytics for ERP
Discussion List
-
Custom ESS Parameter with TextBox and SearchSummary How can we have a Custom ESS Job with parameter as Textfield with Search option.Content One of the standard ESS Job has a parmeter which is a TextBox with a Sear… -
AddIn is disable in VDI toolContent Hello, Can you help me out with this enable to AddIn in word in VDI tool. Thanks, Nupur Thakar Version VDI 5.4.3
-
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…
-
Is it possible to create a data source for ERP Cloud from Oracle Analytics Cloud (OAC)?Summary My company is moving to Oracle ERP Cloud, but end users want to still use OAC as the primary source for Reporting and AnalyticsContent My company is moving to Or… -
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 45 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle
-
20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsSummary 20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsContent All, 20c- BI Publisher Data Models No Longer Support P…
-
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working… -
Generate SAFT Data Extract Norway is not populating with any dataSummary Generate SAFT Data Extract Norway is not populating with any dataContent The ESS job 'Generate SAFT Data Extract' is not populating with any data. Parameters scr… -
Want to extract Data from Report & analytics by writing SQL QuerySummary Want to extract Data from Report & analytics by writing SQL QueryContent I Want to extract Data from Report & analytics by writing SQL Query. Previously i use ex… -
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…
-
Error tables in Oracle for Unit of Measure Intraclass Conversion FSM importSummary I am trying to fetch the errors that occured while importing Unit of Measure Intraclass Conversion using FSMContent Hi, I am searching for tables where I can fin…
-
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…
-
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes? -
View ImageContent Hi, View Image from the receivables page is not working for couple of invoices as 90% of the case is successful. This is custom data model and custom template. W… -
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…
-
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…
-
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T… -
Getting data from a Data Model to test it (Ad Hoc)Content After the direct SQL query was removed, I am now forced to create a report for my data model when I want to see the data in any other format than XML or more tha… -
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type field -
ESS Administrator / Monitor / Operator rolesContent Hi I'm trying to find information on what exactly entails the roles: * ESS Administrator Role * ESS Monitor Role * ESS Operator Role Trying to give a user access… -
Where can we get Percent Complete in Contracts Associated ProjectsContent Hello all, From where can I get the highlighted field . This is from which table? I checked contract lines tables there Percent Complete is coming NULL. Please s… -
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …
-
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti… -
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …
-
Set background color on subtotal lines in OTBIContent Hi, I would like to set background color on subtotal lines in OTBI Analytics. Does anyone know how to configure about this? regards, Version BIP 11.1.9 bundled w…
-
COA value missing in the LOV in Payables invoices - Transactions real time subject areaSummary COA value missing in the LOV in AP invoices real time subject areaContent Hi Gurus, We defined a cost center long ago and had AP transactions created against it.…
-
Cycle query for Structures and Components.Content Hi there. I'm trying to get a by level BOM with tables EGP_STRUCTURES_B and EGP_COMPONENTS_B. It's not so easy to relate as in EBS, you guys have any good cycle …
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…
-
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX table