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 »
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 »
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 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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 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 Form PersonalizationOracle apps ebs form personalization details
Query to find Form Personalization 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 »
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 »
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 »
