Tuesday 21 May 2013

How to find the Application Path in oracle apps?


Connect to Putty server give your host enrty name and click on login.
enter user name xxname
enter password xxpass
now we give cd $XXSAMPLE_TOP
now type pwd click on enter
now we will see the path .

Standard Purchase Order Interface Process


Step1: First we can get the flat file (Data file) from functional Consultant or Team Lead. Based on flat file you can created the Staging Tables.
Step2: Move the data from flat file to Staging tables using SQL * Loader/TOAD.
Step3:Create the package Procedure for Validation in that procedure you can do the all Validations.
Please find some of the Generic Validation.

check the PO existance
Identify Duplicate PO's
validate bill_to ship_to (inventory locations)
validate operating unit
validate buyer
Validate PO_TYPE
validate currency
validate vendor
validate vendor site code
Validate poheader dff type (if you required)
Validate Payment terms
validate fob code
validate freight terms

Line and Distribution level validations:

Validate Item Code and Description
Validate Item Category
validate receiving inv org code(po org)
get uomcode
get secondary qty
validate line type
validates charge account segments validation

step4: once validation Program runs without validtion failed after that run the replica loading program
which was moving the data from staging tables to interface replica tables .
step5: now run the loading program ...this program will take of moving the data from interface replica tables to interface tables.
interface tables are:

po_headers_interface
po_lines_interface

step5:once the interface tables are loaded the data fine then we can run the import purchase order progam
here we have pass the parameters.
then
go back end
see the all the base tables

po_headers_all
po_lines_all
po_line_locactions_all
po_distributions_all

GOOD LUCK.........

if you have any issues please give me a comment............