how to integrate Application Express with Oracle EBS. Any companies that offer hosted EBS environment with APEX and allow developer-level access (ie database, application server, front-end responsibilities)?
View 1 RepliesI have registered an APEX (Oracle) online database and I can connect to database online.But my problem is how to define a connection string that can connect from the program written in C# to connect to APEX account(apex.oracle.com).I even don't know how to use the tool Oracle SQL Developer to connect to APEX account.
View 3 Replies View RelatedI am trying to install oracle developer days 4.1 to test the oracle apex 4.1. When I load the .ovf image into virtual box and launch it, I go to
[URL]........
but I cannot see the administration page, it doesn't show me anything. Is there any installations that I have to do or missed to make apex work ?
When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;
[code]...
We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.
Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.
But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.
ERROR: ORA-12545: Connect failed because target host or object does not exist
I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.
I'm using apex 4.1.1.00.23.I'm wondering whether it is is possible to 'freeze' a production APEX application in a runtime-only installation, during an upgrade. I want to prevent strange behaviour for logged in end users. In the application builder one can set the availability of the application. I was thinking of making the application unavailable during the upgrade. Is this possible in a runtime only env? How? Or are there (better) alternatives?
View 1 Replies View RelatedMy question is, if I define an object type (create type ... as object ...) is it possible to hold a variable of this type as the session level? For example, if I am creating an order using multiple web pages, it would be much easier (and intuitive) to create and manipulate an order object than to hold the data in generic collections.
If that is not possible, is there some way to make a generic Apex collection appear more application specific? By this I mean some way to map the columns C001, C002, ... to more intuitive names such as CUST_NO and ORDER_DATE. I had considered possibly creating a view of the APEX_COLLECTIONS view which would rename the columns but then I would also have to create a bunch of instead of triggers if I wanted to update it as well.
We want to deploy an apex environment. I see that there are 3 methods for apex installation:
Scenario 1: Downloading from OTN and Configuring the Oracle Application Express Listener
Scenario 2: Downloading from OTN and Configuring the Embedded PL/SQL Gateway
Scenario 3: Downloading from OTN and Configuring Oracle HTTP Server
I think the applications that we will create in apex will have 50-100 users. We don't use RAC.
i'm trying to install a development-environment. The production- and testing-environmens are working, but i have problems with the development.
I installed Oracle 10g XE 10.2.0.1.0 and Apex 4.1.1.00.23 on my Oracle VM Virtual Box (Windows 7 Professional 64 bit).
127.0.0.1:8080/apex works from the Virtual Box.
192.168.11.42:8080/apex (the IP in my network) and 192.168.11.42:8080 work either from the Virtual Box.
But it doesn't work from other clients in my network. So far i tried exec dbms_xdb.setlistenerlocalaccess(false).
I am trying to create a tabular form based on a SQL query, that has a query-based select list with a where clause that references a column in the originating SQL query.
The situation is, I have a table that stores client_id, source_id and build_id, lets call it client_source. I have a second table, build_source, that contains source_id and build_id, with a one to many relationship between the two (source_id of 1 could have build_id of 1-7).
Using a tabular form, I want to select the corresponding build_id to be used in client_source, but the select list must only contain the build_id's for that rows particular source_id.
Here is an example of the SQL source of my tabular form;
select
s.ROWID,
s.CLIENT_ID,
s.SOURCE_ID,
APEX_ITEM.SELECT_LIST_FROM_QUERY(1, s.BUILD_ID,
'select b.build_id display, b.build_id return from
build_source b where b.source_id = s.SOURCE_ID ') lst
from client_source s
... what I am trying to achieve is that the source_id fields in bold match. When the query is built this way I get an 'invalid identifier' Oracle error on s.SOURCE_ID at runtime.
Is there some special tags that need to be used to reference the outside column?I am running on Application Express 4.1.0.00.32, on a Oracle 10g release 10.2.0.4.0 database.
I just installed Apex and want to create an application that accesses data in a non-Apex schema. However, when I create an application I can't see objects in other schemas. I tried specifying the schema and tablename (e.g. apps.gl_je_headers) but that didn't work. I can only see objects in the APEX schema. How do I reference other schemas when I create an application?
View 1 Replies View RelatedI am working in all 3 environments: development , Test and Production. How can we access the tables created in one environment in the other environment. Also, request to share the SQL code for the same.
I am using Oracle Sql Developer tool.
i've followed previous threads on this issue, but still cannot get my applet to run from apex. below is the source for my page:
<html>
<head>
<title> LAND MAP </title>
</head>
<body>
<APPLET
id="LandApplet2"
CODE="LandApplet2.class"
width="700" height="300">
[code]....
So as luck would have it my Win XP OS crashed. Yes, its the office laptop and I cannot upgrade the OS for now. Anyhow, I got the whole machine re-imaged and installed 10g which had version 2.1 and everything was okay. I was earlier running apex 4.1.1. I could not find that setup on the oracle site so I downloaded apex 4.2 and ran the installation as per page
[URL].........
Everything went through properly except for step
5. Log back into SQL*Plus (as above) and load images:
SQL> @apxldimg.sql APEX_HOME
[Note: APEX_HOME is the directory you specified when unzipping the file. For example, with Windows 'C:'.]
where it asked me to enter the directory and I entered C:
This is what happened
SQL> @apxldimg.sql
PL/SQL procedure successfully completed.
Enter value for 1: C:
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as 'C:/apex/images'
Directory created.
^C
C:apex>
I see a backslash and forward slash so I did a ctrl c . When I tried running the command again - @apxldimg.sql
it just would open the .sql file.
Not sure if this is the issue, but anyhow, after this, when I tried the "go to database page. It just shows a blank page. I was happy with 4.1.1. Is that available anywhere? Maybe I can remove XE and do a fresh install with that.
Trying to connect to XE 11.2 getting the following:
Unable to connectSQLState=51000[Oracle][ODBC][Ora]ORA12705: Cannot access NLS data files or invalid environment specified.
I have set the environment variables using the oracle_env.sh shell script. Trying to connect with the instant client running on Windows XP with the ODBC extensions installed. Host is X86_64 CentOS Linux
Given:
- Apex 4.2
- Application Theme: Bluejay-22
- Page Template Class: Two Level Tabs
Required:
- Convert 2nd Level Tabs of (Bluejay-22 Theme) to be Drop-Down Menus as in (Application Builder Theme)
- Where can I find documentation for app_AppMenuMultiOpenBottom3
Current Situation
- Only the first level tabs are converted to match the (Application Builder Theme).
- The Drop-Down menus of the second level tabs are not working
Steps tried
1) link the following CSS's into the Header section of the Page Template of (Bluejay-22)
<link rel="stylesheet" href="/i/css/apex_builder.min.css?v=4.2.0.00.27" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui.min.css?v=4.2.0.00.27" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui_builder_home.css" type="text/css" />2) link the following Scripts into the Header section of the Page Template
<script type="text/javascript">
[code].....
I installed Apex 4.2.1 and now m not able to start the page .
[URL] ...
or
[URL] ....
or
[URL] ....
and only see a blank page.
I am new to Oracle APEX, and have a few questions regarding the user information.
I've created a new workspace on my local APEX installation, created some users in the workspace, and divided them into roles as "Managers" and "Employees". I am the only Dev and Admin of the workspace, and the users (Managers and Employees) I have created are viewers.
I'd like to create database tables in the workspace where some field would refer to the user ID of the created user as a foreign key, and their role. Similarly, I'd like to create pages where a particular region is displayed only if the logged in user is a "Manager". How can I access the user data and the role data using SQL?
I see following tables in my workspace, so which table contains the user information:
APEX$_ACL
APEX$_WS_FILES
APEX$_WS_HISTORY
APEX$_WS_LINKS
APEX$_WS_NOTES
[Code]....
restrict access to page or component for particular user. when that user login , restricted page should not be visible to the user..
APEX Verison :4.2
I have installed APEX on my local machine, created a workspace, and added a few users with roles.
I am creating an application, similar to a Library app, where I have a table that stores Books information (BOOK_ID, BOOK_NAME, etc). I'd like to create another table BOOK_USER with two columns, BOOK_ID and USER_ID. BOOK_ID would refer to the BOOKS table, and I want USER_ID to refer to the table that stores user details of the workspace that I am using. The data entry would happen from a page that has two LOVs, one for book name (using BOOK_ID as the value) and another for user name (USER_ID, or whatever field APEX uses to store user's ID). Can I do that in APEX? I've found ways to access and authenticate a user for a page, but how to get data of all users in the workspace? In other words, how to get all usernames in a LOV?
I exported oracle database from one server in a dmp file. then i imported it in another oracle database server. when i saw the imported data the columns which were storing german data is in rubbish characters.
then i remember that the database from where i exported is having nls language as german. i executed this statement to set the nls on the new server
alter system set nls_lang=german SCOPE=SPFILE
but now my database is not getting started always giving me error - cannot access NLS data files or invalid environment specified.
i also set the path NLS_LANG=german in the solaris environment.
Apex 4.1.1
Oracle 11g
I have two applications both in the same workspace. I want to log into one of them, but then have a link to a page in the second application, without having to enter a login to the second application.
Trying to follow the following from a while back, but cannot make it work in apex 4.1.1. Is it possible to access two application with one login? Both application are using the same ldap authentication.
I have both applications using the same get cookie process on page 101
{
declare
v varchar2(255) := null;
c owa_cookie.cookie;
begin
c := owa_cookie.get('LOGIN_USERNAME_COOKIE');
:P101_USERNAME := c.vals(1);
exception when others then null;
end; }
The link I use to the second application is a javascript pop window for displaying the second application and call it with the java pop up url
{
javascript:popUp('f?p=366:1:&SESSION.:::::')
}
However, it still asks me for the login to the the second application. I found other conversations that said to fill in the cookie name in the Session Cookie Attributes in Security, Authentication of the second application and entered the cookie name LOGIN_USERNAME_COOKIE here. However I still get the second application login screen now with a bunch of numbers in the username field.
What am I missing to get this to work without having to login again for the second application?
How can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?
I created a page and button for link but struggling for above.
I have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.
To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.
Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.
My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)
I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?
View 2 Replies View RelatedI'm setting up APEX REST security by following the instructions from [URL]...Everything works great according to document.
I can acquire a token, then passing it in the header to get needed data from REST service. Consumer acquires an token by going on web browser to [URL]...
It will be redirected to[URL]... asking for username and password on browser. Once entering them correctly, it will be directed to Redirect URI defined in the OAuth2 client with the token in the URL.
My question is that is it possible to do token acquiring by coding (like in Salesforce) without going to web browser? We've tried doing that, it will stop due to redirect to sign-on.
I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.
I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen
SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:
[code]...
warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection
why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
How to give ROLE access to users in PL/SQL developer Tool..??
View 3 Replies View RelatedI am using Developer 2000 Application with Oracle 9i DB(32-bit on Windows) at backend. Now I install a new server with 10g(64-bit on Linux) and load all the data into it. Some of the forms and reports are hanging while it runs against 9i well.
View 4 Replies View Related