Search results for query: *

Hello, Where can I find a list of the additional APIs and Open Interfaces in R12 compared to the 11i version of Oracle Application ?

I have a script creating a file, but I am not sure of the best way to do it. Should it be echo "...." > test or cat filename <<EOF ... EOF The file is a script itself containing quotes. Thanks for your answers

Is there some best practices regarding the use of the shift command to read input parameters to a script (AIX) ? I have seen some guidelines where they use the shift command from the 7th parameter. Is there any particular reasons for that ?

Hello, I would like to know if we can use a mask for the type NUMBER in an external table. I load an file with amount that are sign, and I want to be sure that they are always signed. example +5555 -> in the DB : 5555 -123 -> -123 in the DB However 234 should be rejected (no sign)...

Hello, I want to create a partition on a VARCHAR2(6) field (year + month), but our DBAs only want partition based on dates. I tried the following: CREATE table ...( ACCPER VARCHAR2(6), .... ) PARTITION by range (ACCPER) (partition P200611 values less than (to_date('200612','YYYYMM'))) but I...

Hi, We have a problem of pointer that we are not able to solve. The problem is: we have an entity in our logical model, but when we generate the physical model, nothing appears. The merge screen, doesn't seem to see the entity. Any ideas ?

Hi, I am designing a datamart with 2 facts table. The dimension of one of these tables is very big, and therefore cannot be moved from the ODS to the datamart. How can I have a fact table in a datamart and one of its dimension in the data store ?

Hi, Is it possible to create indexes on a table via a macro ? I have some tables created with a make table query, is there a way to create the indexes without using the menu ? Thanks in advance for your answers

Hi, I am trying to display in the data from a week in year Y and year Y-1 in order to compare them in a single result: The week is formatted YYYYWW Week Income Y Income Y-1 200510 10 15 (results of the week 200410) How can I do that as the lag function cannot work...

Hi, While writing some code, I was wondering if it is better to select 1 info per select from dual, or to group them into 1 select ? i.e.: is SELECT a, b, c INTO v_a, v_b, v_c FROM dual; better than SELECT a into v_a from dual; SELECT b into v_b from dual; SELECT c into v_c from dual; ...

Hi, We would like to connect discoverer with 2 databases: 1 is for Oracle Application (to access some packages), the other one contains our datawarehouse. Is that possible with Discoverer 9i ? Our contractors don't seem to be able to do it... Thanks for your answers

How can I connect a non Oracle database from Forms v6i. I have an ODBC link, but I guess there is something else to do, but I don't know what... Can you help ? Thank you

Hi, I have a query returning amounts per outlets, per dates (7 dates): outlet Amount date 1001 12 21/02/05 1001 13 22/02/05 1001 5 23/02/05 1001 0 24/02/05 1001 0 25/02/05 1001 0 26/02/05 1001 0 28/02/05 1002 4...

Hi, What are the hardware requirements to install db2 udb on windows server 2003 ? I am currently running a v7.2 version on NT 4. Can it run on Windows server 2003 ? I can't find a table with all the versions on the IBM web site. and compatibilities Thanks for your answers

Hi, I am looking for a way to dynamically change the status of the FND_CONC_REQUESTS in order to tell a user that a batch failed. The problem is that if I change the status to 'E', because I consider that there is a problem, Oracle Application will change it back to 'C' if there isn't a...

I have a form which includes 2 blocks linked by a relation master-details. I can key and insert data without any problem, but when I save the data and go back to a line (details) and modify a field I have the message FRM-40654, although I am the only one to work on this record. I haven't got any...

While doing a F11 (query-find) in a specific forms in Oracle application, I get the message FRM-40202 Field must be entered because I have some mandatory fields. The screen is opened in creation mode but it should not stop the user to do a query. Any idea ? Thanks

Hi, I have a list of value (strings, with a comma between the words to separate them), and for each words of this list I would like to know if it is in another list (built in the same way). Is there a simple way to do that in Pl sql ? list1:='NUM_FOURN,NUM_PDV,COD_VAT' list2:='NUM_PDV,COD_VAT'...

I use the following query that returns all my subscribtions with an end date greater than the 1st of June: SELECT Abonnements01.* FROM Abonnements01 WHERE (DATE_FIN>#06/01/2004#'); However, if I do the same for the 28th of Feb, the following query also works: SELECT Abonnements01.* FROM...

Hi, I call a module from a screen where I have the focus on a specific line. In the module called I do a treatment that will update the caller. When I come back to the caller I do an execute_query to refresh the data, but doing so, I lose the focus on the line. How can I store and reapply the...