PTD and YTD balances query in Oracle R12 Understanding PTD and YTD Balances In the world of financial management, understanding your balances is crucial. Period to Date (PTD) and Year to Date (YTD) balances are key indicators of financial performance. In Oracle R12, these balances provide insight into your organization’s financial standing within a specified […]
Register a test concurrent program from backend in Oracle EBS Create concurrent program using PLSQL Create concurrent program executable using PLSQL
Register a test concurrent program from backend in Oracle EBS Read More »
Supervisor Hierarchy and Approval Limits in Oracle EBS R12 Supervisor Hierarchy query in Oracle apps R12 Approval Limits query in Oracle apps R12
Supervisor Hierarchy and Approval Limits in Oracle EBS R12 Read More »
Sales order line status query in Oracle apps Oracle EBS query to find sales order line status as seen in frontend Flow status code meaning oe_order_lines_all
Sales order line status query in Oracle apps Read More »
Query to find all Expense report entry delegationsOracle apps expense report entry delegation setup details oracle apps EBSExpense report entry delegation audit query in R12oracle cloud expense report delegation
Query to find all Expense report entry delegations Read More »
Query to find vacation rules in Oracle R12Delegate rules audit query in Oracle APPS EBSWorkflow approval delegations in sql queryVacation rules setup query in oracle appsVacation rule audit query in Oraclevacation rule in oracle apps r12
Query to find vacation rules in Oracle R12 Read More »
Purchase Order Receipt details query in Oracle appsQuery to find PO receipts in Oracle EBS R12po receipts table in oracle apps r12po receipt oracle appspo receiving tables in oracle apps r12
Purchase Order Receipt details query in Oracle apps Read More »
Oracle apps query to find approval limitsPurchase requisition approval limits query in R12Purchasing approval limits in Oracle EBSapproval limits in oracle purchasingr12 approval limits query
Oracle apps query to find approval limits Read More »
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 »
Query to get AR invoice SLA and GL detailsAR Transaction Subledger and general ledger detailsOracle receivable subledger accounting and general ledger linkOracle apps AR SLA and gl details
Query to get AR invoice SLA and GL details Read More »
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 »
View java class source in oracle databasejava class code that is compiled in databasejava class is compiled successfully and is validquery java object in Oracle database Click HERE for steps to compile java object in Oracle database
View java class source in oracle database Read More »
Load Java source code in oracle databaseCREATE OR REPLACE AND RESOLVE JAVA SOURCECompile java code in oracle databaseCall java in oracle apps database procedurewriting java code in oracle databasecreate java code in oracle database Below is a sample java class that we will compile and call from database function Step 1: Compile the below java
Load Java source code in oracle database Read More »
Query to get price list details in Oracle EBSoracle ebs price list tablesOracle apps price list queryoracle apps price list tables
Query to get price list details in Oracle EBS Read More »
Query to find all APIs of Oracle Apps modulesQuery to list all APIs in Oracle EBSList of all Oracle apps APIsSyntax of Oracle EBS APIsoracle ebs api listoracle ebs inventory api
Query to find all APIs of Oracle Apps modules Read More »
Oracle R12 shipping status querywsh_delivery_details RELEASED_STATUSwsh_new_deliveries STATUS_CODEOracle apps shipping status and delivery status
Oracle R12 shipping status query Read More »
OAF customizations queriesQuery to list all pages under any top/directoryQuery to list all customizations on a OAF pageQuery to get xml code of an OAF page/moduleQuery to delete any OAF customizationQuery to find all changes done to OAF Pages in the application Query to list all pages under any top/directory Query to list all customizations
OAF customizations queries Read More »
Oracle apps list of concurrent programs in a Request SetR12 query to get request set stages and concurrent programsOracle EBS request set details queryOracle apps request set query
Oracle apps list of concurrent programs in a Request Set Read More »
R12 AR cash receipt SLA and GL details queryEBS Oracle apps Receivables cash receipt subledger accounting and General Ledger details queryar_cash_receipts_all xla_ae_headers xla_ae_lines gl_je_headers gl_je_lines
R12 AR cash receipt SLA and GL details query Read More »
Oracle apps AR Applications and SLA detailsOracle EBS receivable applications and xla details queryAR_RECEIVABLE_APPLICATIONS_ALL and xla_ae_lines join R12
Oracle apps AR Applications and SLA details Read More »
Oracle EBS query to get AP Invoice SLA DetailsOracle apps query to find Payables invoice and XLA table detailsap_invoices_all and xla_ae_headers joinR12 payables and subledger accounting join
Oracle EBS query to get AP Invoice SLA Details Read More »
Oracle EBS query to get AR Invoice SLA DetailsOracle apps query to find Receivable transaction and XLA table detailsra_customer_trx_all and xla_ae_headers joinR12 receivables and subledger accounting join
Oracle EBS query to get AR Invoice SLA Details Read More »
Query to get Organization Hierarchy in Oracle appsOracle EBS query to get organization structureOracle R12 sql to find the operating unit and warehouse inventory org structure
Query to get Organization Hierarchy in Oracle apps Read More »
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 »
Oracle AR Remit to address queryQuery to get all remit to addresses in the systemOracle apps receivables remit to addressesOracle EBS R12 remit to address query
Oracle AR Remit to address query Read More »
Oracle Apps iExpense credit card details queryOracle EBS iExpense credit card tablesiExpense credit card transactions queryiExpense Employee credit card tableiExpense credit card bankdetails query
Oracle Apps iExpense credit card details query Read More »
Form function attached to which responsibility and userOracle apps Form function responsibilityOracle ebs form responsibility
Form function attached to which responsibility and user Read More »
E-Business suite tax rates and accounts queryEBTax tax rate detailsOracle apps tax tablesOracle apps r12 tax rates tablesE-Business suite tax rates and GL accounts
E-Business suite tax rates and accounts query Read More »
Query to get customer tax registration details in R12oracle apps r12 tax tablescustomer tax registration number in oracle apps r12 queryoracle apps customer tax id query
Query to get customer tax registration details in R12 Read More »
Query to get Sales order and lines details in Oracle AppsBackend query to get sales order details in Oracle EBSorder type table in oracle appsQuery to get sales order ship to address in Oracle Appsquery to get ship to address and bill to address in oracle appsOracle Order Management SQL queriesSales order query in Oracle
Query to get Sales order and lines details in Oracle Apps Read More »
Purchase Requisition Vertex debug xml query in Oracle EBSPO Requisition Vertex debug xml Oracle appsVertex debug Oracle R12
Purchase Requisition Vertex debug xml query in Oracle EBS Read More »
Purchase Order Vertex debug xml query in Oracle EBSPO Vertex debug xml Oracle appsVertex debug Oracle R12
Purchase Order Vertex debug xml query in Oracle EBS Read More »
AP Invoice Vertex debug xml query in Oracle EBS AP Invoice Vertex debug xml Oracle apps Vertex debug Oracle R12
AP Invoice Vertex debug xml query in Oracle EBS Read More »
AR Invoice Vertex debug xml query in Oracle EBSAR Invoice Vertex debug xml Oracle appsVertex debug Oracle R12
AR Invoice Vertex debug xml query in Oracle EBS Read More »
Query to find AP invoice workflow item key in oracle appsAP invoice workflow item key in Oracle EBS APINVAPR workflow item key in Oracle R12AP invoice workflow details AP invoice workflow activity history Use query in the below post to get workflow activity history
Query to find AP invoice workflow item key in oracle apps Read More »
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 »
How to enable debug log in Oracle apps EBSfnd debug log enabledHow to enable debug mode in Oracle Apps R12How to enable Debug for Concurrent program in Oracle appsDebug profile option in Oracle apps Set below profile option values to debug everything : FND: Debug Log Enabled YESFND: Debug Log Filename NULLFND: Debug Log Level
How to enable debug log in Oracle apps EBS Read More »
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 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 Procure To Pay Cycle (P2P Cycle)p2p cycle in oracle appsp2p cycle in oracle apps r12p2p cycle in oracle apps r12 techno functionaloracle ebs procure to pay process flowOracle Apps Procure To Pay Cycle in Oracle Apps R12 (P2P Cycle)Oracle EBS Step by step complete Procure to Pay cycle Oracle purchase order flow Procure
Oracle Apps Procure To Pay Cycle (P2P Cycle) Read More »
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 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 »
Oracle form attached to which responsibilityOracle form navigationoracle form responsibility query For this we should have the form function_ id first. If you already have the form function_id, skip to step 3. Else follow steps 1 and 2. Step 1: Find the form name If you know some navigation of the form, open the form
Oracle form attached to which responsibility Read More »
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.
Query to get workflow details Read More »
Oracle Procurement Cloud – Practice Questions
Oracle Procurement Cloud – Practice Questions Read More »
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 SQL PLSQL Interview Questions Read More »
Oracle apps query to find serial number material transactions detailsjoin between mtl_material_transactions and serial_numberHow to join mtl_material_transactions and mtl_serial_numbers For more reusable queries, click https://tech7.in/category/technologyblog/oracle/
Query to find serial number material transactions details Read More »
Oracle SQL query to get MIME type for file extension For more reusable queries, click https://tech7.in/category/technologyblog/oracle/
SQL query to get MIME type for file extension Read More »
Oracle Cloud Platform Application Integration – Practice Questions
Oracle Cloud Platform Application Integration – Practice Questions Read More »
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 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 »
SELECT fcpt.user_concurrent_program_name,
fcp.concurrent_program_name,
fat.application_name,
fet.executable_name,
fate.application_name exe_application,
flv.meaning execution_method,
fet.execution_file_name,
fcp.enable_trace
Query to get concurrent program and executable details Read More »
Oracle Apps EBS query to get responsibility level profile option valuesHow to find profile option value at responsibility levelOracle Profile Options For more reusable queries, click https://tech7.in/category/technologyblog/oracle/
Query to get responsibility level profile option values Read More »
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 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 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 get attribute values of Inventory Item TemplateOracle apps Inventory item template extractMTL_ITEM_TEMPLATES_ALL_V For more reusable queries, click https://tech7.in/category/technologyblog/oracle/
Query to get attribute values of Inventory Item Template Read More »
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/
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
Query to find Sales Orders that are shipped but not invoiced Oracle apps EBS sql to find Sales Orders that are shipped but not invoiced How to find sales orders shipped but invoice not created
Query to find Sales Orders that are shipped but not invoiced Read More »
Query to get details of WIP discrete jobs Oracle apps EBS sql to get details of WIP discrete jobsoracle wip tablesoracle wip query
Query to get details of WIP discrete jobs Read More »
Query to get Customer Bank Account Detailsoracle apps ebs Customer Bank Account Detailsoracle apps ebs sql for Customer Bank
Query to get Customer Bank Account Details Read More »
Query to get description of GL Code Combination Oracle Apps EBS sql to get description of GL Code Combination
Query to get description of GL Code Combination Read More »
PL-SQL code to add responsibility to application user Oracle apps EBS add responsibility to user from backendScript to add responsibility to user
PL-SQL code to add responsibility to application user Read More »
PL-SQL code to reset application user passwordOracle apps Reset application user password from backend For more reusable queries, click https://tech7.in/category/technologyblog/oracle/
PL-SQL code to reset application user password Read More »
PL-SQL code to write a fileOracle apps ebs plsql to write a filehow to write a file using plsql
PL-SQL code to write a file Read More »
PL-SQL code to read a fileOracle apps ebs plsql to read a filehow to read a file using plsql
PL-SQL code to read a file Read More »
Query to find second and third highest valueSQL query to find second and third highest value in empid columnReplace empid column name with salary to apply the logic on salary column
Query to find second and third highest value Read More »
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 »
PL-SQL to delete Concurrent Program and ExecutableHow to delete Concurrent Program and Executable in Oracle Apps EBSDelete concurrent program Example:
PL-SQL to delete Concurrent Program and Executable Read More »
Query to get the details of the lock in the databaseHow to find database locksOracle Apps EBS database locks
Query to get the details of the lock in the database Read More »
PL-SQL code to delete XML/BI Publisher template and Data Definitiondelete XML/BI Publisher template and Data DefinitionOracle apps ebs delete bi publisheroracle delete xml template
PL-SQL code to delete XML/BI Publisher template and Data Definition Read More »
Query to find Purchase Order and Invoice DetailsOracle apps ebs Purchase Order and Invoice linkoracle purchase order queryoracle purchase order tables
Query to find Purchase Order and Invoice Details Read More »
Query to find AP Invoices matched with receiptsOracle apps ebs AP Invoices matched with receipts
Query to find AP Invoices matched with receipts Read More »
Query to find Table sizeOracle apps EBS table size
Query to find Table size Read More »
Query to find Form PersonalizationOracle apps ebs form personalization details
Query to find Form Personalization Read More »
Query to find Supplier Bank Details Oracle apps EBS sql to find Supplier Bank Details
Query to find Supplier Bank Details Read More »
Query to find Credit Memos on an AP invoiceOracle apps ebs Credit Memos on an AP invoice
Query to find Credit Memos on an AP invoice Read More »
Query to find the AP invoices that are applied to multiple Purchase Orders Oracle apps ebs sql to find the AP invoices that are applied to multiple Purchase Orders
Query to find the AP invoices that are applied to multiple Purchase Orders Read More »
Query to find profile option values Oracle apps EBS profile option value queryquery to check profile values in oracle appsHow to check profile options in Oracle apps from backendQuery to find profile option values at user and responsibility levelProfile option levels in Oracle Apps R12query to get system profile values in oracle appsoracle profile option
Query to find profile option values Read More »
Query to get details of concurrent program parameters Oracle apps EBS concurrent program parameters query
Query to get details of concurrent program parameters Read More »
PL-SQL Code to find Menu Hierarchy of a responsibility Oracle apps ebs query to find Menus of responsibility
PL-SQL Code to find Menu Hierarchy of a responsibility Read More »
Query to find details of Flex value sets Oracle Apps sql query to find of value set values Query to find list of values of Independent value set Query to find details of Table Value set
Query to find details of Flex value sets Read More »
Query to find concurrent program Responsibility and Request GroupOracle apps concurrent program responsibility query Oracle ebs concurrent program attached to which responsibility concurrent program attached to request group query
Query to find concurrent program Responsibility and Request Group Read More »
Query to find BOM and Routings data Oracle apps sql query to get BOM and Routings details Query to find Routings data Query to find BOM Data
Query to find BOM and Routings data Read More »
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 »
AR Invoice grouping rule from RA_INTERFACE_LINES_ALL Oracle Receivables AR to Order management OM interface grouping
AR Invoice grouping rule from RA_INTERFACE_LINES_ALL Read More »
Query to find shipset and fulfilment setOracle apps shipset and fulfillment set query
Query to find shipset and fulfilment set Read More »
Query to find scheduled concurrent programsOracle apps sql query for scheduled concurrent requestsoracle scheduled jobs queryoracle scheduled jobs tableoracle scheduled concurrent requests query
Query to find scheduled concurrent programs Read More »
Query to kill database session for a concurrent requestOracle apps backend sql to end database session for a concurrent requestOracle apps how to terminate concurrent request from backend Step 1: Step 2: Step 3:
Query to kill database session for a concurrent request Read More »
Query to get DFF (Descriptive Flex Field) DetailsOracle Apps sql to get dff detailsDff DefinitionDescriptive flexfield
Query to get DFF (Descriptive Flex Field) Details Read More »
