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.
Hello i am facing this error when run concurrent program Import Price Catalogs after populating PO interface tables PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, PO_DISTRIBUTIONS_INTERFACE i don't know how to solve this error. any advice will be appreciated.
hello guys, when i am attempting to use this API ar_invoice_api_pub.create_single_invoice i faced this error : 16919937-: Accounting periods must be defined for the GL Date. = 01-SEP-18 note: the GL accounting period (SEP-18) is opened thanks in advance.
[code] create table test_date (creation_date date); [/code] [code] Insert into test_date (CREATION_DATE) Values (TO_DATE('07/14/2017 14:45:10', 'MM/DD/YYYY HH24:MI:SS')); COMMIT; [/code] --My code [code] select * from test_date where TO_CHAR(creation_date,'DD-MON-YY') = NVL(TO_CHAR (TO_DATE (:pv_date, 'YYYY-MM-DD HH24:MI:SS'), 'DD-MON-YY'), TO_CHAR(creation_date,'DD-MON-YY')); [/code] I am comparing dates in my code using the fnd_standard_date valueset. But it is not fetching data. I am passing pv_date ...
Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" i face this error when trying to execute this update statement please can anyone tell me error cause and solution UPDATE employees set last_name = 'test' JOIN dept ...
i face this error when trying to compile this pl/sql block Error: PLS-00103: Encountered the symbol "THEN" when expecting one of the following: := . ( % ; declare CURSOR abc IS select * from all_Objects; begin for rec in abc loop ...
