How To Avoid Bouncing the Database after Changing a Workflow Package? [ID 754993.1]

Modified:12-Feb-2012Type:HOWTOStatus:PUBLISHEDPriority:3

ORACLE ERP workflow 사용중 발생한 OBJECT 사용오류

1. 원인

   확인중

2. Workflow내역확인

 $FND_TOP/sql/wfstatus.sql

ORA-04061:

ORA-04065: 

ORA-06508:

3. 조치방안

A. OBJECT Recompile

 조치후에도 동일 오류 발생시 B 실행

B. Shared pool flush

    - Concurrent Manager shutdown

    - alter system flush shared_pool;

    - Package Update or Recompile

    - Concurrent Manager Restart