Sunday, 4 November 2012

RELEASED_STATUS in WSH_DELIVERY_DETAILS



Table: WSH_DELIVERY_DETAILS
Column: RELEASED_STATUS
Possible Values:

B: Backordered- Line failed to be allocated in Inventory
C: Shipped -Line has been shipped
D: Cancelled -Line is Cancelled
N: Not Ready for Release -Line is not ready to be released
R: Ready to Release: Line is ready to be released
S: Released to Warehouse: Line has been released to Inventory for processing
X: Not Applicable- Line is not applicable for Pick Release
Y: Staged- Line has been picked and staged by Inventory

Thursday, 11 October 2012

APPS FNDLOAD

FNDLOAD for Concurrent Program

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct PO_NOTIFY_RECEIVE.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XXXXX"
http://oracle-appsjithendra.blogspot.in/

Printer Styles

FNDLOAD apps/apps@apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct xxx.ldt STYLE PRINTER_STYLE_NAME=printer style name
http://oracle-appsjithendra.blogspot.in/

Lookups
FNDLOAD apps/apps@apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct xxx.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=prod LOOKUP_TYPE=lookup name

Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxx.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=prod DESCRIPTIVE_FLEXFIELD_NAME=desc flex name P_CONTEXT_CODE=context name

Descriptive Flexfield with extract ldt file for specific context
FNDLOAD apps/apps O Y DOWNLOAD  $FND_TOP/patch/115/import/afffload.lct  XHL_PC_AD_COUNTRIES1.ldt DESC_FLEX APPLICATION_SHORT_NAME=FND  DESCRIPTIVE_FLEXFIELD_NAME='FND_FLEX_VALUES' DFF_CONTEXT DESCRIPTIVE_FLEX_CONTEXT_CODE='XHL_PC_AD_COUNTRIES'

Key Flexfield Structures
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxx.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=prod ID_FLEX_CODE=key flex code P_STRUCTURE_CODE=structure name

Concurrent Programs
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct xxx.ldt PROGRAM APPLICATION_SHORT_NAME=prod CONCURRENT_PROGRAM_NAME=concurrent name

Value Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxx.ldt VALUE_SET FLEX_VALUE_SET_NAME=value set name

Value Sets with values
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxx.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=value set name

Profile Options
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct xxx.ldt PROFILE PROFILE_NAME=profile option APPLICATION_SHORT_NAME=prod

Requset Group
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct xxx.ldt REQUEST_GROUP REQUEST_GROUP_NAME=request group APPLICATION_SHORT_NAME=prod

Request Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct xxx.ldt REQ_SET APPLICATION_SHORT_NAME=prod REQUEST_SET_NAME=request set

Responsibilities
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct xxx.ldt FND_RESPONSIBILITY RESP_KEY=responsibility

Menus
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxx.ldt MENU MENU_NAME=menu_name

Forms/Functions
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct xxx.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct xxx.ldt

User/Responsibilities
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct xxx.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct xxx.ldt FND_USER [ ]

MESSAGES
FNDLOAD apps/apps@apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XHL_DM_ENROLLER_EQ_DIST_ID.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='PO' MESSAGE_NAME='XXXXX'