AWS Lambda
Getting Started It is a Compute Service Run your code with out Managing servers Server and operating system maintenance, capacity provisioning and automatic scaling, code monitoring and logging will be handled…
Read MoreGST Sales Order Creation
SALES ORDER Responsibility: India Local Order Management Navigation: Oracle Order Management > Orders, Returns > Sales Order In Sales order Screen, provide the information. Click on line Items Tab. Provide…
Read MoreGST RETURN TO VENDOR (RTV)
Responsibility: India Local Purchasing Navigation: Oracle Purchasing > Receiving > Returns Select the Inventory Org Provide the Receipt number as shown above and click on Find. Provide Quantity Returned, and…
Read MoreGST 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 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 More