Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
error when using FND_STANDARD_DATE valueset
Hi Maran The format mask for the FND_STANDARD_DATE data type is “YYYY/MM/DD HH24:MI:SS”. As a result, PLSQL procedure will receive a value like ‘2017/07/14 00:00:00’ as the date. so if you want to query from database you need to use this format : (2017/07/14 00:00:00) not '14-JUL-2017'
Hi Maran
The format mask for the FND_STANDARD_DATE data type is “YYYY/MM/DD HH24:MI:SS”. As a result, PLSQL procedure will receive a value like ‘2017/07/14 00:00:00’ as the date.
so if you want to query from database you need to use this format : (2017/07/14 00:00:00) not ’14-JUL-2017′
See lessHow to check and test read/write permissions of Oracle directory?
You can use the UTL_FILE package. For example, this will verify that you can create a new file named your_test_file_name.txt in the directory and write data to it [code]DECLAREl_file utl_file.file_type;BEGINl_file := utl_file.fopen (‘UR_DIR’, ‘some_new_file_name.txt’, ‘W’);utl_file.put_line (l_file,Read more
You can use the
UTL_FILEpackage. For example, this will verify that you can create a new file namedyour_test_file_name.txtin the directory and write data to it[code]
DECLARE
l_file utl_file.file_type;
BEGIN
l_file := utl_file.fopen (‘UR_DIR’, ‘some_new_file_name.txt’, ‘W’);
utl_file.put_line (l_file, ‘Content of the file’);
utl_file.fclose (l_file);
EXCEPTION
WHEN utl_file.invalid_path THEN
dbms_output.put_line (‘File location is invalid’);
END;
[/code]
Also you can use
UTL_FILE.FGETATTRto check if your file is exist and readable or not for more info about UTL_FILE click here.If you are looking for How to grant read and write on directory in oracle you can check my answer here
Regards.
See lessORA-12015: cannot create a fast refresh materialized view from a complex query
Hello Albert, generally this the explanation for that error : ORA-12015: cannot create a fast refresh materialized view from a complex query Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries. Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETERead more
Hello Albert,
generally this the explanation for that error :
ORA-12015: cannot create a fast refresh materialized view from a complex query
Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries.
Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple
materialized view.
also to Diagnosing ORA-12015 fast refresh materialized view / complex queries that’s depend on the database version there is some restrictions ex:
Oracle10g – 10.2
——————–
Fast refreshable materialized views must be based on master tables, master materialized views, or synonyms of master tables
or master materialized views. Complete refresh must be used for a materialized view based on a view.
for further details about diagnosing refer to : Note.179466.1
hope this helpful.
See lessWhat is FNDLOAD command to migrate Messages from one instance to another ?
Hi, here is download and upload messages by FNDLOAD DOWNLOAD Command: FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MESSAGE_NAME.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='SQLGL' MESSAGE_NAME=XX_MESSAGE_NAME UPLOAD Command: FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/Read more
Hi,
here is download and upload messages by FNDLOAD
DOWNLOAD Command:
UPLOAD Command:
Don’t forget to change message name and application short name.
Regards.
See lessUnable To Finally Close Purchase Ordes or Blanket Releases Because of Error: APP-PO-14160
While reversal amounts are calculated, the Final_amt field is updated. This can be null when final_amt is already null. you can refer to Document : Doc ID 1990193.1 to find the solution.
While reversal amounts are calculated, the Final_amt field is updated. This can be null when final_amt is already null.
you can refer to Document : Doc ID 1990193.1 to find the solution.
See lessIs it Possible to Migrate Blanket PO’S in Closed Status Like Standard PO’S?
Hi, Where you need to migrate exactly ? and if their status's is closed why you need them ? Regards.
Hi,
Where you need to migrate exactly ? and if their status’s is closed why you need them ?
Regards.
See lessHow to remove duplicate rows by where condition ?
you can use : [code] SELECT * FROM test_table WHERE number_col NOT IN (SELECT number_col FROM test_table GROUP BY number_col HAVING count (*) > 1) [/code]
you can use :
[code]
See lessSELECT *
FROM test_table
WHERE number_col NOT IN (SELECT number_col
FROM test_table
GROUP BY number_col
HAVING count (*) > 1)
[/code]
How to to check old and new values for item in Oracle Form ?
to get the database value there is one property (database_value) and here is the example to achieve this: [code] BEGIN IF :BLOCK.ITEM = GET_ITEM_PROPERTY('BLOCK.ITEM', database_value) THEN RETURN; END IF; END; [/code] sometimes this property return value (0) if so you can use another way : -take theRead more
to get the database value there is one property (database_value) and here is the example to achieve this:
[code]
BEGIN
IF :BLOCK.ITEM = GET_ITEM_PROPERTY(‘BLOCK.ITEM’, database_value) THEN
RETURN;
END IF;
END;
[/code]
sometimes this property return value (0) if so you can use another way :
-take the value in the pre text item trigger and keep it in global
– as about this value in when validate item trigger and so on
hope this may help you 🙂
See lessHow to return N of rows after ordering in oracle sql ?
You can use a subquery for this like [code] select * from ( select * from emp order by sal desc ) where ROWNUM <= 5; [/code] Starting from Oracle 12c R1 (12.1). there is a syntax available to limit rows or start at offsets (full syntax here) example : [code] SELECT * FROM employees ORDER BY salarRead more
You can use a subquery for this like
[code]
select *
from
( select *
from emp
order by sal desc )
where ROWNUM <= 5;
[/code]
Starting from Oracle 12c R1 (12.1). there is a syntax available to limit rows or start at offsets (full syntax here)
example :
[code]
SELECT *
FROM employees
ORDER BY salary
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;
[/code]
hope this helpful 🙂
See lessHow dbms_assert protects against SQL injection ?
The dbms_assert package is used in databases that don't employ bind variables to help prevent SQL injection attacks, by "sanitizing" the SQL. it has several procedures inside ex : simple_sql_name: Validates the syntax of the SQL to ensure that the SQL statement only contains valid characters and proRead more
The dbms_assert package is used in databases that don’t employ bind variables to help prevent SQL injection attacks, by “sanitizing” the SQL.
it has several procedures inside ex :
and this a simple example of using (dbms_assert.simple_sql_name)
[code]CREATE OR REPLACE PROCEDURE oraask_test (tbl_name VARCHAR2, col_name VARCHAR2)
IS
qry VARCHAR2 (500);
BEGIN
qry := ‘ALTER TABLE ‘ || dbms_assert.simple_sql_name ( :tbl_name) || ‘ ADD ‘ || :col_name || char (1);
EXECUTE IMMEDIATE qry USING col_name;
See lessEND oraask_test;[/code]