Search This Blog

Sunday, March 19, 2017

Complex Filter in TCC

Or Condition
<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:and>
    <quer:or>
      <quer:isNotNull>
        <quer:replaceNull>
          <quer:field path="Applications,ProfileInformation,Experiences,Employer,CieEmployer.Description"/>
          <quer:field path="Applications,ProfileInformation,Experiences,OtherEmployerName"/>
        </quer:replaceNull>
      </quer:isNotNull>
      <quer:isNotNull>
        <quer:replaceNull>
          <quer:field path="Applications,ProfileInformation,ApplicationCertifications,Certification,Certification.Description"/>
          <quer:field path="Applications,ProfileInformation,ApplicationCertifications,OtherCertificationName"/>
        </quer:replaceNull>
      </quer:isNotNull>
    </quer:or>
    <quer:isNotNull>
      <quer:replaceNull>
        <quer:field path="Applications,ProfileInformation,Studies,Program,CieProgram.Description"/>
        <quer:field path="Applications,ProfileInformation,Studies,OtherCourseTitle"/>
      </quer:replaceNull>
    </quer:isNotNull>
  </quer:and>
</quer:filtering>

Thursday, March 16, 2017

Taleo Client Connect (TCC) error on Unix Server

Error while running TCC from Unix server

While running TCC through UNIX below error is coming.

2017-03-16 18:27:25,543 [ERROR] Client - The workflow execution failed!
Error: The HTTP request was unable to resolve the specified host.Use the monitoring feature to get more information.
2017-03-16 18:27:25,543 [ERROR] Client - The workflow execution failed!
Error: The HTTP request was unable to resolve the specified host.Use the monitoring feature to get more information.
2017-03-16 18:27:25,543 [ERROR] Client - The workflow execution failed!
Error: The HTTP request was unable to resolve the specified host.Use the monitoring feature to get more information.

Resolution:

In the cfg file for Send, Poll and Retrieve tabs, End Point source should be "Provided in the Current Step"

Monday, August 8, 2016

Spool Package Procedure code from SQL Plus

conn xxxx/xxxx@xxxx
SET VERIFY OFF;
SET HEAD OFF;
SET DEFINE OFF;
SET SCAN OFF;
set feedback off;
set linesize 500
set pagesize 50000
set trimspool on
SPOOL  D:\Prod\xx.txt
select text from dba_source where name = UPPER('PACKAGE_NAME') and type = 'PACKAGE' and owner = 'APPS' order by line; 
select text from dba_source where name = UPPER('PACKAGE_NAME') and type = 'PACKAGE BODY' and owner = 'APPS' order by line; 
SET VERIFY ON;
SET HEAD ON;
SET DEFINE ON;
SET SCAN ON;
SPOOL OFF

EXIT; 

Monday, June 1, 2015

Get SIT Details in Oracle EBS - Special Information Types

select ppa.date_from,ppa.date_to,pac.*
  from per_all_people_f papf, per_all_assignments_f paaf,per_person_analyses PPA,per_analysis_criteria pac,fnd_id_flex_structures fifs
 where papf.employee_number = 'XXXX'
   AND SYSDATE BETWEEN papf.effective_start_date AND
       papf.effective_end_date
   and papf.current_employee_flag = 'Y'
   and paaf.person_id = papf.person_id
   and paaf.assignment_type = 'E'
   AND SYSDATE BETWEEN paaf.effective_start_date AND
       paaf.effective_end_date
   and ppa.person_id = papf.person_id
   and pac.id_flex_num = ppa.id_flex_num
   and pac.analysis_criteria_id = ppa.analysis_criteria_id
   and fifs.id_flex_num = ppa.id_flex_num
   and fifs.id_flex_structure_code = 'XXXX'--This is SIT code

Sunday, May 3, 2015

Replace Alphabets in the String in Oracle SQL

to_number(REGEXP_REPLACE(REGEXP_REPLACE(p_string,'[[:alpha:]]'),'[.]'))


select to_number(REGEXP_REPLACE(REGEXP_REPLACE('AA.09A','[[:alpha:]]'),'[.]')) from dual

Output:
---------------------------
9

Sunday, March 29, 2015

FNDLOAD in Oracle EBS

The Generic Loader (FNDLOAD) is a concurrent program that can move Oracle Applications data between database and text file representations. The loader reads a configuration file to determine what data to access. For information on specific configuration files consult the Open Interfaces Guide for your product group.
From an FNDLOAD perspective, there is absolute no limitation on parallel execution.  Parallel upload of concurrent programs and responsibilities should through fine unless upload logic in LCT file restrict the same.
There is no way to limit the download of the value hierarchy data with the existing flexfield loader logic. 
If this data is removed manually from the .ldt file generated when downloading data, the upload might error out as a result and this is NOT a supported method of using fndload and the corresponding generated data.
Overview
The Generic Loader can download data from an application entity into a portable, editable text file. This file can then be uploaded into any other database to copy the data. Conversion between database store and file format is specified by a configuration file that is read by the loader.

The Generic Loader downloads data from a database according to a configuration (.lct) file, and converts the data into a data file (.ldt file). The Generic Loader can then upload this data to another database using a configuration file.

The loader operates in one of two modes: download or upload. In the download mode, data is downloaded from the database to a text file; in the upload mode, data is uploaded from a text file to the database.

Data structures supported by the loader include master-detail relationships and foreign key reference relationships.

In both downloading and uploading, the structure of the data involved is described by a configuration file. The configuration file describes the structure of the data and also the access methods to use to copy the data into or out of the database. The same configuration file may be used for both uploading and downloading.

When downloading, the Generic Loader creates a second file, called the data file that contains the structured data selected for downloading. The data file has a standard syntax for representing the data that has been downloaded. When uploading, the Generic Loader reads a data file to get the data that it is to upload. In most cases, the data file was produced by a previous download, but may have come from another source. The data file cannot be interpreted without the corresponding configuration file available.

What can be done?
These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules
The FNDLOAD: Concurrent Program – FNDLOAD can be executed as a concurrent program.
Some advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained
Some disadvantages when using FNDLOAD
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data
Syntax
The Generic Loader is a concurrent program named FNDLOAD. The concurrent executable takes the following parameters:

FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ...]
where

<apps/pwd>
The APPS schema and password in the form username/password[@connect_string]. If
connect_string is omitted, it is taken in a platform-specific manner from the environment
using the name TWO_TASK.

< 0 Y >
Concurrent program flags.

mode
UPLOAD or DOWNLOAD. UPLOAD causes the datafile to be uploaded to the database. DOWNLOAD causes the loader to fetch rows and write them to the datafile.

<con
g le>
The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).

<data
le>
The data file to write (usually with a suffix of .ldt, but not enforced or supplied by the loader). If the data file already exists, it will be overwritten.

<entity>
The entity(ies) to upload or download. When uploading, always upload all entities, so specify a "-" to upload all entities.

< [param] >
Zero or more additional parameters are used to provide bind values in the access SQL (both UPLOAD and DOWNLOAD). Each parameter is in the form NAME=VALUE. NAME should not conflict with an attribute name for the entities being loaded.
Modes of Operation
This is important because it would drive the whole flow, and it always be either Upload or Download.
Example of download
FNDLOAD apps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=<application_short_name>
Example of Upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt - CUSTOM_MODE=FORCE undocumented parameter
What are FNDLOAD Options?
· Application level OR single entity level download
o (Example) Download all the profile options of Inventory or just the INV: Default Primary UOM
· Entire OR Partial upload of a data file
o (Example) Upload the entire myfile.ldt or just a single entity indicated by - and mode UPLOAD or  UPLOAD_PARTIAL
o Entity name required for UPLOAD_PARTIAL mode
· Custom mode force update
o To override Oracle’s upload algorithm and update the custom AOL data regardless, use CUSTOM_MODE= FORCE
o UPLOAD_MODE= REPLACE (only for menus)
· Support for NLS uploads
o NLS data uploads for translated columns are supported, use UPLOAD_MODE= NLS
Where is Configuration File Located
By default Oracle delivers most of configuration files that can be used to download certain entities.
· Configuration files with extension .lct
o On Unix - all the configuration files are in $FND_TOP/patch/115/import directory
o On Unix Oracle also places the original configuration files in $FND_TOP/admin/import directory
· Data files with extension .ldt
FNDLOAD File Structure
· The configuration files (.lct) are delivered and maintained by Oracle.
· It has entity definitions, parent-child relationships and user input parameters identified by :NAME.
· Downloading a parent automatically downloads all children - (Example) Concurrent Program download.
· The data files (.ldt) have both entity definition and the data.
· It also shows the version and the location of the configuration file (.lct) that was used.
· Without the configuration file, a data file is useless.
· Without the data file, a configuration file is meaningless.
FNDLOAD Files
· Key files: .lct and .ldt
· FNDLOAD must be run as the apps user not as applsys or any other user, otherwise an Ora-6550 error will be received.
· Both are easily readable, editable and portable.
· Do not modify Oracle .lct files.
· Use a favorite editor to manipulate only the .ldt files but be cautious about data type, length, delimiter placements etc.
· Use the log file outputs or .ldt file contents creatively for quick file comparisons and answer questions as: (Why can this be accessed? What is that profile option name, value and level? What is the value set used for that DFF segment attribute10 etc.)
· Partial string searches (which value set has Priority something in its where clause, etc)
Some sample examples
1 - Printer Styles
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”
2 - Lookups
FNDLOAD apps/pwd@seeddb 0 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/pwd@seeddb 0 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 - Multiple Flexfields
Use a combination of APPLICATION_SHORT_NAME and DESCRIPTIVE_FLEXFIELD_NAME names ie. APPLICATION_SHORT_NAME=PER >> will download all PER flexfields DESCRIPTIVE_FLEXFIELD_NAME=PER_% >> will download all flexfields that start with 'PER_'.
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME="PER_%"

5 - Key Flexfield Structures
FNDLOAD apps/pwd@seeddb 0 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”
6 - Concurrent Programs
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name”
7 - Value Sets
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”
 8 - Value Sets with values
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”
9 - Profile Options
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod” 
10 - Request Group
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod”
11 - Request Sets
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set”
12 - Responsibilities 
FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=”responsibility"

13 - Responsibilities with all Security Groups
FNDLOAD apps/<PASSWORD> 0 Y DOWNLOAD FND_TOP/patch/115/import/afscursp.lct <USER>.ldt
FND_USER USER_NAME="<USER>" SECURITY_GROUP=% DATA_GROUP_NAME=%

14 - Menus
FNDLOAD apps/ pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=”menu_name”
15 - Forms/Functions/Personalizations: Refer to the System Administrator's Guide on dependencies
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
<filename.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FUNCTION FUNCTION_NAME=<function_name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FORM FORM_NAME=<form_name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>


16 - User/Responsibilities 
FNDLOAD apps/ pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER

17 - Alert
FNDLOAD apps/pwd 0 Y DOWNLOAD
$ALR_TOP/patch/115/import/alr.lct my_file.ldt ALR_ALERTS
APPLICATION_SHORT_NAME=FND ALERT_NAME=Alert name to downloa
18 - Blob
With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]
 19 - Overwrite custom definitions
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/.lct $
XX_TOP/import/.ldt CUSTOM_MODE=FORCE

20 - Load an NLS Language
FNDLOAD <APPS USR>/<APPS PWD> 0 Y UPLOAD <controlfile.lct> <datafile.ldt> \
- UPLOAD_MODE=NLS CUSTOM_MODE=FORCE WARNINGS=TRUE

21 - Migrate the role registration process from one instance to another
a. Please navigate to the path: $FND_TOP /patch/115/import/US/umxrgsvc.ldt

b. The following command can be used to download:
FNDLOAD apps/<PASSWD>@(instance name) O Y DOWNLOAD $FND_TOP/patch/115/import/umxrgsvc.lct umxrgsvc.ldt UMX_REG_SERVICES REG_SERVICE_CODE UMX

c. The following command can be used to upload:
FNDLOAD apps/<PASSWD>@(instance name) O Y UPLOAD $FND_TOP/patch/115/import/umxrgsvc.lct umxrgsvc.ldt UMX_REG_SERVICES REG_SERVICE_CODE UMX
22 - Transfer Custom Messages to another Instance
a. Download the message from the source instance.
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND MESSAGE_NAME=PASSWORD-INVALID-NO-SPEC-CHAR

b. Move the custom LDT file (password.ldt) over to the destination instance.

c. Upload the custom message to the destination instance.
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND CUSTOM_MODE=FORCE

23 - Download UMX Roles and Role Assignment data from one instance and upload to another.
To download from one instance:

FNDLOAD <username/pwd@sid> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afrole.lct
umxroles.ldt WF_ROLE ORIG_SYSTEM=UMX%

To upload to another instance:

FNDLOAD <username/pwd@sid> 0 Y UPLOAD $FND_TOP/patch/115/import/afrole.lct
umxroles.ldt




Thursday, March 26, 2015

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