Supply Chain Management - PSFT (MOSC)

MOSC Banner

AE NF_BRL_PNL_WRK.NF_CANCEL_PBL_PB.SavePostChange

edited Sep 17, 2019 5:00AM in Supply Chain Management - PSFT (MOSC) 2 commentsAnswered

Hi.

Today we had an SQL error and looking for a solution we found in statement 31 the following code:

/* Insert RECVPUSH Run Control Line */            SQLExec("INSERT INTO PS_RECV_RUN_CNTL (OPRID, RUN_CNTL_ID, AUTOGEN_LBL, BUSINESS_UNIT, CLOSE_DELAY_DAYS, FILE_DIRECTORY, FILE_NAME, LABEL_FORMAT_ID, LANGUAGE_CD, NUMBER_OF_LABELS, RECEIVER_ID, RECV_LN_NBR, RECV_OPT_FLG, DATETIME_MODIFIED, PRINT_LABEL_OPTION, USG_LBL_FORMAT_ID, NBR_COPIES, USG_LBL_OVER_FILE, USG_LBL_FILE_DIR, USG_LBL_FILE_NAME, USG_RECEIVER_ID) VALUES ( :1, :2, 'Y', , 0, ' ', ' ', ' ', ' ', 1, :4, 0, 2, %CurrentDateTimeIn, ' ', ' ', 1, 'N', ' ', ' ', ' ')", &OPRID, &RunCntrlId, NF_HDR_BRL.BUSINESS_UNIT_RECV, NF_HDR_BRL.RECEIVER_ID);
Tagged:

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