APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error.
After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue??
I have 2 workspaces, the one regard as Dev env, another regard as Pro. env. When the change need to be migrated, the some page of Dev workspace should be copy to Pro. one. I export the pages what I want to move from Dev., then try to import it into Pro. but I get the error as below:
Page Origin: This page was exported from a different application or from an application in different workspace. Page cannot be installed in this application. I don't want to copy the page one by one.
I have multiple application set-up using session sharing within the workspace.Technically all works fine, however it does not play nice with user behaviour.
Example: Users logs into APP_ID:100. Since he isn't authenticated yet, he provides user/pass and the APP_SESSION is authenticated. Now if the user switches using to another application (using a link provided in application 100) he gets redirect to APP_ID:101:APP_SESSION all is fine.
The session is already authenticated, the application shares the session and the user gains access to app 101 without having to authenticate again. All's fine!
However users don't behave they way. Instead of using an easy link in the application. They will use their own bookmark or type in the url for app 101 manually. That way the next application is either called with f?p=101:1:[SOME OLD SESSIONID FROM BOOMARK] or f?p=101 (with no further page or session info) In both cases instead of using the already authenticated session apex spawns a new session, which of course isn't authenticated yet thus forcing the user to authenticate and come complaining they have to login again.
Similar behaviour problems exists when the user opens a browser and tries to open both applications in each in a tab next to each other.Both tabs fetch there own initial session id and start writing it to the same cookie each in turn invalidating the other tab's session.These can lead to some fanatic ping pong actions. Thus it's impossible to open 2 applications sharing session in the same browser.
Is there any remedy for these situations?Can apex be as smart as for instance first trying to resume the session stored in the cookie and only if that session is invalid, start a new session?
I am trying to export a workspace from apex 3.2 to apex 4.2. After the workspace has been imported into apex 4.2, do I have to export and import the applications too? Don't applications reside on workspace and therefore if a workspace is imported, all the applications should have been imported by default?
I need to export my whole workspace/application from Oracle Application Express so if i was to move onto a new pc and install oracle again. I can import this file and everything will be as it was without need of editing anything.
Is this possible if so how? - Preferably export into 1 big file so importing will be with 1 mouse click instead of exporting to seperate database files etc.
I support an APEX app that has one workspace for Development and one for the live Production application. When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time).
The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date. I would like to do a couple things:
1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical 2) execute SQL to truncate Dev tables and refresh from Prod Is there a way to do this?
There are two applications in the work space. Both the application have a link to navigation back and forth to the each other. have created a DB authentication to both the application.
My Requirement is if user log's into one application and navigate to other it must not ask for username and password
Is there a way to make a button conditional on the existence of another app in the same workspace. What I am trying to do is have a MAIN app and several other MODULE apps in the same workspace. Then a button on a form in the MAIN app that will redirect to a specific page in one of the MODULE apps. If the MODULE app does not exist, meaning not installed, then the button would be invisible.
Our apex currently has LDAP authentication scheme. We have many applications within the workspace. We are looking for a way to have one authentication scheme defined for all the applications so that user doesn't have to enter username/password for each application. How can I share my LDAP authentication scheme for multiple applications.
I would like to change the printing settings in my workspace Instance settings. But, I can't find the "Manage Instance" option mentioned in the tutorials.
I have created a workspace to use oracle apex, after a while I tried to run a script, the following message has been displayed to me, The script output reached the maximum workspace result size limit. Delete existing results or contact your administrator to increase the maximum workspace result size.
I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
Unless I'm not understanding this error it means that it can find the ACTION part that is attached to the WHAT part of this Dynamic Action? The Dynamic Action does work when the application is run (in Development)also, there are 3 others that are similar to this one. The export was created by the export utility in the Application Builder.
If I export only the page and import that into Production the import is successful and the page runs correctly. This is error is happening only when I try to import the entire Application.There are many other changes made which is why I was trying to do an Application export/import instead of individual pages.
I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.
Begin Package call...... If v_error_code <> '0' Then Raise SC_Error; End if;Exception When SC_Error Then RAise_Application_error(v_err_code, v_err_msg);End;
But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:
Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.
Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..
An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59
We just upgraded from Application Express 4.0.2.00.07 to Application Express 4.2.2.00.11. We are using one common application to authenticate and redirect to other applications.
URL....The upgade from 4.0 to 4.2 went fine, existing applications work, Builder works fine. But none of the packaged applications install, all of them fail with that error. Is there some post-upgrade step to complete to get this to work?
Also, it doesn't appear like we can select the application id when installing these applications! Our environment has a convention, of sorts, for application ids. Is there a way to over-ride the app id?
I receive this error. In my opinion the problem could be related to the presence of one personalized authentication schemas, based on a DB function, taken from a Packaged application, some years ago, called "menu_framework". This is the error report: ........ -- Now beginning upgrade. This will take several minutes.------- -- Ensuring template names are unique ------- -- Migrating metadata to new schema ------- -- Switching builder to new schema ------- begin * ERRORE alla riga 1: ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj], [0x26962168], [0x1A1042F4], [], [], [], [], [], [], [], [], []
1) after the error trap, I copied the Image folder and tried to launch APEX. It was possible to lunch the development pages, but impossible to execute any application with the error: Authentication Schema not Supported 2) then decided to downgrade to APEX 4.0, following the proper instructions: received a similar error: ....... SQL> exec apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000 '); BEGIN apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000'); END;
I am getting error while creating a trigger. I am not yet find any wrong statement. See the following code and comments.
SQL> CREATE OR REPLACE TRIGGER shclog_in before update on shclog for each row WHEN (to_number(new.MSGTYPE) = 210) 2 3 declare 4 PRAGMA AUTONOMOUS_TRANSACTION; 5 begin 6 insert into starcas.transaction_log values(:new.PAN, [code].......
Warning: Trigger created with compilation errors.
SQL> show error Errors for TRIGGER SHCLOG_IN:
LINE/COL ERROR -------- ----------------------------------------------------------------- 4/1 PL/SQL: SQL Statement ignored 4/21 PL/SQL: ORA-00942: table or view does not exist SQL>
i have ir report and one column value coming from function,when open the IR report its giving error..
IR report code SELECT CS_ID ,CS_NAME, Util_func(PASS_ID) as "ALERT_DAYS" from "CSD_MASTERS" Function code FUNCTION Util_func(PASS_ID NUMBER) RETURN number IS ALERT_DAYS NUMBER:=0; BEGIN [code]........
I am getting many warning messages in the error console using Firefox V 13. This one seems to be the most prevalent. It's not causing problems except that on some machines it causes the error console to pop up and is distracting for the users.
I got error "Upload New Image must be specified. Click browse to select an image from your local computer" while i upload image in shared components>image>create ...
my logo is saved in local drive D. when i browse file and click to upload it gives error that i mentioned. This is happening with every uploading weather its image or weather its plugin.
i'm trying to get the difference between two dates so i have two date itemsthen i did daynamic action (set Value) and choose pl/sql function then added the following codeDecalrestart_date date;end_date datebeginstart_date:=to_date(:p20_start_date,'dd/mm/rrrr');select to_date (sysdate,' dd/ mm /rrrr')into end_datefrom dual;return end_date-start_date;end; but when i run the page i got error ora-01861
REVNUMBER is a VARCHAR2. I've set it to increment by letter in alphabet to note the revision of a document, i.e. IR*, A, B, C... . This works beautifully.
VERNUMBER is a VARCHAR2. I've set it to increment by number but starts from null to 'IR' to 1, 2, 3...
Until now, I've been incrementing VERNUMBER without problem if, instead of IR as the first incremented value I leave the field null. The user has asked that IR display. I've tried using IR as the default but I still need to increment from there so I don't see it making a difference between that or dumping it as the first condition of the following. The problem is I get an invalid number error either way.
*'IR' = 'Initial Release'
SELECT CASE WHEN VERNUMBER IS NULL THEN 'IR' WHEN VERNUMBER = 'IR' THEN '1' ELSE REGEXP_REPLACE(VERNUMBER, '[0-9]+$', REGEXP_SUBSTR(UPPER(VERNUMBER), '[0-9]+$') + 1) END NEW_VERSION FROM DOC_INFO WHERE DOC_INFO_ID = :P3_DOC_INFO_ID
A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,
I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?
It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:
SQL> startup nomount ORACLE instance started. Total System Global Area 247463936 bytes Fixed Size 2235856 bytes Variable Size 177840688 bytes
I am getting compilation error when create nested table type depend on table structure
SQL> CREATE OR REPLACE TYPE typ$nttb$1 IS TABLE OF emp%rowtype 2 ; 3 /
Warning: Type created with compilation errors.
SQL> show error Errors for TYPE TYP$NTTB$1:
LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 PL/SQL: Compilation unit analysis terminated 1/29 PLS-00329: schema-level type has illegal reference to SCOTT.EMP SQL>
I am using APEX 4.1.Using the documentation [URL]... I'm trying to implement my own custom error message.My problem: The placeholders in the text message are not replaced and I don't know what I'm doing wrong.
Example: APEX_ERROR.ADD_ERROR ( p_error_code => 'This is a text message with one placeholder: %0', p0 => my_variable, p_display_location => apex_error.c_inline_with_field_and_notif, p_page_item_name => 'P13_MY_PAGE_ITEM'
);The result is an error message as follows: This is a text message with one placeholder: %0 (Go to error)
