To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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… -
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…
-
"Purge Interface Tables" ESS Job failsSummary "Purge Interface Tables" ESS Job fails and Interface table data has not purged.Content Hi, Experts, As per MOS note Purge Interface Table Job - Argument1 (Docume…
-
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? -
VAT Reports for Russia in Scheduled process is resulting into warningSummary When I submit "VAT Reports for Russia:" this resulted into "Warning". It states that feature is not enabled. Please suggest. -
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…User_2025-02-10-05-51-05-868 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530
-
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…
-
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… -
Vacation Rules - table where data is stored???Summary Need to know if anyone has identified the table(s) where Vacation Rules are storedContent Wanting to know if anyone has identified where the Vacation Rules are s… -
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 -
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI PublisherContent Where is it recommended to develop a complicated financial report with compairsons Oracle BI Publsiher will be better as best practice… -
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 …User_2025-01-29-02-09-34-137 164 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856
-
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
-
BIP report deployment by using web service with object permissionContent Hi, Experts. I would like to deploy BIP report and data model by BIP web services from Test instance to Production instance. Each Object has specific permissions…
-
Custom ESS job not visible to all EmployeesContent Hello, We have created a custom ESS Job , but its not visible to all employees. We need it to be visible for all employees. We have referred the following docume…User_2025-02-07-08-53-49-914 871 views 2 comments 0 points Most recent by User_2025-02-07-08-53-49-914
-
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g…
-
Display The Limited Values Only On LOV Through User POV SettingSummary User would like to control the values that can be selected in the user POV of Financial Reporting StudioContent User would like to display the limited values on …
-
Fixed Page LayoutContent Hi, In the report the header display customer and invoice header details and the below table display invoice lines. I would like to restrict displaying number of…
-
Comprehensive Reporting Role in Fusion CloudSummary Role that has Access to all the Subject Areas/Dashboards/Reports. (Object Level as well as Data Level)Content Do we have a role other than BI Administrator that …