Sample Reports
Discussion List
-
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C…Sushan Peiris 1 view 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 22 views 6 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi… -
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s… -
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
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…SimonTomey 65 views 6 comments 8 points Most recent by Marisa Escobar Reporting and Analytics for ERP -
FBDI Fails to import Data containing Double Quotes(")Summary: FBDI Fails to import Data containing Double Quotes("). We are loading Items through "ItemImportTemplate" FBDI template. In item description we have data like WO…Lucky Sharma 11 views 8 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 975 views 37 comments 18 points Most recent by User_H52DZ Reporting and Analytics for ERP
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 183 views 0 comments 0 points Started by Anne Wong -Oracle Reporting and Analytics for ERP -
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…Eren Göktepe-155015 19 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 1 view 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 1 view 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB…Swapnil Kashid 2 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 11 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…
-
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise.Soumya Prakash Parhi 94 views 2 comments 7 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Sample OTBI Reports: Budgetary ControlSummary OTBI Reports for Budgetary Control and Carry ForwardContent These are sample reports for customers using Budgetary Control to assist them in managing their contr…Linda Wong-Oracle 478 views 7 comments 7 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 769 views 14 comments 15 points Most recent by AnimeshAgrawal-Oracle Reporting and Analytics for ERP -
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…Sushan Peiris 19 views 1 comment 1 point Most recent by Sushan Peiris Reporting and Analytics for ERP
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 1.5K views 25 comments 27 points Most recent by Piyush Arora Reporting and Analytics for ERP
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie…Mike Burnett 2 views 4 comments 4 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a…
-
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 557 views 13 comments 13 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP
-
Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…Rohit Kumar Singh 6 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 12 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th…Sushan Peiris 19 views 6 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 18 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP