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 »
