Retail Merchandising System (MOSC)

MOSC Banner

Can anyone provide me working Harness of XOrder RIB Object.?

edited Mar 5, 2020 4:00AM in Retail Merchandising System (MOSC) 1 commentAnswered

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;

----------------------------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center