Method1: |
While creating table
value set write your SQL statement directly in the place of table name but
don’t miss to use distinct and alias name for SQL statement as shown below
Method2: |
Build Query with rowid
to avoid the duplicate values
Syntax:
SELECT COLUMN_NAME
FROM TABLE_NAME T1
WHERE ROWID = (SELECT MAX (ROWID)
FROM TABLE_NAME T2
WHERE T1.ID = R2.ID)
Method3: |
Create view to get
distinct values and use the same view while you are creating table value set.
Example:
Create view EMP_V as select distinct deptno from emp;
Method4: |
While creating value
set ,check the check box “Allow Parent Values” as shown below screenshot.
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDeleteThanks for sharing this great information on Oracle ADF. Actually I was looking for the same information on internet for Oracle ADF Interview Questions and Answers and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Fusion financial by attending Oracle ADF Training.
ReplyDelete