Tech7.in … Oracle apps reusable queries, interview questions, practice questions, exam questions and lot more….
Oracle EBS Technical Interview Questions and Answers
- Oracle Apps Procure To Pay Cycle (P2P Cycle)
- Oracle Apps Order Management Tables
- Oracle SQL PLSQL Interview Questions
- Oracle EBS – Order Management Interview Questions
- Oracle Forms and Reports – Practice Questions
- Oracle Forms and Reports – Practice Questions -2
- Oracle Forms and Reports – Practice Test
- Oracle Forms and Reports – Practice Questions
- Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview Questions
Oracle EBS Useful Queries
- How to Retrieve Period to Date (PTD) and Year to Date (YTD) Balances of GL Account in Oracle R12
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Sales order line status query in Oracle apps
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- Purchase Order Receipt details query in Oracle apps
- Oracle apps query to find approval limits
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- View java class source in oracle database
- Load Java source code in oracle database
- Query to get price list details in Oracle EBS
- Query to find all APIs of Oracle Apps modules
- Oracle R12 shipping status query
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Form function attached to which responsibility and user
- E-Business suite tax rates and accounts query
- Query to get customer tax registration details in R12
- Query to get Sales order and lines details in Oracle Apps
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS
- Query to find and remove Oracle database locks
- How to add AME role and responsibility to user
- Oracle form attached to which responsibility
- Query to get workflow details
- Query to find serial number material transactions details
- SQL query to get MIME type for file extension
- Query to get concurrent program and executable details
- Query to get responsibility level profile option values
- Query to validate migration of XML/BI Publisher Template and Data Definition
- Query to get details of XML/BI Publisher Template and Data Definition
- Query to get Site level and Organization level Profile Option Value
- Query to get attribute values of Inventory Item Template
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get details of WIP discrete jobs
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- PL-SQL code to reset application user password
- PL-SQL code to write a file
- PL-SQL code to read a file
- Query to find second and third highest value
- PL-SQL Procedure to send email with attachment
- PL-SQL to delete Concurrent Program and Executable
- Query to get the details of the lock in the database
- PL-SQL code to delete XML/BI Publisher template and Data Definition
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Table size
- Query to find Form Personalization
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- Query to find profile option values
- Query to get details of concurrent program parameters
- PL-SQL Code to find Menu Hierarchy of a responsibility
- Query to find details of Flex value sets
- Query to find concurrent program Responsibility and Request Group
- Query to find BOM and Routings data
- Concurrent program SQL statement currently running in background
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set
- Query to find scheduled concurrent programs
- Query to kill database session for a concurrent request
- Query to get DFF (Descriptive Flex Field) Details
Oracle Cloud Exam Questions and Answers
- Oracle Procurement Cloud – Practice Questions
- Oracle Cloud Platform Application Integration – Practice Questions
Tech7.in … Oracle apps reusable queries, interview questions, practice questions, exam questions and lot more….