Answer Posted / sreekanth

To get the next value of a sequence, we use nextval.


NextVal is pseudo column, which gives you the AVAILABLE
number in the sequence.
Remember the nextval value also depends on the cache you
have given, while creating the sequence.
If you want current value of a sequence you can use CurVal.
In a session you cannot use current value without getting
next value.
In 11g the you can use the nextval without using the query.
ie
select seq_name.nextval into ln_seqnextval from dual;
can be replaced by
ln_seqnextval := seq_name.nextval;

What do you mean by hz_ in customer tables? : oracle accounts receivable

1138

---

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

2150

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4386

---

1. What is PO rate variance gain and loss?

2831

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1195

---

what are basic modules required to implement oracle application in any oraganisation?

2144

---

What is auto invoicing? : oracle accounts receivable

1081

---

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

1145

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2163

---

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

1134

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1963

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1060

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2048

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3480

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2011

---