Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle AllOther Interview Questions
Questions Answers Views Company eMail

what is difference between inner join & nested query or subqueries

2011

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 2630

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1397

can we drop dual table

Metric Stream,

7 11657

default triggers available for reports

1289

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1299

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1304

hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.

1 1817

CREATE OR REPLACE procedure XXPROC_OPENINT(errbuf OUT VARCHAR2, retcode OUT VARCHAR2) AS --Cursor Declaration cursor inv_cur IS SELECT INVI.INVOICE_ID ,INVI.INVOICE_TYPE_LOOKUP_CODE ,INVI.INVOICE_DATE ,INVI.VENDOR_ID ,INVI.VENDOR_SITE_ID ,INVI.INVOICE_AMOUNT ,INVI.INVOICE_CURRENCY_CODE ,INVI.STATUS ,INVI.GROUP_ID ,INVI.SOURCE ,INVI.ORG_ID ,INVI.DESCRIPTION ,INVI.CREATION_DATE ,INVI.CREATED_BY ,INVL.INVOICE_ID ,INVL.LINE_NUMBER ,INVL.LINE_TYPE_LOOKUP_CODE ,INVL.DESCRIPTION ,INVL.ORG_ID ,INVL.INVENTORY_ITEM_ID ,INVL.ACCOUNTING_DATE ,INVL.AMOUNT ,INVL.CREATION_DATE ,INVL.CREATED_BY ,INVL.PO_HEADER_ID ,INVL.PO_LINE_LOCATION_ID ,INVL.ITEM_DESCRIPTION FROM XXAP_INVOICES_INTERFACE_STG INVI ,AP_INVOICE_LINES_INTERFACE_STG INVL WHERE INVI.INVOICE_ID=INVL.INVOICE_ID AND INVI.ORG_ID=INVL.ORG_ID; l_currency_code varchar2(25); l_flag varchar2(2); l_error_msg varchar2(100); l_err_msg varchar2(100); l_err_flag varchar2(10); l_count number(9) default 0; BEGIN for rec_cur in inv_cur loop l_count:=l_count+1; --Currency Code Validation BEGIN SELECT currency_code INTO l_currency_code FROM FND_CURRENCIES WHERE currency_code ='USD'; EXCEPTION WHEN others THEN l_flag:='E'; l_error_msg:='Currency Code Does not Exists'; fnd_file.put_line(fnd_file.log,'Inserting Data Into The Interface Table'||'-'||l_count||' '||l_error_msg); END; IF l_flag!='E' THEN fnd_file.put_line(fnd_file.log,'Inserting Data Into The Interface Table'); INSERT INTO AP_INVOICES_INTERFACE( INVOICE_ID ,INVOICE_TYPE_LOOKUP_CODE ,INVOICE_DATE ,VENDOR_ID ,VENDOR_SITE_ID ,INVOICE_AMOUNT ,INVOICE_CURRENCY_CODE ,STATUS ,GROUP_ID ,SOURCE ,ORG_ID ,DESCRIPTION ,CREATION_DATE ,CREATED_BY) VALUES (rec_cur.INVOICE_ID ,rec_cur.INVOICE_TYPE_LOOKUP_CODE ,rec_cur.INVOICE_DATE ,rec_cur.VENDOR_ID ,rec_cur.VENDOR_SITE_ID ,rec_cur.INVOICE_AMOUNT ,rec_cur.INVOICE_CURRENCY_CODE ,rec_cur.STATUS ,rec_cur.GROUP_ID ,rec_cur.SOURCE ,rec_cur.ORG_ID ,rec_cur.DESCRIPTION ,rec_cur.CREATION_DATE ,rec_cur.CREATED_BY); INSERT INTO ap_invoice_lines_interface ( INVOICE_ID ,LINE_NUMBER ,LINE_TYPE_LOOKUP_CODE ,DESCRIPTION ,ORG_ID ,INVENTORY_ITEM_ID ,ACCOUNTING_DATE ,AMOUNT ,CREATION_DATE ,CREATED_BY ,PO_HEADER_ID ,PO_LINE_LOCATION_ID,ITEM_DESCRIPTION) VALUES (rec_cur.INVOICE_ID ,rec_cur.LINE_NUMBER ,rec_cur.LINE_TYPE_LOOKUP_CODE ,rec_cur.DESCRIPTION ,rec_cur.ORG_ID ,rec_cur.INVENTORY_ITEM_ID ,rec_cur.ACCOUNTING_DATE ,rec_cur.AMOUNT ,rec_cur.CREATION_DATE ,rec_cur.CREATED_BY ,rec_cur.PO_HEADER_ID ,rec_cur.PO_LINE_LOCATION_ID ,rec_cur.ITEM_DESCRIPTION); END IF; l_flag:=NULL; l_err_MSG:=NULL; END LOOP; COMMIT; END XXPROC_OPENINT; / PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

1930

A scenario for amount correction & how to use amount correction functionality in AP invoices

1172

Is it possible to drop a column in a table which contains only one column? How?

1 1766

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

Oracle,

1 1616

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

Alshaya,

1 1735

How to find locks exists in a table or not?

HCL,

1 1653

how to write customizations in po

Ernst Young,

710


Post New Oracle AllOther Questions






Un-Answered Questions { Oracle AllOther }

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1076


How do you create a credit note against an invoice? : oracle accounts receivable

171


What is the difference between recovery and restoring of the oracle database?

178


What is auto invoicing? Explain : oracle accounts receivable

180


as a technical developer in oracle applications which type errors feced in your experience sofar

1329






What is chargeback invoice? How do we create it? : oracle accounts receivable

177


What is supporting issues GL AP and AR?

1519


what are the tools used for oracle 10g in real time.

1447


How would you determine what sessions are connected and what resources they are waiting for?

1169


How to clone the database using RMAN back

1160


What Are Cross Validation & Adi?

190


What do you mean by Oracle MEDIA RECOVERY?

216


can u give guidance abt packages of plsql

1157


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

167


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

1265