CONVERT MONTH-YEAR FORM TO DATE FORMAT

CONVERT MONTH-YEAR FORM TO DATE FORMAT


select trunc(trunc(to_date(:p_from_month,'Mon-YYYY'),'MM'),'MM') ,last_day(to_date(:p_to_month,'Mon-YYYY')) from dual

FNDLOAD Scripts

FNDLOAD Scripts

Code and AOL Migration Scripts

Messages:


—–DOWNLOAD—–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct
XX_MESSAGE_NAME.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=’ICX’ MESSAGE_NAME=’XX_MESSAGE_NAME’

Or can download all the messages within an application

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct
XX_MESSAGE_NAME.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=’ICX’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MESSAGE_NAME.ldt

Lookups:
—–DOWNLOAD—–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_LKP_NAME.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=’ICX’ LOOKUP_TYPE=’XX_LKP_NAME’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_LKP_NAME.ldt

Value Set:
—–DOWNLOAD—–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_VALUE_SET_NAME.ldt VALUE_SET FLEX_VALUE_SET_NAME=’XX_VALUE_SET_NAME’

If value set has values then,

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_VALUE_SET_NAME.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=’XX_VALUE_SET_NAME’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_VALUE_SET_NAME.ldt

Form Function:
—–DOWNLOAD—–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_FORM_FUNCTION_NAME.ldt FUNCTION FUNCTION_NAME=’XX_FORM_FUNCTION_NAME’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_FORM_FUNCTION_NAME.ldt

Menu:
—–DOWNLOAD—–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_MENU_NAME.ldt MENU MENU_NAME=’XX_MENU_NAME’

—–UPLOAD——-
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_MENU_NAME.ldt

Responsibility:
—–DOWNLOAD—–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_KEY.ldt FND_RESPONSIBILITY RESP_KEY=’XX_RESP_KEY’

—–UPLOAD——-
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_KEY.ldt

Profile Option Definition:
—–DOWNLOAD—–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_PROFILE_NAME.ldt PROFILE PROFILE_NAME=’XX_PROFILE_NAME’ APPLICATION_SHORT_NAME=’ICX’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_PROFILE_NAME.ldt

Request Group:
—–DOWNLOAD—–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REPORT_GROUP_NAME.ldt REQUEST_GROUP REQUEST_GROUP_NAME=’XX_REPORT_GROUP_NAME’ APPLICATION_SHORT_NAME=’PO’

—–UPLOAD——-
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REPORT_GROUP_NAME.ldt

Concurrent program:
—–DOWNLOAD—–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CONC_PRG_NAME.ldt PROGRAM APPLICATION_SHORT_NAME=’PO’ CONCURRENT_PROGRAM_NAME=’XX_CONC_PRG_NAME’

—–UPLOAD——-
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CONC_PRG_NAME.ldt

Request Sets:
—–DOWNLOAD—–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME.ldt REQ_SET REQUEST_SET_NAME=’XX_REQ_SET_NAME’

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME_LINK.ldt REQ_SET_LINKS REQUEST_SET_NAME=’XX_REQ_SET_NAME’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME.ldt

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET_NAME_LINK.ldt

Alert:
—–DOWNLOAD—–
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_ALERT_NAME.ldt ALR_ALERTS APPLICATION_SHORT_NAME=’PO’ ALERT_NAME=’XX_ALERT_NAME’

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_ALERT_NAME.ldt CUSTOM_MODE=FORCE

Folders:
—–DOWNLOAD—–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct XX_FOLDER_NAME.ldt FND_FOLDERS NAME=’XX_FOLDER_NAME’

Or can download all the folders

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct XX_ALL_FOLDER.ldt FND_FOLDERS

—–UPLOAD——-
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/fndfold.lct XX_FOLDER_NAME.ldt CUSTOM_MODE=FORCE

================================================

Examples
===========

uploaded

cd $XXESSEL_TOP

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct ESSELACL.ldt

data definition uploaded

cd $XXESSEL_TOP

FNDLOAD apps/apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ESSELACL_TMP.ldt


download concurrent :

cd $XXESSEL_TOP

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ESSELACL.ldt PROGRAM APPLICATION_SHORT_NAME="XXESSEL" CONCURRENT_PROGRAM_NAME="ESSELACL"


datadefinition download

cd $XXESSEL_TOP

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ESSELACL_TMP.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXESSEL DATA_SOURCE_CODE=ESSELACL

How to stop the PO Receipt Traveler report for specific organization using Form personalization

How to stop the PO Receipt Traveler report for specific organization using Form personalization:

Stop Receipt Traveler – FLG Form Personalization 

FORM NAME: RCVRCERC

Trigger Event : WHEN-NEW-BLOCK-INSTANCE

Condition : fnd_profile.value(‘MFG_ORGANIZATION_ID’)=306

Target object: PO_STARTUP_VALUES.PRINT_TRAVELLER_VALUE

Property Name: Value

Value: N

Note : Here if flag value is reset to 'N' then Receipt Traveler Report program never call .