FNDLOAD for AME’s

Oracle Approvals Management (AME) is a self-service Web application that enables users to define business rules governing the process for approving transactions in Oracle Applications .This enables development of custom rules to manage transaction approvals that is integrated with multiple Oracle EBS applications such as HR, PO, AP and UMX.
If you want to migrate the AME setup like rules,conditions,approval groups etc. from one instance to another instance, you can use some of them by mean of FNDLOAD utility. The process is similar to what we are regularly using for other AOL Objects.

FNDLOAD will have such ldt file through which you can use.



You should read the lct first before using any FNDLOAD Command. In the lct, there is an Entity section, where the Entity details are mentioned.Newcomer in OracleApps if you are not familiar with lcts, i would suggest you to go through the DOWNLOAD section and find the bind variables, which are mandatory.
Here are the details steps for each setup's availability till date.

Condition

The script that downloads AME conditions allows you to download all conditions for a given transaction type or only those associated with a particular attribute or group of attributes.

 Download

  FND_TOP apps/<apps password> 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesconk.lct <ldt filename> AME_CONDITIONS CONDITION_KEY=<condition key> TRANSACTION_TYPE_ID=<trans typs id> APPLICATION_SHORT_NAME=<application short name>

 UPLOAD

FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesconk.lct <ldt filename>

• FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesconk.lct amecondition.ldt AME_CONDITIONS APPLICATION_SHORT_NAME='PER' TRANSACTION_TYPE_ID='HRSSA' ATTRIBUTE_NAME='PROCESS_NAME' CONDITION_KEY='317772662:44552';
• FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesconk.lct amecondition.ldt

Dynamic Approval group /Approver Groups

An approver group can either be an ordered set of one or more approvers (persons and/or user accounts) or it can be a list, which is dynamically generated at rule evaluation time.


FND_TOP apps/<apps password> 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesappg.lct <ldt filename> AME_APPROVAL_GROUPS APPROVAL_GROUP_NAME=<name of approval group> TRANSACTION_TYPE_ID=<trans typs id> APPLICATION_SHORT_NAME=<application short name>


FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesappg.lct <ldt filename>

• FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesappg.lct ameapprovalgroup.ldt AME_APPROVAL_GROUPS APPROVAL_GROUP_NAME='Dyn Apprv Hub Approval Group' TRANSACTION_TYPE_ID='HRSSA' APPLICATION_SHORT_NAME='PER'
• FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesappg.lct ameapprovalgroup.ldt

Dynamic Approval group config

FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesaagc.lct ameapprovalgroupusage.ldt AME_APPROVAL_GROUP_CONFIG APPROVAL_GROUP_NAME='Dyn. Post HROPs Approval Group' TRANSACTION_TYPE_ID='HRSSA' APPLICATION_SHORT_NAME='PER'


FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesaagc.lct ameapprovalgroupusage.ldt

AME Rule

An approval rule is a business rule that helps determine a transaction’s approval process. Rules are constructed from conditions and actions.
The AME rules can be downloaded for information about the rule (e.g. name, description, etc) along with associated conditions and rule type.

$FND_TOP/bin/FNDLOAD apps/<apps password> 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesrulk.lct <ldt filename> AME_RULES RULE_KEY=<Rule Key > TRANSACTION_TYPE_ID=<trans typs id> APPLICATION_SHORT_NAME=<application short name>
# You can find Rule Key in AME_RULES table

FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesrulk.lct amerule.ldt

• FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesrulk.lct amerule.ldt AME_RULES RULE_KEY='317772662:54567' TRANSACTION_TYPE_ID='HRSSA' APPLICATION_SHORT_NAME='PER'
• FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesrulk.lct amerule.ldt

AME Rule Action Type Usage

FNDLOAD apps/<apps pw> 0 Y DOWNLOAD amesactu.lct <download file name>.ldt AME_ACTION_USAGES APPLICATION_SHORT_NAME=<FND application short name> TRANSACTION_TYPE_ID=<AME transaction type short name> [RULE_KEY=<Rule Key>]
# Rule Key is found in AME_RULES table


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

• FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesactu.lct ameactionusage.ldt AME_ACTION_USAGES RULE_KEY='317772662:54567' TRANSACTION_TYPE_ID='HRSSA' APPLICATION_SHORT_NAME='PER'
• FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesactu.lct ameactionusage.ldt
  

Transaction Types

An application that uses AME to govern its transactions’ approval processes is termed an integrating application. An integrating application may divide its transactions into several categories where each category requires a distinct set of approval rules. Each set of rules is called a transaction type. Different transaction types can use the same attribute name to represent values that are calculated in different ways or fetched from different places.

FNDLOAD apps/<apps pwd> 0 Y DOWNLOAD amescvar.lct <download file name>.ldt AME_CALLING_APPS APPLICATION_SHORT_NAME=<FND application short name> TRANSACTION_TYPE_ID=<AME transaction type short name>

FNDLOAD apps/<apps pwd> 0 Y UPLOAD amescvar.lct <download file name>.ldt

• FNDLOAD apps/apps 0 Y DOWNLOAD amescvar.lct hubtrantype.ldt AME_CALLING_APPS APPLICATION_SHORT_NAME=SQLAP TRANSACTION_TYPE_ID=SBTRANSTYPE
• FNDLOAD apps/apps 0 Y UPLOAD amescvar.lct hubtrantype.ldt

Attribute
Attributes are business variables with a single value for a particular transaction. The typical example for attributes in AME are:

• transaction’s total amount
• percentage of discount
• an item’s category
• a person’s salary

FNDLOAD apps/<apps password> 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesmatt.lct <ldt filename> AME_ATTRIBUTES ATTRIBUTE_NAME=<attribute name> TRANSACTION_TYPE_ID=<trans typs id> APPLICATION_SHORT_NAME=<application short name>


FNDLOAD apps/<apps pwd> 0 Y UPLOAD amesmatt.lct <ldt download file name>

• FNDLOAD apps/apps 0 Y DOWNLOAD amesmatt.lct hubattributes.ldt AME_ATTRIBUTES APPLICATION_SHORT_NAME=SQLAP
  TRANSACTION_TYPE_ID= SBTRANSTYPE ATTRIBUTE_NAME=SB_CUST_ATTRIBUTE
• FNDLOAD apps/apps 0 Y UPLOAD amesmatr.lct hubattributeusages.ldt

Attribute Usage

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


FNDLOAD apps/<apps pwd> 0 Y UPLOAD amesmatr.lct <download file name>.ldt

• FNDLOAD apps/apps 0 Y DOWNLOAD amesmatr.lct hubattributeusage.ldt AME_ATTRIBUTE_USAGES aPPLICATION_SHORT_NAME=SQLAP
• FNDLOAD apps/apps 0 Y UPLOAD amesmatr.lct hubattributeusages.ldt
  
  ==============  *********************  ====================
  
  FNDLOAD Migration scripts for AME  Attribute, Condition, Approval Groups, Rules and Transaction Types.
  
  A. Attribute
  
  1. Attribute – Download
  
  FNDLOAD apps/pw 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesmatt.lct xx_gssm_ame_attr.ldt AME_ATTRIBUTES ATTRIBUTE_NAME=’xx%’ TRANSACTION_TYPE_ID=’SSHRMS’ APPLICATION_SHORT_NAME=PER
  
  2. Attribute Usage – Download
  
  FNDLOAD apps/pw 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesmatr.lct xx_gssm_ame_attr_usg.ldt AME_ATTRIBUTE_USAGES ATTRIBUTE_NAME=’xx%’  TRANSACTION_TYPE_ID=’SSHRMS’ APPLICATION_SHORT_NAME=PER
  
  1. Attributes – Upload
  
  FNDLOAD apps/pw1 0 Y UPLOAD $PER_TOP/patch/115/import/amesmatt.lct xx_gssm_ame_attr.ldt
  
  2. Attribute Usages – Upload
  
  FNDLOAD apps/pw1 0 Y UPLOAD $PER_TOP/patch/115/import/amesmatr.lct xx_gssm_ame_attr_usg.ldt
  
  B. Conditions
  
  1. Conditions – Download
  FNDLOAD apps/pw 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesconk.lct xx_gssm_ame_cond.ldt AME_CONDITIONS ATTRIBUTE_NAME=’xx%’ TRANSACTION_TYPE_ID=’SSHRMS’ APPLICATION_SHORT_NAME=PER
  
  1. Conditions – Upload
  FNDLOAD apps/pw1 0 Y UPLOAD $PER_TOP/patch/115/import/amesconk.lct xx_gssm_ame_cond.ldt
  
  C. Approval Groups
  
  1. Approval Groups – Download
  
  FNDLOAD apps/pw 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesappg.lct xx_gssm_ame_apgrps.ldt AME_APPROVAL_GROUPS APPROVAL_GROUP_NAME=xx% TRANSACTION_TYPE_ID=’SSHRMS’ APPLICATION_SHORT_NAME=PER
  
  2. Approval Groups Configuration – Download
  
  FNDLOAD apps/pw 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesaagc.lct xx_gssm_ame_apgrps_cf.ldt AME_APPROVAL_GROUP_CONFIG APPROVAL_GROUP_NAME=xx% TRANSACTION_TYPE_ID=’SSHRMS’ APPLICATION_SHORT_NAME=PER
  
  
  1. Approval Groups – Upload
  
  FNDLOAD apps/pw1 0 Y UPLOAD $PER_TOP/patch/115/import/amesappg.lct xx_gssm_ame_apgrps.ldt
  
  2. Approval Groups Configuration – Upload
  
  FNDLOAD apps/pw1 0 Y UPLOAD $PER_TOP/patch/115/import/amesaagc.lct xx_gssm_ame_apgrps_cf.ldt
  
  4. Rules
  
  # You can find Rule Key in AME_RULES table
  
  1. Rules
  
  * FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesrulk.lct amerule.ldt AME_RULES RULE_KEY=’317772662:54567′ TRANSACTION_TYPE_ID=’HRSSA’ APPLICATION_SHORT_NAME=’PER’
  
  
  * FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesrulk.lct amerule.ldt
  
  * FNDLOAD apps/<passwd>@sourcedb 0 Y DOWNLOAD $PER_TOP/patch/115/import/amesactu.lct ameactionusage.ldt AME_ACTION_USAGES RULE_KEY=’317772662:54567′ TRANSACTION_TYPE_ID=’HRSSA’ APPLICATION_SHORT_NAME=’PER’
  
  * FNDLOAD apps/<passwd>@destinationdb 0 Y UPLOAD $PER_TOP/patch/115/import/amesactu.lct ameactionusage.ldt
  
  5. Transaction Type
  
  An application that uses AME to govern its transactions approval processes is termed an integrating application. An integrating application may divide its transactions into several categories where each category requires a distinct set of approval rules. Each set of rules is called a transaction type. Different transaction types can use the same attribute name to represent values that are calculated in different ways or fetched from different places.
  
  * FNDLOAD apps/apps 0 Y DOWNLOAD amescvar.lct hubtrantype.ldt AME_CALLING_APPS APPLICATION_SHORT_NAME=SQLAP TRANSACTION_TYPE_ID=SBTRANSTYPE
  
  * FNDLOAD apps/apps 0 Y UPLOAD amescvar.lct hubtrantype.ldt