This content has been marked as final. Show 4 replies
There is a stored proc "validate_invoice" which creates this hold in EBS. The condition that decides whether to go for receipt validation or not depends on the value in the EBS table, basically depend on the configuration of PO. Below query gives that information.
FROM PO_LINE_LOCATIONS A
WHERE A.PO_HEADER_ID = 110568
the value of PO_HEADER_ID can be found from PO_HEADERS_ALL or PO_HEADERS table. In case of PO_HEADERS, you need to set policy context
EXEC MO_GLOBAL.SET_POLICY_CONTEXT('S', 1733);
Ideally if you do not want this hold to be placed or validated, you should use the PO for which match_option is NOT 'R'