How to Migrate AME to R12 During Upgrade from 11i to R12?

How to Migrate AME to R12 During Upgrade from 11i to R12?




FIX

In R12 ,The Item_Type for Payables Invoice Approval Workflow is changed from APINV to APINVAPR and this new workflow is released through file apfhanwf.wft


In-progress workflow items APINV should, in general, upgrade smoothly. However, You could consider reducing the number of in-progress workflow items by turning off Invoice Approval Workflow before starting the upgrade and validate this with testing, especially where you have customized Release 11i pre-seeded workflow processes or activities.

After Upgrade to R12 all newly Initiated Invoices will be started with New Workflow Process with Item_type=APINVAPR.

The Upgrade script in R12 will Update all Pending Workflows from 11i(APINV) which are in 'Initiated' status to 'Required' Status and resetting the approval_ready_flag to Y
Once the upgrade is Completed , User need to Re-Initiate these Workflows for Approval Again by Using Option Action> Initiate OR Running the Approval Concurrent Program.
Once Re-Initiated the Approval Status for these Invoices will be changed to 'Initiated' and new Workflow Process with Item_Type=APINVAPR will be started.

Following Table Lists wfapproval_status before and After the Upgrade to R12



Approval Status in 11i Approval status to in R12 Approval_ready_flag in R12
----------------------- ------------------------- -------------------------

INITIATED REQUIRED Y
APPROVED same as 11i same as 11i
MANUALLY APPROVED same as 11i same as 11i
NOT REQUIRED same as 11i same as 11i
REJECTED same as 11i same as 11i
REQUIRED same as 11i same as 11i
WFAPPROVED same as 11i same as 11i


However, depending on how did you setup your rules, as datamodel changed between 11i and R12, the setup might need to be reviewed/ revisited after upgrade- as there is nothing like automated upgrade, the rules / approval groups are the same