Menu in Oracle apps It is a logical or hierarchical listing of functions (forms) so that the user can easily navigate through the forms once he is in responsibility. A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it. Every […]
Query to check character set in oracle
In this post, we will check about Query to check character set in oracle, What is Database Character set What is Database Character set? Oracle Database uses character sets for the following: Data stored in SQL character data types (CHAR, VARCHAR2, CLOB, and LONG). Identifiers include table names, column names, and PL/SQL variables. Stored SQL […]
How to change/validate TDE Keystore Password
In this post, we will be checking, How to change TDE Keystore Password, How to validate the TDE wallet password How to change TDE Keystore Password Here are the steps to change TDE Keystore Password Rename the auto-login wallet file cwallet.sso in the wallet location $ mv cwallet.sso cwallet.sso_old Close the TDE encryption wallet sqlplus […]
How to submit a concurrent program from the backend
Concurrent Programs can be submitted from the backend ie. database using fnd_request.submit_request.We will check in this post the various code on How to submit a concurrent program from the backend Here is the Snippet of the API FUNCTION fnd_request.submit_request ( application IN VARCHAR2 DEFAULT NULL, program IN VARCHAR2 DEFAULT NULL, description IN VARCHAR2 DEFAULT NULL, […]
how to submit workflow background process from backend
Workflow is an important part of Oracle Ebiz Applications In this post, we will check out what is Workflow Background Engine, How to run Workflow Background Process from Unix, How to run Workflow Background Process using SQLPLUS, how to submit workflow background process from backend What is Workflow Background Engine The Background Engine is a […]
How to use Oracle LISTAGG Function
This is part of Oracle SQL tutorial and has good examples, explanation on Oracle LISTAGG Function. Oracle LISTAGG function Oracle LISTAGG function is an analytical function which allows us to concatenate the strings for measure_column for each GROUP based on the order_by_clause. This is present in Oracle from 11gR2 The syntax for the LISTAGG function in Oracle […]