We have recently implemented oracle contracts, purchasing, iprocurement etc. Consistently its been observed that the "workflow background process" runs for hours for itemtypes PO approval, Contract Approval, requisition approval etc.
Is this process run depends on the size/lines of the contract/po or do we need to look into other configurations to detect whats going wrong.
Pl post details of OS, database and EBS versions. Pl confirm that you are running 3 WF BG processes as per MOS Doc 466535.1 (see Q3). Are statistics up-to-date ? Is purging being done on a regular basis ? What does AWR/Statspack reports show ?