Oracle EBS 客制键弹性域编译失败

之前客户化开发定制键弹性域，由于用户需求修改键弹性域结构。保存编译时，请求“弹性域视图生成器”提示如下错误：

+---------------------------------------------------------------------------+应用对象程序库: Version : 11.5.0 - DevelopmentCopyright (c) 1979, 1999, Oracle Corporation. All rights reserved.FDFVGN module: 弹性域视图生成器+---------------------------------------------------------------------------+当前的系统时间为 16-10-2015 09:39:35+---------------------------------------------------------------------------+CREATE OR REPLACE VIEW CUX_POCATEGORIES_KFV  (ROW_ID, CATEGORY_ID, STRUCTURE_ID,   CONCATENATED_SEGMENTS,  PADDED_CONCATENATED_SEGMENTS,   SEGMENT27, ATTRIBUTE13, ATTRIBUTE12, ATTRIBUTE14, SEGMENT5, SEGMENT19, ENABLED_FLAG, SEGMENT8, LAST_UPDATE_DATE, ATTRIBUTE4, END_DATE_ACTIVE, SEGMENT2, SEGMENT12, ATTRIBUTE2, SEGMENT17, SEGMENT26, SEGMENT21, SEGMENT7, SEGMENT14, ATTRIBUTE5, LAST_UPDATED_BY, ATTRIBUTE1, SEGMENT30, LAST_UPDATE_LOGIN, SEGMENT16, ATTRIBUTE8, SEGMENT6, ATTRIBUTE11, SEGMENT9, SEGMENT10, SEGMENT29, SEGMENT23, SEGMENT18, SEGMENT25, SEGMENT28, ATTRIBUTE7, SEGMENT11, ATTRIBUTE15, ATTRIBUTE9, SEGMENT4, ATTRIBUTE_CATEGORY, SEGMENT3, SEGMENT1, ATTRIBUTE3, ATTRIBUTE10, START_DATE_ACTIVE, SEGMENT22, SEGMENT15, ATTRIBUTE6, SEGMENT24, SUMMARY_FLAG, SEGMENT13, SEGMENT20)  AS SELECT ROWID, CATEGORY_ID, STRUCTURE_ID,   (DECODE(STRUCTURE_ID,        50308, SEGMENT1 || '-' || SEGMENT2 || '-' || SEGMENT3 || '-' || SEGMENT4,        50309, SEGMENT1,        50310, SEGMENT1 || '-' || SEGMENT2 || '-' || SEGMENT3,        50311, SEGMENT1 || ',' || SEGMENT2 || ',' || SEGMENT3,        50312, SEGMENT1 || '.' || SEGMENT2,        50313, SEGMENT1 || '-' || SEGMENT2, NULL)),   (DECODE(STRUCTURE_ID,        50308, RPAD(NVL(SEGMENT1, ' '), 10) || '-' || RPAD(NVL(SEGMENT2, ' '), 10) || '-' || RPAD(NVL(SEGMENT3, ' '), 10) || '-' || RPAD(NVL(SEGMENT4, ' '), 10),        50309, RPAD(NVL(SEGMENT1, ' '), 10),        50310, RPAD(NVL(SEGMENT1, ' '), 10) || '-' || RPAD(NVL(SEGMENT2, ' '), 10) || '-' || RPAD(NVL(SEGMENT3, ' '), 10),        50311, RPAD(NVL(SEGMENT1, ' '), 10) || ',' || RPAD(NVL(SEGMENT2, ' '), 10) || ',' || RPAD(NVL(SEGMENT3, ' '), 10),        50312, RPAD(NVL(SEGMENT1, ' '), 10) || '.' || RPAD(NVL(SEGMENT2, ' '), 10),        50313, RPAD(NVL(SEGMENT1, ' '), 40) || '-' || RPAD(NVL(SEGMENT2, ' '), 3), NULL)),   SEGMENT27, ATTRIBUTE13, ATTRIBUTE12, ATTRIBUTE14, SEGMENT5, SEGMENT19, ENABLED_FLAG, SEGMENT8, LAST_UPDATE_DATE, ATTRIBUTE4, END_DATE_ACTIVE, SEGMENT2, SEGMENT12, ATTRIBUTE2, SEGMENT17, SEGMENT26, SEGMENT21, SEGMENT7, SEGMENT14, ATTRIBUTE5, LAST_UPDATED_BY, ATTRIBUTE1, SEGMENT30, LAST_UPDATE_LOGIN, SEGMENT16, ATTRIBUTE8, SEGMENT6, ATTRIBUTE11, SEGMENT9, SEGMENT10, SEGMENT29, SEGMENT23, SEGMENT18, SEGMENT25, SEGMENT28, ATTRIBUTE7, SEGMENT11, ATTRIBUTE15, ATTRIBUTE9, SEGMENT4, ATTRIBUTE_CATEGORY, SEGMENT3, SEGMENT1, ATTRIBUTE3, ATTRIBUTE10, START_DATE_ACTIVE, SEGMENT22, SEGMENT15, ATTRIBUTE6, SEGMENT24, SUMMARY_FLAG, SEGMENT13, SEGMENT20  FROM CUX_POCATEGORIESOracle 错误 20000：afuddl() [3_xdd] 中检测到 ORA-20000: APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema CUXORA-06512: 在"SYSTEM.AD_DDL", line 160ORA-06512: 在line 1。do_ddl(APPLSYS, CUX, 2, $statement$, CUX_POCATEGORIES_KFV): private_do_ddl(APPS, APPLSYS, CUX, 2, $statement$, CUX_POCATEGORIES_KFV): : check_for_apps_ddl(CUX): : substr($statement$,1,255)='CREATE OR REPLACE VIEW CUX_POCATEGORIES_KFV  (ROW_ID, CATEGORY_ID, STRUCTURE_ID,   CONCATENATED_SEGMENTS,  PADDED_CONCATENATED_SEGMENTS,   SEGMENT27, ATTRIBUTE13, ATTRIBUTE12, ATTRIBUTE14, SEGMENT5, SEGMENT19, ENABLED_FLAG, SEGMENT8, LAST_UPDATE_DATE,'CREATE OR REPLACE VIEW CUX_POCATEGORIES_KFV  AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE  FROM SYS.DUALOracle 错误 20000：afuddl() [3_xdd] 中检测到 ORA-20000: APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema CUXORA-06512: 在"SYSTEM.AD_DDL", line 160ORA-06512: 在line 1。do_ddl(APPLSYS, CUX, 2, $statement$, CUX_POCATEGORIES_KFV): private_do_ddl(APPS, APPLSYS, CUX, 2, $statement$, CUX_POCATEGORIES_KFV): : check_for_apps_ddl(CUX): : substr($statement$,1,255)='CREATE OR REPLACE VIEW CUX_POCATEGORIES_KFV  AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE  FROM SYS.DUAL'+---------------------------------------------------------------------------+FND_FILE 中日志消息开始+---------------------------------------------------------------------------++---------------------------------------------------------------------------+FND_FILE 中日志消息结束+---------------------------------------------------------------------------++---------------------------------------------------------------------------+正在执行请求完成选项...未打印输出文件，因为：已禁用此报表的打印选项。已完成执行请求完成选项。+---------------------------------------------------------------------------+已完成并发请求当前的系统时间为 16-10-2015 09:39:36+---------------------------------------------------------------------------+

详细查看请求日志，并在后台查看代码，发现客制化定义CUX的Schema的如下二包不存在：
1 CUX.APPS_DDL
2 CUX.APPS_ARRAY_DDL
经过查看Oracle EBS有关弹性域底层代码发现数据库中所有的SCHEMA都有对应包APPS_DDL和APPS_ARRAY_DDL，用于编译各个应用产品的键弹性域的。之前开发编译是好好的，为什么现在不行了呢？难道是数据丢或损坏，这可是一件非常可怕的事情。通过一个一个数据文件检查，并没有发现有什么坏块。起初尝试用定义同义词，然后重新编译键弹性域，仍然提示如上错误。
通从其它Oracle EBS数据库官方SCHEMA中保存这二个包，然后用CUX用户创建包APPS_DDL和APPS_ARRAY_DDL，重新编译客制化说明弹性成功。

有一次重新预克隆生产环境以后，发现这二个包又丢失。难道是客制化CUX应用产品没有配置好吗？