Hello,
My current version : Apex 4.1.1.00.23 ; with OHS.
I'm using the apex_application_install package for a long time.
Here I'm trying to import an application which I've modified in another instance. Source application Id : 2126 ; target application Id : 2201.
begin
apex_application_install.set_application_id( 2201);
apex_application_install.set_offset( p_offset => 8977032305205669 );
apex_application_install.set_application_name('APP_TST');
apex_application_install.set_application_alias( 'F2201');
apex_application_install.set_schema( 'SCH_TST' );
end;
/
@f2126
First I get an error cause the target application was not deleted yet. So I deleted both of it (2126 and 2201). But now :
APPLICATION 2126 - APP_DEV
Set Credentials...
Check Compatibility...
Set Application ID...
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (APEX_040100.WWV_FLOWS_FK) violated - parent
key not found
ORA-06512: at "APEX_040100.WWV_FLOW_API", line 679
ORA-06512: at line 3
Add a 'generate_offset' instead of the 'set_offset..' doesn't resolve anything.
So I've 2 questions :
1) How can I import this application
2) If I must delete the target application before the import, how can I keep metadata, I mean saved interactive reports each user have created for each application ?
Many thanks for your help.
Fanny