Oracle Technologies: Oracle Order Management DropShip Flow for R12

Oracle Technologies: Oracle Order Management DropShip Flow for R12

In this blog I will explain Oracle  Drop Ship Flow for R12i.
What is Dropship Order - In dropship Order, sales order line creates a requisition line that becomes a PO and sent to your supplier. You instruct your supplier to send the item or configured item directly to your customer only and items never physically pass through your warehouse, and therefore you do not pick, pack or ship them yourselves

In this blog I will explain the R12 Dataflow of Dropship order from OM to Oracle Payables.
Topics covered in this blog are
Drop Ship Sales order creation and booking.
Requisition Import
Auto Creation of PO
Receipt against PO
AP against PO



Since in Dropship we don’t receive the goods in our warehouse, SOURCE_TYPE will be “External”, where as for non-dropship orders it is Internal. Once Book, we cannot Changes SOURCE_TYPE.

We can change the SOURCE_TYPE as “External” for an item at the time of order creation, or we can define it permanently in the Item creation Setup, by setting Default SO Source Type = External.

Also as we don’t have any shipping activity in dropship orders, Receiving Transaction Processor (RTP) , triggered after Submitting the receipt will push the workflow from Shipping activity to Fulfillment.
R12 Dataflow of Dropship order from OM to Oracle Payables.
Step1 - Drop ship Sales Order Creation
Step2 - Source Type = External


Step3 -Once order is Book, order line workflow will be at Purchase release Deferred Status .

Step4 -Submit Workflow to progress the Order line workflow.



Step5 -Submit the requisition Import to create Requisition for Drop Ship


Step6 -Once requisition Import Completed successfully , Navigate to Order lines Action >Additional Information and then go to DropShip tab.




Step7 - Switch to Purchasing Responsibility and Navigate to Requisition Summary



Step8 -Query for Requisition Number



Step9 – Open the Auto Create Window and Query for Requisition #



Step9 –Auto Create


Step10 -Approve the PO


Step11 - Browse the Shipment Details of PO , (Shipment Button)



Step11 - Browse the Shipment Details of PO, (Shipment Button).We can select the Approval Level and Invoice Match Option based on your business requirements.



Step11 - Browse the Shipment Details of PO , (Shipment button).


Step11 - Browse the Shipment Details of PO , (Shipment Button), it will display Qty Ordered/billed/shipped etc.







Step12 - Browse the Distribution Details of PO , (Distribution Button).




Step13 - Navigate to receipts.



Step13 - Navigate to Receipt , system will prompt for Inventory Org , Select your Inventory Organization.

Step14 - Enter Receipt against PO.


Step14 -

Step14 -


Step15 - Once you save the Receipt , System will submit Receiving Transaction processor.



Step16 - RTP on successful completion Progress the OM Workflow and Line status change from Awaiting receipt to SHIPPED.

AME B Setup and Resp

Approvals Management Engine B Setup and Resp

System Administration/Engineering: E-Business Suite R12 Installation Steps on Windows XP

System Administration/Engineering: E-Business Suite R12 Installation Steps on Windows XP

E-Business Suite R12 Installation Steps on Windows XP

Oracle E-Business Suite R12 Installation Steps on Windows XP
I have installed Oracle E-Business Suite Release 12 on Windows XP Professional successfully.
I have done a single node installation as follows:

Hardware & Software Specifications:

- Intel Pentium 4, CPU 3.2 GHz
- 2 GB of RAM
- 180 GB Hard Drive
- Windows XP Professional with Sevice Pack 2

Installation Steps:

1) Install Windows XP Professional with SP2

2) Set 'Computer Name' as well as 'Domain Name'.

- Right click on 'My Computer' > Properties > 'Computer Name' > Change
- Set 'Computer Name' to
- Click on More
- Set a 'Primary DNS Suffix of this Computer' to

3) Install Microsoft Loopback adapter and define an IP address (10.10.10.10)

For more information on how to do this, please refer to "How to install the Microsoft Loopback adapter in Windows XP":

http://support.microsoft.com/kb/839013

4) Add a new entry in C:\windows\system32\drivers\etc\hosts as follows:


10.10.10.10 hostname.domainname.com

5) From the command prompt, make sure you can do the following:

C:\> ping 10.10.10.10
C:\> ping hostname
C:\> ping hostname.domainname.com

6) Create a new user 'hsawwan' and make this user a member of:
- Administrators (local user)

7) Install Visual C++ 8.0 (Which is included in Microsoft Visual Studio 2005) in 'C:\VCPlus' -- Make sure not to install VC++ in a directory that contains spaces.

8) Download 'Cygwin' and install the required packages:

- Create a Cygwin directory (C:\cygwin) -- Make sure not to install 'Cygwin' in a directory that contains spaces.
- Download the Cygwin Software (http://www.cygwin.com)
- Run 'Setup.exe' and choose 'Download without Installing'
- Select the following packages:

Archive - Default, plus manually select the zip package
Base - Default, plus manually select: ash, coreutils, diffutils, findutils, gawk, grep, sed, tar and which
Devel - Default, plus manually select binutils, gcc, gcc-core, gcc-g++, make and mktemp
Doc - Default, plus manually select cygwin-doc and man
Editors - Default, plus manually select vim
Interpreters - Default, plus manually select gawk
Shells - Default, plus manually select ash and tcsh
Utils - Default, plus manually select cygutils and file

- Once the download is complete, run 'Setup.exe' again and choose 'Install from Local Directory'
- Specify the directory where you want to install Cygwin (C:\cygwin) and DOS as the Default Text File Type

9) GNUMake is not required when using 'Cygwin' since it comes as a part of the 'Cygwin'.

C:\cygwin\bin>copy gawk.exe awk.exe
C:\cygwin\bin>copy grep.exe egrep.exe
C:\cygwin\bin>copy make.exe gnumake.exe
C:\cygwin\bin>copy gcc.exe cc.exe

10) Add 'C:\cygwin\bin' to the system path.

11) No JDK installation is required, JDK 5.0 (java version "1.5.0_08") is bundled with Oracle Applications R12 installation.

12) Set Up the Stage Area:

Stage Area (C:\Stage12) requires a 26 GB hard disk space.

Extract the zip files (25 files) which have been downloaded from (http://edelivery.oracle.com). Nothing special to do since the extracted files will create the stage area directory structure by itself. You should see the following structure under 'C:\Stage12' once you are done with the files extraction:

- startCD > Disk1
- oraAppDB > (Disk 1 to Disk 35)
- oraApps > (Disk 1 to Disk 7)
- oraAS > (Disk 1 to Disk 2)
- oraDB > (Disk 1 to Disk 3)

13) Start the installation:

C:\> cd Stage12\startCD\Disk1\rapidwiz
C:\Stage12\startCD\Disk1\rapidwiz> RapidWiz.cmd

The installation wizard is similar to 11.5.10 RapidWiz. For 'VC++' and 'Cygwin' I have provided the following paths:

s_MSDEVdir=C:\VCPlus\VC
s_MKSdir=C:\cygwin\bin

- It took almost 2 hours to install the production environment (3 hours when installing the Vision instance)
- Total space required to install the production environment is 60 GB (153 GB is required to install the Vision instance)

ORACLE Month End Process

Month End Closing Procedures

Overview
The following section describes the processes/ checklist in Oracle Payables for month end closing. This ensures that all transactions are tracked.

Process Flowchart
(For Clear View of the Image double click on it)


Description of Process Steps

Step 1.0 Complete Invoices
Complete entry of all Invoice Batches that should be included in period.

Step 2.0 Complete Expense Reports
Complete entry of all Expense Reports that should be included in period and import expense reports as invoices into AP.

Step 3.0 Approve Invoices/Invoice Batches
Approve all invoice batches that should be posted in the current period.

Step 4.0 Check and Resolve Invoice Holds
Check and Resolve all holds on invoices which should be posted in the current period. Use the following reports for checking purposes:
Invoice on Hold Report - to check if invoices are on hold
Matching Hold Detail Report - to review detailed information for PO-matched invoices on hold.

Step 5.0 Review and correct invoice distribution for FA entries
Review range of accounts specified for Asset Cost, Asset Clearing and for expense accounts for items which might exceed capitalization limit. Fixed Assets Accountant may review Distributions before AP posting to GL and advise AP to correct any invoice distribution errors.

Step 6.0 Complete Payments
Create payments for all due invoices.

Step 7.0 Create Accounting entries
Run the Payables Accounting Process, to create all the accounting entries. Run the Unaccounted Transactions Report, to identify and resolve any unaccounted transactions.

Step 8.0 Transfer Payments and Invoices to GL
Run a concurrent program to transfer invoices and payments to GL. Review the Journal Import Execution Report and ensure that Status = SUCCESS After transferring the journals to GL, run the Mass Addition Create program to transfer fixed asset distributions to Oracle Assets.

Step 9.0 Open Next Period
Open the next period for new transactions.

Step 10.0 Close Current Period
If you have problems closing AP, then run the Invoice Sweep process.

Step 11.0 Sweep Unposted Invoices(Only if required to close current period)
Run Unposted Invoice Sweep process. This program is used to transfer invoices and payments from one period to another. Invoices on hold will not be posted and therefore the GL Date has to be changed to the future period before the current AP period can be closed.

Step 12.0 Run Period Close Reports
The following standard reports are useful for closing period purpose.
Accounts Payable Trial Balance
Posted Invoice Register
Posted Payments Register
Payment Register
Void Payment Register (by Void Date)
Invoice Aging Report
Prepayments Status Report