How to Send an E-mail from PL/SQL

Useful SQL Script to generate Countries

Print Oracle Table Definitions

Create a Primary key column on a table

Some Useful SQL Scripts

Some Useful SQL Scripts are provided below:

Oracle Function to convert number to words:

Oracle Functions to convert number to words:

Often you get the requirement to convert amount to words. This requirement mainly comes in cheque printing.

Book An Order Using Process_Order Api

Book An Order Using Process_Order Api

Update Order Header Details Using Process_Order API For R12

Update Order Header Details Using Process_Order API For R12

Create An Order via Order Import For A Simple ATO Model

How to create an order via Order Import for a simple ATO model with the following configuration.

Create an RMA via Process Order API

Create an RMA order that references an existing order

Add A New Line To An Existing Order using OE_ORDER_PUB.process_order API

Add A New Line To An Existing Order using OE_ORDER_PUB.process_order API

Apply Hold to a Sales Order using OE_ORDER_PUB.process_order API

Apply Hold to a Sales Order using OE_ORDER_PUB.process_order API

Cancel An Existing Order Line using OE_ORDER_PUB

Cancel An Existing Order Line using OE_ORDER_PUB

Cancel An Existing Order using OE_ORDER_PUB.process_order API

Cancel An Existing Order using OE_ORDER_PUB.process_order API

Create An Order With One Line using OE_ORDER_PUB.process_order API

Create An Order With One Line using OE_ORDER_PUB.process_order API

Delete An Order Line OE_ORDER_PUB

Delete An Order Line using OE_ORDER_PUB

Delete An Order using OE_ORDER_PUB.process_order API

Delete An Order using OE_ORDER_PUB.process_order API

Release Hold In A Sales Order using OE_ORDER_PUB.process_order API

Release Hold In A Sales Order using OE_ORDER_PUB.process_order API

Reserve an Order Line using OE_ORDER_PUB.process_order API

Reserve an Order Line using OE_ORDER_PUB.process_order API

Split An Order Line OE_ORDER_PUB.process_order API

Split An Order Line OE_ORDER_PUB.process_order API 

Unreserve An Order Line using OE_ORDER_PUB.process_order API

Unreserve An Order Line using OE_ORDER_PUB.process_order API

Update An Existing Order Line using OE_ORDER_PUB.process_order API

Update an existing Order Line using OE_ORDER_PUB

Book An Order Using OE_INBOUND_INT.PROCESS_ORDER

Book an order using oe_inbound_int.process_order API 

Script To Apply Hold Via Oe_order_pub.Process_order in R12

How to apply hold on Sales Order using Process Order api in R12

My First Blog Post

Hi,

Every one, this is my first blog post on oracle apps scripts & tips. I will be providing with a number of useful scripts and tips for oracle apps developers.

I am sure it will be very useful for all of you.

Enjoy learning

Oracle Apps Scripts & Tips

Admin