GST Return Material Authorization(RMA)
Responsibility: India Local Order Management. Navigation: Oracle Order Management > Orders, Returns > Sales Order. Click on Lie Items. And click on Returns Tab. Provide the Reference Type : Invoice…
Read MoreGST Internal Requisition and Internal Sales Order(IRISO)
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
Oracle 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 MoreFind DBID in NOMOUNT Stage
How 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 MoreSend 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 More