Wednesday, February 29, 2012

How to migrate AME setups using FNDLOAD

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, OIE 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.

1. AME Conditions:


Note: To Download AME Conditions you must find Application Short Name, Transaction Type Short Name(Transaction_Type_Id), and Condition Key


A) Download the AME Condition:
FNDLOAD apps/appsPassword 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>"


B) Upload the AME Condition:
FNDLOAD apps/appsPassword 0 Y UPLOAD $AME_TOP/patch/115/import/amesconk.lct <filename>.ldt


2. Approval Groups


Note: To Download  you must find the  AME Approval Groups name


A) Download Approval Groups:
FNDLOAD apps/appsPassword 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesappg.lct <filename>.ldt AME_APPROVAL_GROUPS APPROVAL_GROUP_NAME="<ApprovalGroup Name>"


B) Upload Approval Groups:
FNDLOAD apps/appsPassword 0 Y UPLOAD $AME_TOP/patch/115/import/amesappg.lct <filename>.ldt



3. AME Rules:


Note: To Download  you must find  Application Short Name, Transaction Type Short Name(Transaction_Type_Id) and Rule Key


A) Download AME Rules
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>"

B) Upload AME Rules
FNDLOAD apps/appsPassword 0 Y UPLOAD $AME_TOP/patch/115/import/amesrulk.lct <filename>.ldt



4. AME Action Type Usages:


Note: To Download  you must find  Application Short Name, Transaction Type Short Name(Transaction_Type_Id) and Rule Key


A) Download AME Action Type Usage:
FNDLOAD apps/appsPassword 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>"


B) Upload AME Action Type Usage:
FNDLOAD apps/appsPassword 0 Y UPLOAD $AME_TOP/patch/115/import/amesacus.lct <filename>.ldt

5. AME Transaction Types:

Note: To Download  you must find  Application Short Name, Transaction Type Short Name(Transaction_Type_Id)

A) Download AME Transaction Type Usage:
FNDLOAD apps/<apps pwd> 0 Y DOWNLOAD amescvar.lct <filename>.ldt AME_CALLING_APPS APPLICATION_SHORT_NAME=<Application short name> TRANSACTION_TYPE_ID=<AME transaction type short name>

A) Upload AME Transaction Type Usage:
FNDLOAD apps/<apps pwd> 0 Y UPLOAD amescvar.lct <filename>.ldt

6. AME Attributes:

Note: To Download  you must find  Application Short Name, Transaction Type Short Name(Transaction_Type_Id), Attribute Name

A) Download AME Attribute Usage:
FNDLOAD apps/<apps password> 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>

A) Upload AME Attriibute Usage:
FNDLOAD apps/<apps pwd> 0 Y UPLOAD amesmatr.lct <filename>.ldt