Answer Posted / rajiv

LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)

What is a flexfield? List out its types.

1112

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1023

---

please send me forms, xml pulisher questions,answers

2069

---

List the various types of value set.

1023

---

Do you know what are user profiles in apps. Any examples you can give?

1042

---

what is pay run id ?

2127

---

What is a value set? List its various types.

1038

---

Do you know what is applysys in oracle application database schema, what is apps?

1138

---

How can you achieve loose coupling in soa framework?

1177

---

How can we import the data into a database using sql * loader?

1125

---

Explain what are the tables of auto invoice?

1098

---

testing tools?

2179

---

Is soa a part of oracle fusion middleware?

1040

---

can we get profile values in report without using user exists is it possible how?

2828

---

Plz anybody send me Technical specification for AP Interface

2506

---