Hi
I have column called "Request_number" in the IG. For this column I have set the default value from the pl/sql function.
From pl/sql function I'm returning a numeric which is concatenation of "Database sequence and specific prefix value " value back. When I create new row using (add row) the request number generates from the pl/sql function after saving the record when i create the another row the same request number is returned as per the previous row.
Only if I refresh the page then the new number is returned.
On analysis what i found is that at the time second row the call pl/sql function is not invoked.
Any pointers as to why it behaves this way and how I can overcome the issue.
Thanks in advance.
Bharat