Issue Impact

Purchase Orders are not getting approved, and are getting stuck in the workflow under 'error' status.Purchase Order status shown as 'In Process'.

Issue Description

1. To investigate the error you must check the adpatch.log and logs associated with the worker files. These can be found under following directory:

$APPL_TOP/admin/[SID]/log

This can be done in several ways. Below I have described the most easiest ones.

Option 1 - Use 'adadmin' utility to recompile all invalid objects in the database

1. Start adctrl utility (see more info here How to use adctrl utility to restart failed worker in patch application?)

2. You will be shown 7 options in the main menu. But there is an 8th option that is not shown.

You must complete the following steps in order to upgrade from Oracle E Business Suite (EBS) 12.1.1 to 12.1.3.

1. Download Patch 9239030. Unzip patch in a directory - say /u01/patches. Now make sure you give execute permissions on this directory. To be on safe side I simply use the following command: