Oracle EBS

View accounting query in oracle apps R12

View accounting query in oracle apps R12Tools view accounting query in oracle EBSOracle receivables subledger accounting SLA queryOracle Payables subledger accounting SLA query Tools>>view accounting option can be seen on multiple forms of Oracle R12, such as Oracle Receivables transactions, Oracle Payables invoice screen, Receivable adjustments and so on. The underlying query for the view

View accounting query in oracle apps R12 Read More »

Accounting entries not transferred to the General Ledger

Accounting entries not transferred to the General LedgerSLA entries not transferred to GLQuery to get subledger entries that are not transferred to General LedgerOracle apps XLA entries that are not transferred to GLOracle EBS R12 accounting entries not transferred to the general ledgeroracle r12 transfer journal entries to glaccounting entries not transferred to the general

Accounting entries not transferred to the General Ledger Read More »

Oracle apps query to find incompatible programs blocking a concurrent request

Oracle apps query to find incompatible programs blocking a concurrent requestOracle EBS incompatible concurrent requests sql queryConcurrent program incompatibility query for pending standby requests Run the below query if you see any concurrent program in pending standby status for long time.The below query returns the incompatible program requests running due to which the request is

Oracle apps query to find incompatible programs blocking a concurrent request Read More »

Query to find the responsibility attached to user in oracle apps

How to find responsibilities attached to user in Oracle appsQuery to find the responsibility attached to user in oracle appsQuery to fetch Responsibilities attached to a UserQuery to find users attached to responsibilityHow to check user responsibility in Oracle appsOracle EBS user responsibilitiesOracle apps responsibility users

Query to find the responsibility attached to user in oracle apps Read More »

Query to find and remove Oracle database locks

Query to find and remove Oracle database locksOracle database locksoracle lock tableblocking session in oracleoracle deadlockoracle lockoracle locked objectsquery to check locks in oracle databaseoracle table lock queryoracle show locksfind blocking session in oracleoracle db lockoracle check locksquery to find locked objects in oracleoracle check table lockHow to find the Oracle database locksHow to remove

Query to find and remove Oracle database locks Read More »

Oracle Apps Order Management Tables

Oracle Apps Order Management Tablesorder management tables in oracle apps r12oracle order management tablesom tables in oracle apps r12Oracle EBS Order Management related TablesOrder Management interview questions Order Management Tables. Enteredoe_order_headers_all 1 record created in header tableoe_order_lines_all Lines for particular recordsoe_price_adjustments When discount gets appliedoe_order_price_attribs If line has price attributes then populatedoe_order_holds_all If any hold

Oracle Apps Order Management Tables Read More »

Oracle EBS – Order Management Interview Questions

Oracle EBS – Order Management Interview QuestionsOracle Apps – Order Management Interview Questions   1. What are the Base Tables and Interface Tables for Order Management?Interface Tables:OE_HEADERS_IFACE_ALLOE_LINES_IFACE_ALLOE_PRICE_ADJS_IFACE_ALLOE_ACTIONS_IFACE_ALLOE_CREDITS_IFACE_ALL (Order holds like credit check holds etc) Base Tables:OE_ORDER_HEADERS_ALL: Order Header InformationOE_ORDER_LINES_ALL: Items InformationOE_PRICE_ADJUSTMENTS: Discounts InformationOE_SALES_CREDITS: Sales Representative Credits. Shipping Tables:WSH_NEW_DELIVERIESWSH_DELIVERY_DETAILSWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERIES.   2. What is Order Import and

Oracle EBS – Order Management Interview Questions Read More »

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

Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview QuestionsOracle Reports Frequently Asked QuestionsOracle Reports Interview QuestionsOracle Reports FAQ What is a Lexical Parameter? Lexical parameters are used to substitute multiple values at runtime and are identified by a preceding ‘&’. Lexicals can consist of as little a one line where clause to an entire

Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview Questions Read More »

Query to validate migration of XML/BI Publisher Template and Data Definition

Query to validate migration of XML/BI Publisher Template and Data DefinitionSQL Query to verify Oracle XML/BI Publisher template and data definition migrationxdo tables in oracle apps r12Oracle xdo tablesOracle xml publisher backend queryBI Publisher setup validation For more reusable queries, click https://tech7.in/category/technologyblog/oracle/ Click https://tech7.in/technologyblog/oracle/query/query-to-get-details-of-xml-bi-publisher-template-and-data-definition/to view Query to get details of XML/BI Publisher Template and Data

Query to validate migration of XML/BI Publisher Template and Data Definition Read More »

Query to get details of XML/BI Publisher Template and Data Definition

Query to get details of XML/BI Publisher Template and Data Definitionxdo tables in oracle apps r12Oracle xdo tablesOracle xml publisher backend queryOracle EBS apps Query to get details of XML/BI Publisher Template and Data Definition For more reusable queries, click https://tech7.in/category/technologyblog/oracle/

Query to get details of XML/BI Publisher Template and Data Definition Read More »

Query to get Site level and Organization level Profile Option Value

Query to get Site level and Organization level Profile Option ValueProfile Option queryProfile Option Value QueryOracle Apps Profile Option value query Query to get Site level Profile Option Value   Query to get Organization level Profile Option Value For more reusable queries, click https://tech7.in/category/technologyblog/oracle/

Query to get Site level and Organization level Profile Option Value Read More »

Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets

Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assetsoracle apps sql query for period statusperiod status backend query for Inventory, General Ledger, Purchasing, Payables, Receivables, Fixed Assets Period status for Inventory Period status for GL, PO, AP, AR, FA For more reusable queries, click https://tech7.in/category/technologyblog/oracle/

Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets Read More »

Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation

Oracle apps EBS sql to get Fixed Asset FA details with Net Book Value NBV and DepreciationQuery to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation How to find net book value in Oracle

Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation Read More »

PL-SQL Procedure to send email with attachment

PL-SQL Procedure to send email with attachmentHow to send email using plsqlHow to send email with attachment using plsqloracle send email from databaseoracle send email with attachment utl_smtp 1.  Compile the below procedure XXSEND_EMAIL in the database 2.  Call the procedure with below anonymous block Please note that the Workflow mailer should be up and running

PL-SQL Procedure to send email with attachment Read More »

Concurrent program SQL statement currently running in background

Concurrent program SQL statement currently running in background Oracle apps current sql queryoracle sql running in sessionoracle sql running in background Step1 :  Run the below query ,  this will list all the programs that currently running in Application. Take the SID and use it in the second query. Step 2 : Get SID from

Concurrent program SQL statement currently running in background Read More »