Re: How to populate a field using table component??
In your Rule, check whether your query (2nd one) is returning correct result. To validate just append any character at the end of your SQL, so that it fails to execute and then go to server.log to get the SQL.
This SQL will have the resovled TOKEN values, run this SQL in any oracle tool and check whether it is working as expected.
Cheers.. Utkarsh Mishra
-- Remember to give Kudos to answers! (click the KUDOS star)