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
-
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… -
Converting Parameter Timezone on Input - UTC Database vs BST Local IssueSummary Converting Parameter Timezone on InputContent Hi All, We have an issue relating to the database time being on UTC, where our current local time is BST, though I …
-
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…
-
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… -
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 -
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… -
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…
-
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… -
"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…
-
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… -
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… -
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… -
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… -
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.…
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba… -
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… -
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
-
Daily Journals Report (Standard Report) in Oracle Fusion does not show Some ParametersContent Dear, Daily Journals Report (Standard Report) does not show Some Parameters it works perfectly but issue is it does not show some parameter which are mentioned b… -
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…
-
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 1.2K 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 …
-
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…
-
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 …
-
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… -
Fixed FooterContent Hi, Please suggest how to have set of fields fixed to be displayed at the bottom of the page as the report can have single to multiple pages. In all the pages th…
-
Session user for bursting BIP reportSummary Session user for bursting BIP reportContent How can i burst BIP report to the session user ( the user that run the BIP report ) ? what parameter i should add aft… -
financial report studio & smart viewContent 1- i will start study financial report studio & smart view . 2- what are the documents available ? and what is the contents ? 3- what is the forum available fina…ghrbia 61 views 1 comment 0 points Most recent by Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle
-
Need Web Service/Seeded Report to list all BI objects (reports, analysis, dashboards, prompts)Summary Need Web Service/Seeded Report to list all BI objects (reports, analysis, dashboards, prompts)Content We have requirement to get the complete list of analysis/da… -
Add note text of an invoice in OTBI/BIPSummary Add note text of an invoice in OTBI/BIPContent Hello, My need is the following : create a report which will show the comments of invoice which are rejected This …