Recent Posts

Recent Posts

PTD and YTD balances query in Oracle R12

PTD and YTD balances query in Oracle R12...

Register a test concurrent program from backend in Oracle EBS

Register a test concurrent program from backend in Oracle EBS...

Supervisor Hierarchy and Approval Limits in Oracle EBS R12

Supervisor Hierarchy and Approval Limits in Oracle EBS R12 Supervisor...

Sales order line status query in Oracle apps

Sales order line status query in Oracle apps Oracle EBS...

Query to find all Expense report entry delegations

Query to find all Expense report entry delegationsOracle apps expense...

Query to find vacation rules in Oracle R12

Query to find vacation rules in Oracle R12Delegate rules audit...

Purchase Order Receipt details query in Oracle apps

Purchase Order Receipt details query in Oracle appsQuery to find...

Oracle apps query to find approval limits

Oracle apps query to find approval limitsPurchase requisition approval limits...

View accounting query in oracle apps R12

View accounting query in oracle apps R12Tools view accounting query...

Query to get AR invoice SLA and GL details

Query to get AR invoice SLA and GL detailsAR Transaction...

Accounting entries not transferred to the General Ledger

Accounting entries not transferred to the General LedgerSLA entries not...

View java class source in oracle database

View java class source in oracle databasejava class code that...

Load Java source code in oracle database

Load Java source code in oracle databaseCREATE OR REPLACE AND...

Query to get price list details in Oracle EBS

Query to get price list details in Oracle EBSoracle ebs...

Oracle R12 shipping status query

Oracle R12 shipping status querywsh_delivery_details RELEASED_STATUSwsh_new_deliveries STATUS_CODEOracle apps shipping status...

OAF customizations queries

OAF customizations queriesQuery to list all pages under any top/directoryQuery...

Oracle apps list of concurrent programs in a Request Set

Oracle apps list of concurrent programs in a Request SetR12...

Oracle apps AR Applications and SLA details

Oracle apps AR Applications and SLA detailsOracle EBS receivable applications...

Oracle EBS query to get AP Invoice SLA Details

Oracle EBS query to get AP Invoice SLA DetailsOracle apps...

Oracle EBS query to get AR Invoice SLA Details

Oracle EBS query to get AR Invoice SLA DetailsOracle apps...

Query to get Organization Hierarchy in Oracle apps

Query to get Organization Hierarchy in Oracle appsOracle EBS query...

Oracle AR Remit to address query

Oracle AR Remit to address queryQuery to get all remit...

Oracle Apps iExpense credit card details query

Oracle Apps iExpense credit card details queryOracle EBS iExpense credit...

Form function attached to which responsibility and user

Form function attached to which responsibility and userOracle apps Form...

E-Business suite tax rates and accounts query

E-Business suite tax rates and accounts queryEBTax tax rate detailsOracle...

Query to get Sales order and lines details in Oracle Apps

Query to get Sales order and lines details in Oracle...

Purchase Requisition Vertex debug xml query in Oracle EBS

Purchase Requisition Vertex debug xml query in Oracle EBSPO Requisition...

Purchase Order Vertex debug xml query in Oracle EBS

Purchase Order Vertex debug xml query in Oracle EBSPO Vertex...

AP Invoice Vertex debug xml query in Oracle EBS

AP Invoice Vertex debug xml query in Oracle EBS AP...

AR Invoice Vertex debug xml query in Oracle EBS

AR Invoice Vertex debug xml query in Oracle EBSAR Invoice...

Query to find the responsibility attached to user in oracle apps

How to find responsibilities attached to user in Oracle appsQuery...

How to enable debug log in Oracle apps EBS

How to enable debug log in Oracle apps EBSfnd debug...

Query to find and remove Oracle database locks

Query to find and remove Oracle database locksOracle database locksoracle...

PL SQL full form

PL SQL full formpl full form in sqlpl and sql...

Oracle Apps Procure To Pay Cycle (P2P Cycle)

Oracle Apps Procure To Pay Cycle (P2P Cycle)p2p cycle in...

Oracle Apps Order Management Tables

Oracle Apps Order Management Tablesorder management tables in oracle apps...

How to get JioFi Battery Low Notification on Windows

How to get JioFi Battery Low Notification on WindowsGet JioFi...

Oracle form attached to which responsibility

Oracle form attached to which responsibilityOracle form navigationoracle form responsibility...

Query to get workflow details

Query to get workflow details in oracle appsSQL to get...

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questionsinterview questions for oracle apps technicalpractice...

SQL query to get MIME type for file extension

Oracle SQL query to get MIME type for file extension...

Oracle EBS – Order Management Interview Questions

Oracle EBS – Order Management Interview QuestionsOracle Apps – Order...

Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview Questions

Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview QuestionsOracle...

Query to get concurrent program and executable details

SELECT fcpt.user_concurrent_program_name, fcp.concurrent_program_name, ...

Query to get responsibility level profile option values

Oracle Apps EBS query to get responsibility level profile option...

Query to get attribute values of Inventory Item Template

Query to get attribute values of Inventory Item TemplateOracle apps...

Query to get details of WIP discrete jobs

Query to get details of WIP discrete jobs Oracle apps...

Query to get Customer Bank Account Details

Query to get Customer Bank Account Detailsoracle apps ebs Customer...

Query to get description of GL Code Combination

Query to get description of GL Code Combination Oracle Apps...

PL-SQL code to add responsibility to application user

PL-SQL code to add responsibility to application user Oracle apps...

PL-SQL code to reset application user password

PL-SQL code to reset application user passwordOracle apps Reset application...

PL-SQL code to write a file

PL-SQL code to write a fileOracle apps ebs plsql to...

PL-SQL code to read a file

PL-SQL code to read a fileOracle apps ebs plsql to...

Query to find second and third highest value

Query to find second and third highest valueSQL query to...

PL-SQL Procedure to send email with attachment

PL-SQL Procedure to send email with attachmentHow to send email...

PL-SQL to delete Concurrent Program and Executable

PL-SQL to delete Concurrent Program and ExecutableHow to delete Concurrent...

PL-SQL code to delete XML/BI Publisher template and Data Definition

PL-SQL code to delete XML/BI Publisher template and Data Definitiondelete...

Query to find Purchase Order and Invoice Details

Query to find Purchase Order and Invoice DetailsOracle apps ebs...

Query to find AP Invoices matched with receipts

Query to find AP Invoices matched with receiptsOracle apps ebs...

Query to find Table size

Query to find Table sizeOracle apps EBS table size...

Query to find Form Personalization

Query to find Form PersonalizationOracle apps ebs form personalization details...

Query to find Supplier Bank Details

Query to find Supplier Bank Details Oracle apps EBS sql...

Query to find Credit Memos on an AP invoice

Query to find Credit Memos on an AP invoiceOracle apps...

Query to find profile option values

Query to find profile option values Oracle apps EBS profile...

Query to get details of concurrent program parameters

Query to get details of concurrent program parameters Oracle apps...

PL-SQL Code to find Menu Hierarchy of a responsibility

PL-SQL Code to find Menu Hierarchy of a responsibility Oracle...

Query to find details of Flex value sets

Query to find details of Flex value sets Oracle Apps...

Query to find concurrent program Responsibility and Request Group

Query to find concurrent program Responsibility and Request GroupOracle apps...

Query to find BOM and Routings data

Query to find BOM and Routings data Oracle apps sql...

Concurrent program SQL statement currently running in background

Concurrent program SQL statement currently running in background Oracle apps...

AR Invoice grouping rule from RA_INTERFACE_LINES_ALL

AR Invoice grouping rule from RA_INTERFACE_LINES_ALL Oracle Receivables AR to...

Query to find shipset and fulfilment set

Query to find shipset and fulfilment setOracle apps shipset and...

Query to find scheduled concurrent programs

Query to find scheduled concurrent programsOracle apps sql query for...

Query to kill database session for a concurrent request

Query to kill database session for a concurrent requestOracle apps...

Query to get DFF (Descriptive Flex Field) Details

Query to get DFF (Descriptive Flex Field) DetailsOracle Apps sql...

No post found