Can anyone provide me working Harness of XOrder RIB Object.?
Hi,
When trying to modify a PO using RMSSUB_XORDER.CONSUME function. I am getting the error as :
Error ORA-01007: variable not in select list returned by program unit RMSSUB_XORDER_SQL.INSERT_SVC_ORDDETAIL. I am using the base "RIB_XOrderDesc_REC" and passing it to consume but still am getting the error. Please help in resolving the issue.
I am using the below code:
SET SERVEROUTPUT ON
DECLARE
I_po ordhead.order_no%type:= 35004;
I_supp ordhead.supplier%type:=204;
I_item ordsku.item%type := '100450113';
I_loc ordloc.location%type := 101;
I_qty ordloc.qty_ordered%type :=25;
----------------------------------------------------