Send HTML Email with Attachment
Step 1: Create directory and grant permission Step 2: create table IMAGE_STORE1 and load the file from directory to the blob Step 3: Compile the below Scripts in user create…
Read MoreScript to Load file from Directory to Blob column
create or replace PROCEDURE load_file( pi_id IN INTEGER, pfname IN VARCHAR2) IS SRC_FILE bfile; dst_file BLOB:= EMPTY_BLOB(); lgh_file BINARY_INTEGER; BEGIN src_file := bfilename(‘dir’, pfname);…
Read MoreOracle 18c- From a Developer's Perspective
Oracle 18C : 1. Why 18c from 12c? 2. 18c Key features from Developer’s Stand Point — PL/SQL & SQL Related Enhancements *Private Temporary Tables *Approximate Top-N Query Processing *Inline External Tables…
Read MorePurchase Order Creation with GST
Please find the below steps for creating the Purchase Order creation with GST Responsibility: India Local Purchasing Navigation: Oracle Purchasing > Purchase Orders > Purchase Orders Select the DFF Click…
Read MoreAuto Lock Box – Basic Concepts and Implementation Steps
Auto Lock Box Implementation : What is Lock Box : => Lockbox is a service offered by banks to companies in which the company receives payments from their customers by…
Read MoreManual AP Invoice Creation with GST
Manual AR Invoice. Please find the below steps for creating AR Transaction with GST Responsibility: India Local Receivables Navigation: Oracle Receivables > Transactions > Transactions Provide the Source, Select the…
Read MoreOracle SQL to get Profile Option Values at Responsibility level
SELECT frv.responsibility_name, fpo.profile_option_name, fpot.user_profile_option_name, fpov.profile_option_value FROM fnd_profile_options_tl fpot, fnd_profile_options fpo, fnd_profile_option_values fpov, FND_RESPONSIBILITY_VL frv WHERE fpot.profile_option_name = fpo.profile_option_name AND fpo.profile_option_id = fpov.profile_option_id…
Read MoreOracle SQL to get the Menu and Submenu list against a responsibility
SELECT FRV.responsibility_name, fm.menu_name, FMEV.ENTRY_SEQUENCE, FMEV.PROMPT, FMEV.DESCRIPTION, SUB_MENU_FMEV.USER_MENU_NAME SUB_MENU_NAME, SUB_MENU_FMEV.DESCRIPTION SUB_MENU_DESCRIPTION, FFFT.USER_FUNCTION_NAME, FMEV.GRANT_FLAG FROM apps.FND_MENU_ENTRIES_VL FMEV, apps.FND_MENUS_TL SUB_MENU_FMEV, APPS.FND_FORM_FUNCTIONS_TL FFFT, …
Read MoreORA-30006: resource busy; acquire with WAIT timeout expired and ORA-00054: resource busy and NOWAIT specified
ORA-30006 and ORA-00054 errors raised when update operation is performed against a record, that has been locked by the user or some session FOR UPDATE. To fix this, before performing the update, check…
Read MoreManual AP Invoice Creation and Cancellation with GST
Manual AP Invoice Creation and Cancellation with GST: Please find the below steps for Manual AP Invoice Creation and Cancellation with GST Responsibility: India Local Payables Navigation: Invoices > Entry…
Read More