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 write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report… -
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win… -
Customize Print Receivables Transaction for all Invoice TypesSummary Customize Print Receivables Transaction for all Invoice TypesContent Hello, Oracle has provided 4 different templates for 4 Invoice Types: Invoice, Debit Memo, C… -
OTBI custom folder security in production VS test environmentsSummary How are you managing your OTBI custom folder security from Production to Test when different?Content I our current environment we have several self service users… -
Impersonation auditingContent Hi, I want to know if it is possible to know what a user did on behalf of another (as a proxy) I read that document about impersonation auditing and did the conf…
-
How to track the BI publisher report which calling the specific table and attributeContent Hi, How to track the BI publisher report that calling the specific table (eg.POZ_BUS_CLASSIFICATIONS) and attribute. Thanks, Felicia
-
Projects Unprocessed Costs Error DetailsSummary Get detail of Projects Unprocessed Costs ErrorsContent I am trying to build a report using the Project Costing - Unprocessed Costs Real Time to build a report wi…
-
in gl, how i get parent of account ?Content in gl i need to get parent of account segment , how i do this ? in table gl_seg_val_hier_rf i don't have data .
-
OTBI report - Issue with Expense Transactions Real Time subject areaSummary OTBI report using this subject area no longer shows data from prior assignmentsContent We have an SR for this issue but I'm wondering if anyone else has noticed … -
Finance Cross Validation RulesContent Other than the help guide are there any Best Practices for Cross-Validation Rules? Version 21A -
TIMESTAMPADD function in OTBI reporting in UTC and not ESTContent We are using the below function to fetch the data for the previous month in OTBI Reporting & noticed it extracting the data based on UTC time zone and not EST. I…
-
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
Etext negative number paddingSummary Etext negative number paddingContent Hi All. We have a requirement to dispay a number like -123 as -00012300. Please suggest how this is possible in Etext templa…
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
saas fusion data retention polity - access to transactional dataSummary what is the period users are able to access transactional data (10 yrs?)Content For Fusion financials, users would like to be able to access transactional data f…
-
what is the difference between YTD AND QTD ?Content what is the difference between YTD AND QTD ? Special in first period.
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…
-
Safest/default Path to Publishing changes to GL (Essbase) Trees: Publish Chart of Account DimensionSummary We have been experiencing issues in making changes to GL tree structures in OTBI, so I wanted to be clear on what the options are for each step, to eliminate the…
-
Project Actual Costs - Account CodeSummary Project Actual Costs - Account CodeContent We are creating a report using the Project Costing - Actual Costs Real Time subject area. We are pulling cost distribu…
-
BICC - Selecting Columns from Data Stores Impacts other reportsSummary How to configure BICC reportsContent We are currently working on our migration to Oracle Fusion. I am tasked with looking at extracting data via BICC. How can I …User_2025-02-11-01-36-32-048 209 views 1 comment 2 points Most recent by User_2025-02-11-01-36-32-048
-
LicensingSummary Oracle Database Cloud Multitenant Service - S5 & Oracle Java Cloud Service - SaaS Extension - S1Content Does anyone know what these 2 products are for? Oracle Da…
-
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP…
-
How can i get two different BU BalancesContent Dear , I have one ledger but two Business units. For that i need balances for both Business units. So create a query from gl_balances table but issue is its show… -
in ar i need to get sum lines , sum discount ,sum taxes for each invoice and for each lineContent in ar i need to get sum lines , sum discount ,sum taxes for each invoice and for each line.
-
Help with OTBI Filter ErrorSummary Error when filtering for a date rangeContent Hello, I am having 2 issues. 1. I am trying to create a filter using Invoice Date where report would show all invoic…
-
in gl how i get balance for each account(ptd,qtd and ytd)Content i need to get balance for each account (ptd,qtd and ytd). also i need to get balance for each account and cost center (ptd,qtd and ytd).
-
Number of Accounting Periods in Accounts Receivable for OTBI ReportingContent We have a thirteen period calendar setup in Oracle, each period is four weeks. When we attempt to write OTBI reports we are only seeing 12 periods. My question i…
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…
-
how i get gl date in ar moduleContent i created a new report in ar ar module, i use table RA_CUSTOMER_TRX_ALL but i can't find gl date for invoice, how i get gl date ?