Lot Status Update F4108 interface for JD Edwards

About the Lot Status Update for F4108

This function is used to update the Lot Master file.

This NER has two functions that perform similar but different functions. Both functions update a lot status code. One updates the lot status in the Item Location file (F41021), and the other updates the lot status code in the Lot Master file (F4108). This usage guide covers the updating of the Lot Master file. The dcLINK NER that is called is ND3N4108. This interface was written in NER and calls ‘C' business function, BD3N4109, to retrieve the processing options.

Name	Function name	Description
DD3N4108C		dcLINK Interface Lot Status Update
ND3N4108	dcLINKLotStatusUpdateF4108	dcLINK Interface Lot Status Update
DD3N4109		PO Retrieval Lot Master Revisions
BD3N4109	PORetrievalLotMasterRevisions	PO Retrieval Lot Master Revisions

The full name of this interface is ND3N4108 Lot Status Update F4108

This interface guide applies to the following JDE versions.

EnterpriseOne Xe through 9.1

Corresponding EnterpriseOne Application

In EnterpriseOne, the application you would run to change the lot status is P4108, lot master revisions. P4108 can be accessed from the menu G4113.

Processing options

Processing options for Lot Status Update F4108.

The dream writer version will default to ZJDE0001 if not otherwise specified in the parameter list on the call. This interface calls BD3N4109 to get the lot master processing options, but at this time none of the retrieved processing options are used in this business function. Only one of the processing options is used by this NER.

Update lot status – this processing option is a flag that is either on (1) or off (0 or blank). If it is set to a one, then no one is allowed to update the lot status. This NER checks this processing option, and if it is set to a ‘1', no updating is performed.

Processing option data structure for DD3N4109

Our interface retrieves these parameters by calling BD3N4109, and is passed back in the following data structure.

Type	Description	Parameter
String	szPOVersion_VERS	Input
Char	cPO_DisableLotStatUpdate_EV02	Output
Char	cPO_DisableLotGradeUpdate_EV03	Output
Char	cPO_DisableLotPotnUpdate_EV04	Output
String	szPO_GradeDocType_DCTO	Output
String	szPO_PotencyDocType_DCT	Output
Char	cDisplayPercentofLife_DSPLY	Output
Char	cDisplayNumberofDays_DSPLY	Output
Date	jdCalculationDate_CLCJ	Output
Char	cMassUpdateOfLotDates_EV01	Output

Processing

This interface processes changes the lot status code in the Lot Master file F4108.

The purpose of this interface is to change the lot status code in the Lot Master file (F4108). This interface does nothing with the Item Location File that is left up to this interface's companion interface, dcLINKLotStatusUpdate.

Required fields

The branch/plant, item number and lot number are required fields.

This NER will use item number, branch/plant, and lot number to read the lot master for the current lot status. The current status is compared to the new update status to determine if a lot is being approved or placed on hold.

Verify the processing

Use the lot master revision program in EnterpriseOne (P4108) to inquire on the lot number.

Input data structure

Input data structure for DD3N4108C.

Name	Default value	R/O	Alias	Notes
cdcLINKActionCode_EV01	0	X	EV01	Always defaults to a 0. No different action takes place based on this code.
cActionCode_ACTION	0	X	ACTION
jdDateUpdated_UPMJ	Current Date	X	UPMJ	Retrieved from GetAuditInfo.
mnTimeUpdated_UPMT	Current Time	X	UPMT	Retrieved from GetAuditInfo.
szUserId_USER	Current User	X	USER	Retrieved from GetAuditInfo.
szWorkStationId_JOBN	Current Workstation	X	JOBN	Retrieved from GetAuditInfo.
mnJobNumber_JOBS		O	JOBS
szProgramId_PID	ND3N4108	X	PID	Defaulted in program if not passed in.
szVersion_VERS	ZJDE0001	X	VERS	Defaulted in program if not passed in.
cSuppressErrorMessage_EV01		O	EV01
cErrorCode_ERRC	Blanks	X	ERRC	Defaulted in program.
szErrorMessageKey_EKEY	Blanks	X	EKEY	Defaulted in program.
iDebugLevel_INT01		O	INT01	Displays M&D Debug statements if the value is greater than 0.
szBranchPlant_MCU		R	MCU	The branch/plant is part of the key in reading and updating the Lot Master file.
szItemNoUnknownFormat_UITM		R	UITM	This NER needs the short item number to read several files. It derives the short item number from the unknown item number passed in this field.
szLocation_LOCN		O	LOCN	The location is not used in this NER.
szLot_LOTN		R	LOTN	The lot number must be entered in order to read or update the Lot Master file.
cNewLotStatusCode_LOTS		R	LOTS	This is the new status that the lot will be updated too.
szStatusChangeReason_STRCD		O	STRCD	This reason code is passed into the business function that will create the Cardex entry.
cOmitZeroQuantities_OMIT0		O	OMIT0	This field is not used by this business function.
szGuidUniqueID_GUID	Automatically generated by dcLINK	O	CFRGUID	If generate GUIDs is turned on in the dcLINK configuration utility, this field will contain a GUID (guaranteed unique identifier). The GUID is used to tie database changes in PeopleSoft to the transactions that triggered those changes to occur.
szGuidApprover1_USR1		O, R	USR1	An entry in this field, or the Approver 2 field, will cause a signature capture record to be written. Signature capture records are part of the GUID processing and should not be used unless a GUID is being created by dcLINK. The value of this field is a User ID, not an address book entry. There must be a value passed in to either this field, or the approver 2 field, otherwise it is an error.
szGuidFullName1_FULLNAME1		O	FULLNAME1	This field is the full name of the GUID Approver 1.
szGuidApprover2_USR2		O, R	USR2	GUID processing supports up to two approvers. If two approvers are required, this is the user ID of the second approver. There must be a value passed in to either this field, or the approver 1 field, otherwise it is an error.
szGuidFullName2_FULLNAME2		O	FULLNAME2	This field is the full name of the GUID Approver 2.
mnGuidReasonCode1_REASON1		O, R	REASON1	If either of the approver fields contains a value, but no value is entered into one of the reason code fields, then an error will be returned. Reason codes must match the valid reason codes setup for GUID processing, otherwise it is an error.
szGuidCommentField_COMMENTS		O	COMMENTS	This is a free form entry field that is used to further explain the reason code entered into the previous field.
mnGuidReasonCode2_REASON2		O, R	REASON2	If either of the approver fields contains a value, but no value is entered into one of the reason code fields, then an error will be returned. Reason codes must match the valid reason codes setup for GUID processing, otherwise it is an error.
szGuidCommentField2_2COMMENTS		O	2COMMENTS	This is a free form entry field that is used to further explain the reason code entered in the previous field.
szGuidScriptID_FMNMVERS		O	FMNMVERS	In PeopleSoft the screen ID where the change was made is captured. dcLINK captures the script ID.
szGuidTextMessage_TEXTMES		O	TEXTMES	This is a free form entry field.

R = Required

X = Required but will default in if not passed

O = Optional

Transaction test scenarios

The following test scenarios demonstrate a variety of ways in which this interface could be used, and the fields that would be passed for each scenario.

The data structure fields are in the left column, and the corresponding values for each scenario are listed by column.

Field name	Placing a lot on hold	Removing a lot on hold
cdcLINKActionCode_EV01	0	0
cActionCode_ACTION
jdDateUpdated_UPMJ
mnTimeUpdated_UPMT
szUserId_USER
szWorkStationId_JOBN
mnJobNumber_JOBS
szProgramId_PID
szVersion_VERS
cSuppressErrorMessage_EV01
cErrorCode_ERRC
szErrorMessageKey_EKEY
iDebugLevel_INT01
szBranchPlant_MCU	27	27
szItemNoUnknownFormat_UITM	4100	4100
szLocation_LOCN
szLot_LOTN	20599	20599
cNewLotStatusCode_LOTS	D
szStatusChangeReason_STRCD
cOmitZeroQuantities_OMIT0
szGuidUniqueID_GUID
szGuidApprover1_USR1
szGuidFullName1_FULLNAME1
szGuidApprover2_USR2
szGuidFullName2_FULLNAME2
mnGuidReasonCode1_REASON1
szGuidCommentField_COMMENTS
mnGuidReasonCode2_REASON2
szGuidCommentField2_2COMMENTS
szGuidScriptID_FMNMVERS
szGuidTextMessage_TEXTMES

Common error messages

The following are common error messages that can be generated by this BF, and what those error messages mean.

Error message	Meaning
022N	Lot does not exist in the Lot Master. The F4108 was read and no record was found that matched this combination of lot number, branch/plant, and item number.
0267	Item Number Invalid. If no item number is passed to this business function, this error message will be returned.
0964	Branch/Plant Invalid. No branch/plant was passed into this business function.
4299	Invalid Processing Option. This is the message returned when this interface is called, but the processing option is set to not allow updating of the lot status.

There was a problem loading this topic

Mobile Enterprise Platform