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
-
How to pull GL JE data for a rolling last 2 periods or last 60 daysSummary: How to pull GL JE data for a rolling last 2 periods or last 60 days Content (required): How can I pull GL JE data from the GL JE Header and Lines tables, so the… -
REST API for Profitability and Cost Management.Summary: DOWNLOAD FINANCIAL REPORTING REPORTS IN PROFITABILITY AND COST MANAGEMENT WITH REST API. Content (required): Hello, I have reports created from the reporting to… -
Are the tables related to OTBI reports available to report on in OTBI?Summary Would like to monitor changes to OTBI reports at the table level until OTBI reports are being monitored via Audit PoliciesContent Would like to monitor changes t… -
Can BICC write CSV files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…
-
Can BICC write files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…
-
GL Budgets not being returned from General Ledger - Balances Real TimeSummary: Subject area General Ledger - Balances Real Time not returning data for GL Budgets (budgets are loaded) Content (required): Hi, I have followed Doc ID 2177122.1…
-
Convert Period Name to DateSummary: Trying to convert period name format to date format mm/dd/yy Content (required): Hi All, I'm trying to convert the column "Fixed Assets - Asset Depreciation Rea…
-
Unable to Import Lookup TableSummary: Getting error while trying to import lookup type code when having context segment and associated DFF. We have context attribute named as context segment which a…
-
Pricing List ReportHi, I am looking to create BI publisher report on Pricing List. If you can share the query and RTF template if any available please do share Thanks -
rtf template balance lines between two adjacent cellsSummary: RTF Template - Balance lines between two adjacent cells Content (required): We've modified our invoice print template to include serial numbers when applicable.…
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, Ramu
-
How to find from which system or ip submitted a bip reportSummary: can we check from which system or ip a bip report got triggered? we are using a generic login shared across all developers and testers Content (required): can w…
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …
-
How to check Agent HistorySummary: How to check Agent History Content (required): As JOb history in BI shows executions of BI reports, do we have similar place to see executions of Agents ? Versi… -
OTBISummary: Hi Experts, I want to measure the performance for last 5 years, the year should be consist the data from July to Jun, instead of Jan to Dec. how I can convert t…
-
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Query on Retained earningsSummary: Retained Earning adjustments in Secondary Ledger Content (required): I have gone through this doc id Oracle General Ledger Year End Closing Process (Doc ID 6653…
-
Custom sort OTBI ColumnI have a column in my otbi analysis. They return me the values Exceeds Performance Expectations, Inadequate, Meets Performance Expectations ,Nearly there, No PMS Rating.…
-
Add Segment Description to OTBI ReportSummary: We have a report that uses the subject area General Ledger - Journals Real Time subject area, and we want to add the segment description for our 5 segment. We k… -
Setting Tab Names in Excel When Downloading an FRS ReportSummary Setting Tab Names in Excel When Downloading an FRS ReportContent I have 60+ Company (Balancing Segment) values. When I generate a report in FRS and then download… -
Fusion Role Required for Approval & ReportsContent This sounds like a basic question, however we did not get a convincing answer via My Oracle Support. We are a Finance & SCM customer, and we would like to know (… -
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
Is Oracle Fusion ERP Cloud is an approved software in Israel?Summary: Content (required): Is there any document or certificate that can prove Oracle Fusion ERP Cloud is an approved accounting software by Israel tax authority? Vers…
-
Some Prepayment Invoice amount showing doubleSummary: Content (required): Dear All We have an query which will fetch the Prepayment Invoice details , the query is working fine , but it is noticed that some of the i…
-
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
Need to Schedule ESS JOBSummary: Hi, Need to schedule a ESS job to run at 10 AM,11 AM,12AM and 1AM every day. Content (required): Need to schedule a ESS job to run at 10 AM,11 AM,12AM and 1AM e…
-
If I have multiple PVOs available for a table column, which one should I select?Summary: While mapping table columns to PVOs, I found in most cases we have multiple PVOs present. What should I consider while choosing a PVO? Content (required): Attac…
-
Moved: What is the subject area of Project Definition DFF on OTBI on Projects module?This discussion has been moved. -
Month end closure jobs in Oracle ERPSummary: I have a requirement to run the below jobs on demand in serial (one after another with single job set) Translate General Ledger Account Balances (Multiple Ledge…