Please find the below setups for IRISO: Requisition: Responsibility: India Local Purchasing Navigation: Requisition Summary > Requisitions Enter the Item, Quantity Enter Destination Org Enter Source Org Save Place the…
Read MoreOracle Online Redefinition When a table records fragmented, the select statement takes more I/O. Its causes a performance issue. Defragmentation help to increase the performance of…
Read MoreHow To Find DBID in NOMOUNT Stage Oracle database identifier in short DBID is an internal,unique identifier for an oracle database. Database administrator must note down the DBID…
Read MoreStep 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 Morecreate 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 : 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 MorePlease 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 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 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 MoreSELECT 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 More