Create Incomplete PO From ASCP Release Work Bench

Create Incomplete PO From ASCP Release Work Bench 


There is no Standard Function available in ASCP to Release the as Incomplete from ASCP

But a Simple Trigger Can Fix This Requirement

For ASCP:  Add a trigger on table msc_purchase_requisitions_interface (on destination), to change the status before insert on MSC_PO_REQUISITIONS_INTERFACE for each row

begin
if :NEW.AUTHORIZATION_STATUS = 'APPROVED' then
:NEW.AUTHORIZATION_STATUS:='INCOMPLETE';
end if;
end;

Hope the Information is Helpful