admin

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 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 »

PL SQL full form

PL SQL full formpl full form in sqlpl and sql full formfull form pl sql PL SQL full form-PL/SQL stands for Procedural Language/Structured Query Language

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 »

How to add AME role and responsibility to user

How to add AME role and responsibility to user in oracle appsAdd AME responsibilityAME setup in oracle apps r12AME workflow in oracle appsapproval management engine in oracle apps r12AME setup in oracle appsAME responsibility role attached to userhow do I add roles to AMEthere are no valid navigation AME Errororacle add ame responsibility to user …

How to add AME role and responsibility to user Read More »

How to get JioFi Battery Low Notification on Windows

How to get JioFi Battery Low Notification on WindowsGet JioFi Battery NotificationJioFi battery notifierJiofi Low Battery Notification for windows/ Windows10jiofi indicatorswifi battery monitor Working from home is a new normal for IT professionals and most of them use JioFi device for the internet connectivity. One major problem faced by JioFi users is while they are …

How to get JioFi Battery Low Notification on Windows Read More »

Query to get workflow details

Query to get workflow details in oracle appsSQL to get workflow activity historyBackend query for workflow 1. Query to get workflow item details 2. Query to get workflow activity history If you have read only access to apps user objects, please use below query.

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questionsinterview questions for oracle apps technicalpractice sql for interviewbasic interview questions in sqlexercise sqlpractice sqlquery questions in sqlsql practice for interviewpractice questions for sqlpractical sql interview questions

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 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/