1 Reply Latest reply: Oct 1, 2014 10:48 AM by dbowman-Oracle RSS

    Publicaton error : ORA-20001: EXPLORETREE_ERROR

    Vijay Nimmakuri

      Hi All,

       

      When attempting to publish a specific model, the following error occurs. This model was published successfully around a month ago. Some additional items were added to the Bill of Material and the model was refreshed since then. A new User Interface was also created. The issue seems to be isolated to this one model. The logic generates without error and the model can launch from the Developer without issue. However, there is a related error when the model is attempted to publish to target instance and copied to another folder.

       

      ************ Log for Publication **************

      Publication failed. See concurrent program logs for details.

      +---------------------------------------------------------------------------+

      Start of log messages from FND_FILE

      +---------------------------------------------------------------------------+

      BOM Synchronization, version 115.36.115101.6, started 2014/07/11/08:16:56, session run ID: 61610

      ORA-20001: EXPLORETREE_ERROR

      ORA-06512: at "APPS.CZ_PB_MGR", line 2617 in Package cz_pb_mgr Procedure INSERT_JRAD_DOCS

      CZ_PB_EXPORT_OA_UI_ERR (SQLERRM=ORA-20001: EXPLORETREE_ERROR

      ORA-06512: at "APPS.CZ_PB_MGR", line 2617)

      Error in upload of UI schema for publication id : 256845

      Fatal publication error, process aborted for publication 256845: ORA-20001: EXPLORETREE_ERROR

      ORA-06512: at "APPS.CZ_PB_MGR", line 2617

      Parent model in publication request : 323847

      Source publication : 256845 target publication:

      +---------------------------------------------------------------------------+

      End of log messages from FND_FILE

      +---------------------------------------------------------------------------+

       

      **************** Error message while copying the Model to backup folder*************

      Failed to copy Model because ORA-20001: EXPLORETREE_ERROR in Package cz_pb_mgr Procedure INSERT_JRAD_DOCS

      Failed to copy Model because CZ_PB_EXPORT_OA_UI_ERR (SQLERRM=ORA-20001: EXPLORETREE_ERROR)

      Failed to copy Model because MODEL: 323235 copy failed

      Failed to copy Model because Error in retrieving remote model id : ORA-01403: no data found

       

      STEPS

      -----------------------

      The issue can be reproduced at will with the following steps:

      1. Log in to Oracle Configurator Developer responsibility

      2. Navigate to Publications tab

      3. Create a new publication for this model

      4. Navigate Home > Schedule > Process a Single Publication Model

      5. Enter the publication created in #3

      6. Enter other appropriate publication parameters

      7. Submit

      8. Error occurs

       

      Any Help on this is highly appriciated.

       

      Thanks,

      Vijay