We've been having a problem with deploying an application since upgrading to 2.2.1. The error is specifically centered around an Application Level Item called APPL_BEGIN_DATE.
We Export the application using the Apex Export utility, choosing “No” to export comments and “No” to export Supporting Objects. We attempt an Import into either Apex version 2.0 or Apex version 2.2.1 (it doesn’t matter which – the result is the same) and an error is produced, apparently involving an Application Item named APPL_BEGIN_DATE.
Error text is:
ORA-20001: GET_BLOCK Error. ORA-2000: Execution of the statement was unsuccessful. ORA-00900: invalid SQL statement <pre>begin_date begin wwv_flow_api.create_flow_item(p_id=> 7083326619721376 + wwv_flow_api.g_id_offset, p_flow_id=>wwv_lfow.g_flow_id, p_name=>'APPL_BEGIN_DATE', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=>'N', p_required_patch=;>null+wwv_flow_api.g_id_offset,p_item_comment
Error Installing Application
I can provide a Word document with a screen shot of this error produced during an Install attempt (the Import works – the Install fails) and a copy of the Export file containing the offending APPL_BEGIN_DATE.
When I delete the Application Item APPL_BEGIN_DATE from the application and perform the Export, I can successfully Import and Install the application into either version 2.0 or version 2.2.1 without a problem. I simply must re-create APPL_BEGIN_DATE manually and the application works fine.
We really need to solve this problem for a number of reasons, the chief of which is we cannot afford to ask our clients to perform this manual operation just to get the application running.
Thanks
The Hotsos Team
(Doug)