Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Governance, Risk & Compliance (GRC) Archived Forums
GRC General Discussion
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 2, 2010 4:29 AM by
Form Rules SQL PCG
Nov 2, 2010 4:29 AM
I have a client scenario in which we need to check the Header amount of a blanket PO to be compared with
If line amounts exceed header amount then an error must be thrown.
I am trying to create a form rule SQL. for that i started with a small code just to check if we can loop in the lines block and retrieve the values of unit price.
I am facing an issue when i go and check the results in PO form
below is the sql code its on when-validate-record in form rule element
l_last_rec boolean ;
l_curr_rec := name_in('SYSTEM.CURSOR_RECORD');
l_item_price := name_in('PO_LINES.UNIT_PRICE');
if name_in('SYSTEM.LAST_RECORD')= 'TRUE' then
The error says "Illegal Restricted COPY Procedure in WHEN-VALIDATE-RECORD"
any suggestion would be of help
This content has been marked as final.
Show 0 replies