Oracle EBS FNDLOAD Scripts

1 - Printer Styles

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 - Lookups

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

3 - Descriptive Flexfield with all of specific Contexts

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.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"

4 - Key Flexfield Structures

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.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"

5 - Concurrent Programs

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

6 - Value Sets

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

7 - Value Sets with values

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

8 - Profile Options

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

9 - Requset Group

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

10 - Request Sets

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

11 - Responsibilities

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility Key”

12 - Menus

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

13 – Forms/Functions

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.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 file_name.ldt

14. User/Responsibilities

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER

Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER [<USER>]

Messages

FNDLOAD apps/ebiz789 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct message_name.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='PER'

15. AME Setups

Transaction Types

                Download

FNDLOAD apps/<apps pwd> 0 Y DOWNLOAD $AME_TOP/patch/115/import/amescvar.lct <filename>.ldt AME_CALLING_APPS APPLICATION_SHORT_NAME=<Application short name> TRANSACTION_TYPE_ID=<AME transaction type short name>

                Upload

FNDLOAD apps/<apps pwd> 0 Y UPLOAD $AME_TOP/patch/115/import/amescvar.lct <filename>.ldt

Attributes

                Download

FNDLOAD apps/<pwd> 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesmatt.lct attribute.ldt AME_ATTRIBUTES APPLICATION_SHORT_NAME="PER" TRANSACTION_TYPE_ID=”Transaction Type ID” [ATTRIBUTE_NAME="Attribute Name"]

Ex. FNDLOAD apps/pwd 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesmatt.lct attribute.ldt AME_ATTRIBUTES APPLICATION_SHORT_NAME="PER" TRANSACTION_TYPE_ID="SSHRMS" [ATTRIBUTE_NAME="ALLOW_DELETING_RULE_GENERATED_APPROVERS"]

                Upload

FNDLOAD apps/<pwd> 0 Y UPLOAD $AME_TOP/patch/115/import/amescvar.lct <download file name>.ldt

Ex. FNDLOAD apps/pwd 0 Y UPLOAD $AME_TOP/patch/115/import/amescvar.lct sbtrantype.ldt

Attribute Usages

                Download

FNDLOAD apps/<pwd> 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesmatr.lct <filename> AME_ATTRIBUTE_USAGES ATTRIBUTE_NAME=<attribute name> TRANSACTION_TYPE_ID=<trans typs id> APPLICATION_SHORT_NAME=<application short name>

                Upload

FNDLOAD apps/<pwd> 0 Y UPLOAD $PER_TOP/patch/115/import/amesmatr.lct <filename>.ldt

Conditions

                Download

FNDLOAD apps/<pwd> 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesconk.lct <filename>.ldt AME_CONDITIONS APPLICATION_SHORT_NAME="<Appl Short Name>" TRANSACTION_TYPE_ID="<Trans Type Id>" CONDITION_KEY="<Condition Key>"

                Upload

FNDLOAD apps/<pwd> 0 Y UPLOAD $AME_TOP/patch/115/import/amesconk.lct <filename>.ldt

Approval Groups

                Download

FNDLOAD apps/pwd 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesappg.lct <filename>.ldt AME_APPROVAL_GROUPS APPROVAL_GROUP_NAME="<ApprovalGroup Name>"

#Need to use wildcards if Approval Group name has spaces

Ex. FNDLOAD apps/apps 0 Y DOWNLOAD amesappg.lct sbappgrps.ldt AME_APPROVAL_GROUPS APPROVAL_GROUP_NAME=SB%Cust%Grp%

                Upload

FNDLOAD apps/appsPassword 0 Y UPLOAD $AME_TOP/patch/115/import/amesappg.lct <filename>.ldt

Approval Group Configuration

                Download

FNDLOAD apps/<apps pw> 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesaagc.lct <download file name>.ldt AME_APPROVAL_GROUP_CONFIG APPLICATION_SHORT_NAME=<FND application short name> TRANSACTION_TYPE_ID=<AME transaction type short name> [APPROVAL_GROUP_NAME=<Approval Group Name>]

#Need to use wildcards if Approval Group name has spaces

Ex. FNDLOAD apps/apps 0 Y DOWNLOAD amesaagc.lct sbappgrpscon.ldt AME_APPROVAL_GROUP_CONFIG APPLICATION_SHORT_NAME=SQLAP TRANSACTION_TYPE_ID=SBTRANSTYPE APPROVAL_GROUP_NAME=SB%Cust%Grp%

                Upload

FNDLOAD apps/<apps pw> 0 Y UPLOAD amesaagc.lct <download file name>.ldt

Ex. FNDLOAD apps/apps 0 Y UPLOAD amesaagc.lct sbappgrpscon.ldt

Action Type Configuration

                Download

FNDLOAD apps/<apps pw> 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesaatc.lct <download file name>.ldt AME_ACTION_TYPE_CONFIG APPLICATION_SHORT_NAME=<FND application short name> TRANSACTION_TYPE_ID=<AMEtransaction type short name> [ACTION_TYPE_NAME=<action type name>]

Ex. FNDLOAD apps/pwd 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesaatc.lct action_config.ldt AME_ACTION_TYPE_CONFIG APPLICATION_SHORT_NAME=PER TRANSACTION_TYPE_ID=SSHRMS [ACTION_TYPE_NAME=<supervisory level>]

                Upload

FNDLOAD apps/<apps pw> 0 Y UPLOAD $AME_TOP/patch/115/import/amesaatc.lct <download file name>.ldt

Ex. FNDLOAD apps/apps 0 Y UPLOAD $AME_TOP/patch/115/import/amesaatc.lct sbacttconf.ldt

Action Type Usages

                Download

FNDLOAD apps/pwd 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesacus.lct <filename>.ldt AME_ACTION_USAGES APPLICATION_SHORT_NAME="<Appl Short Name>" TRANSACTION_TYPE_ID="<Trans Type Id>" RULE_KEY="<Rule Key>"

                Upload

FNDLOAD apps/pwd 0 Y UPLOAD $AME_TOP/patch/115/import/amesacus.lct <filename>.ldt

AME Rules:

                Download

FNDLOAD apps/appsPassword 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesrulk.lct <filename>.ldt AME_RULES APPLICATION_SHORT_NAME="<Appl Short Name>" TRANSACTION_TYPE_ID="<Transaction Type Id>" RULE_KEY="<Rule Key>"

                Upload

FNDLOAD apps/appsPassword 0 Y UPLOAD $AME_TOP/patch/115/import/amesrulk.lct <filename>.ldt