[Oracle]ORA-20001: Organization Unit Type is Invalid, ORA-06512 At HR_ORGANIZATION_API and GL_LEDGERS_PKG

 R12 ASM When Complete the Accounting Setup it Fails with ORA-20001: Organization Unit Type is Invalid, ORA-06512 At HR_ORGANIZATION_API and GL_LEDGERS_PKG (Doc ID 560007.1)

SELECT HAOU.ORGANIZATION_ID,
       HAOU.DATE_FROM,
       HAOU.NAME,
       HAOU.TYPE,
       HAOU.INTERNAL_EXTERNAL_FLAG,
       HAOU.LOCATION_ID,
       HOU.SET_OF_BOOKS_ID,
       NULL USABLE_FLAG,
       HOU.SHORT_CODE,
       HOU.DEFAULT_LEGAL_CONTEXT_ID,
       HAOU.OBJECT_VERSION_NUMBER
  FROM HR_OPERATING_UNITS HOU, HR_ALL_ORGANIZATION_UNITS HAOU
 WHERE SET_OF_BOOKS_ID = 1003
   AND HAOU.ORGANIZATION_ID = HOU.ORGANIZATION_ID;

SELECT *
  FROM HR_LOOKUPS
 WHERE LOOKUP_TYPE = 'ORG_TYPE'
   AND LOOKUP_CODE = 'OU'; --將第一個SQL查詢出來TYPE填入

SELECT LOOKUP_CODE,ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE
  FROM HR_LOOKUPS
 WHERE LOOKUP_TYPE = 'ORG_TYPE'
   AND LOOKUP_CODE IN ('OU', 'BG');

最後確認第一個SQL的HAOU.DATE_FROM與第三個SQL START_DATE_ACTIVE時間是否一致，如果沒有一致，修改成一致

Global HR Manager >  Other Definitions -> Application Utilities Lookups