send feedback

❮ Previous Next ❯

Blend Volume Transactions interface for JD Edwards

About the Blend Volume Transactions interface

The Blend Volume Transactions interface allows Advanced Inventory to perform three operations, BIP (Barrel in Place), TIP (Tank in Place) and ADJINV (Adjust Tank Inventory Volume) in JDEdwards Blend Management.

This functionality exists in P31B87, Create/Edit Operations. This allows ADD and Modify the Operations. It also allows Add/Empty/Delete and Update Barrels (Calling another function internally to perform this functionality).

This interface was written in NER and calls a “C” business function BD3N3B06 and BD3N3B04 to retrieve the processing options.

Name	Function name	Description
DD3N3B06		PO Retrieval: Blend Operation Header
BD3N3B06	PORetrievalBlendOperation Header	PO Retrieval: Blend Operation Header
DD3N3B04		PO Retrieval: Blend Edit Operation
BD3N3B04	PORetrievalBlendEditOperation	PO Retrieval: Blend Edit Operation
DD3N3B6C		dsi Interface: Blend Volume transaction
ND3N3B6C	dsiBlendVolume	dsi Interface: Blend Volume transaction

The full name of this interface is ND3N3B6C Blend Volume Transactions

This interface guide applies to the following JDE versions.

EnterpriseOne 9.1

Corresponding EnterpriseOne application

In EnterpriseOne, from menu G31B03, Operation Search P31B94, select ‘Add Blend Operation' or ‘Find'. Select a record and select ‘Edit Operation' to go to P31B69, Operation Header Parent Power form, which is discussed in another IUG. From the Operation Header, select ‘Continue' to go to P31B87, Operation Detail.

The P31B87 may return one of a variety of displays, depending on the base operation code, and whether the Operation Header has been saved, closed, and selected after the save. The typical display, seen for instance when a BIP operation is created or viewed, will include a From Vessel section with an In Place section, and tabs for Resources, Equipment, and Consumables.

In addition, below the tab selection section, Save, Cancel, and other buttons display. Of these, at least two are NOT a part of this Blend Volume IUG: Instruct Lot Attributes and Validate Spec.

Processing options

The processing options for P31B94, Operation Search, include three tabs: Default, Display, and Versions.

Default options and Display processing options will typically be left blank. Version options will include the program versions that are called: 9 Operation Header Parent Form (P31B69), and 10 Create/Edit Operation Detail (P31B87). Version entries are of special significance in establishing the workings of the related business functions.

In this interface, the processing option does not have much role in processing the transaction.

General tab

Run Calculate Work Order Status R31B19 (cAutoBatchProcess): This field specifies whether or not to run the batch process.
Simple Vessel Entry (cAfterTheFactValue): This field specifies whether or not to allow Simple Vessel.
Run Generate Barrel Style Definition R31B34 (cRunR31B34): This field specifies whether or not to run the batch process.

Display tab

Operation Header Display (cOperationHeaderValue: This field specifies whether to show or collapse the operation header.
Subform Region 2 Display (cRegion2Display): This field specifies whether to show or collapse Subform within region 2.
Subform Region 3 Display (cRegion3Display): This field specifies whether to show or collapse Subform within region 3.

Versions tab

Calculate Work Order Status R31B19 (szWOStatusVersion): This field, if left blank, will default with a value of “XJDE0001”.
Bill of Landing P31B91 (szP31B91Version): This field, if left blank, will default with a value of“ZJDE0001”.
Bottling Vessel P31B26 (szP31B26Version): This field, if left blank, will default with the value “ZJDE0001”
Generate Barrel Style Definition R31B34 (szR31B34Version): This field, if left blank, will default with the value “XJDE0001”.
Inventory by Vessel View P31B81 (szP31B81Version): This field, if left blank, will with the value “ZJDE0001”.
Tank master P31B08 (szP31B08Version): This field, if left blank, will with the value “ZJDE0001”.
Weigh Tag Detail P31B77 (szP31B77Version): This field, if left blank, will with the value “ZJDE0001”.

Processing option data structure DD3N3B06

The interface retrieves these parameters by calling BD3N3B06. They are passed back in the following data structure.

Type	Description	Parameter
String	szPOVerison_VERS	Input
String	szDefaultWorkFlowStatus_WSD2	Output
Character	cRunCalculateWOStatus_EV01	Output
Character	cReScheduleOperationsFlag_Ev01	Output
String	szCreateEditOpDetail_VERS	Output
String	szCalculateWOStatus_VER1	Output

Processing option data structure: DD3N3B04

The interface retrieves these parameters by calling BD3N3B04. They are passed back in the following data structure.

Type	Description	Parameter
String	szPOVerison_VERS	Input
String	cRunCalculateWOStatus_EV01	Output
Character	cSimpleVesselEntry_EV01	Output
Character	cRunGenerateBarrelStyle_EV01	Output
Character	cOperationHeaderDisplay_EV01	Output
Character	cSubformRegion2Display_EV01	Output
Character	cSubformRegion3Display_EV01	Output
String	szCalculateWOStatusVers_VER1	Output
String	szBillOfLadingVersion_VERS	Output
String	szBottlingVesselVersion_VERS	Output
String	szGenBarrelStyleDefVers_VERS	Output
String	szInvByVesselViewVers_VERS	Output
String	szTankMasterVersion_VERS	Output
String	szWeightagDetailVers_VERS	Output

Processing

This interface can be used to add operations and revise the listed movement operations.

Revisions can be made to Operation Header, Operation Details, In Place, Resources, Equipment, and Consumables. A review of the individual input parameters below identifies specifically what fields may be added and/or revised. Refer to the Special Processing Interface Usage Guide for more information.

Action code	Advanced Inventory Action code	Description
	A	Add Operation.
	C	Edit Operation.
A		Add record in Resource, Equipment, and Consumables tab.

Verify the processing

Verify the processing by viewing the details of the Operation Header and related details.

To verify the processing, complete the following steps in JDE.

In EnterpriseOne, from the menu G31B03, select Operation Search P31B94 to view the Operation Header.
Select Continue to view the related details, including the From Vessel grid, (VBT) Movement Detail, Resources, Equipment, and Consumables.

Step Information

Input data structure

Input data structure for Blend Volume Transactions DD3N3B6C

Name	Default value	R/O	Alias	Notes
cdsiActionCode_EV01	0	X	EV01	dcLINK Action Codes value “0”, has the standard meaning.
cActionCode_ACTION			ACTION	Not used.
jdDateUpdated_UPMJ	(today)	X	UPMJ	Returned from GetAuditInfo if not passed in.
mnTimeUpdated_TDAY	(now)	X	TDAY
szUserId_USER	(current user id)	X	USER
szWorkStationId_JOBN	(current workstation id)	X	JOBN
mnJobNumber_JOBS		X	JOBS
szProgramId_PID	ND3N4312	X	PID	Generally leave this blank and let it default in.
szVersion_VERS	ZJDE0001	X	VERS	This is used by function to look up the appropriate set of processing options.
cSuppressErrMsg_EV01		O	EV01	Enter a “1” here to suppress error messages - not recommended. You should usually leave this field blank.
cErrorCode_ERRC		X	ERRC	Indicates an error condition. Set by program.
szErrorMessageKey_EKEY		X	EKEY	Holds EnterpriseOne error message number.
iDebugLevel_INT01		O	INT01	Leave blank except for debugging and testing purposes only. Higher numbers will show more debug dialog boxes. Leaving this blank or setting to “0” suppresses all debug dialog boxes. Do not leave a value greater than “0” in this field after initial setup and testing, as it will cause synchronous dialog boxes on the computer to pop up when the function is called.
szGuidUniqueID_GUID		O	GUID
szGuidApprover1_USR1		O	USR1
szGuidFullName1_FULLNAME1		O	FULLNAME1
szGuidApprover2_USR2		O	USR2
szGuidFullName2_FULLNAME2		O	FULLNAME2
mnGuidReasonCode1_REASON1		O	REASON1
szGuidCommentField_COMMENTS		O	COMMENTS
mnGuidReasonCode2_REASON2		O	REASON2
szGuidCommentField2_2COMMENTS		O	2COMMENTS
szGuidScriptID_FMNMVERS		O	FMNMVERS
szGuidTextMessage_TEXTMES		O	TEXTMES
szErrorMessageKey_DTAI		O	DTAI
mnOperationNumber_WOPN		C	WOPN	In case of ADD, this value would be generated by NER. In case of EDIT, user needs to provide this value.
nOperationID_WOPID		C	WOPID	In case of ADD, this value would be generated by NER. In case of EDIT, user needs to provide this value.
szConfigOperatShort_WCOPCD		R	WCOPCD	Required.
szWorkflowStatusName_WSD		R	WSD	Required.
szBlendMgmtReference_WRF		O	WRF
szWinery_MCU		R	MCU	Required.
szCreator_ALKY		R	CRCD	Required.
udInstructedStartDate_WSDT		O	WSDT
udInstructedEndDate_WEDT		O	WEDT
mnInstructedDuration_WDUR		O	WDUR
udActualStartDate_WASDT		O	WASDT
udWIMActualEndDate_WAEDT		O	WAEDT
mnWIMActualDuration_WADUR		O	WADUR
cTimeUOM_WUOMT		O	WUOMT
cInstructionMethod_INSTMET		O	ISTMET
cDistributionMethod_DISTMET		O	DISTMET
cPerformAfterMeasure_WPAD		O	WPAD
cPerformSurveyMeasure_WPSD		O	WPSD
cShowPlannedMeasures_WSBDV		O	WSBDV
szOperationCategoryCode2_WH2		O	WH2
szOperationCategoryCode3_WH3		O	WH3
szOperationCategoryCode4_WH4		O	WH4
szOperationCategoryCode5_WH5		O	WH5
szAltOperationNumber_WALOP		O	WALOP
szWorkOrderReferNum_WAWOR		O	WAWOR
szCompMatType_CMATYPE		O	CMATYPE
szVesselNumber_WVNUM		R	WVNUM	Required.
szVesselType_WSVT		O	WSVT
nVesselSequenceNo_WVSEQ		R	WVSEQ	Required.
szVesselLocation_WVLOCN		O	WVLOCN
cGaugeType_TDPT		O	TDPT
cFlagBledID_EV01		O	EV01
szBlendID_WBID		O	WBID
szWorkGroupCode_WGID		C	WGID	This is required for Resource TAB record.
mnStaffNumber_SFNB		C	SFNB	This is required for Resource TAB record.
mnActualTime_WACTIME		C	WACTIME	This is required for Resource TAB record.
cTimeUOfM_WUOMT		C	WUOMT	This is required for Resource TAB record.
szEquipmentNumber_EQPNUM		C	EQPNUM	This is required for Equipment TAB record.
szWineryEqp_MCU		C	MCU	This is required for Equipment TAB record.
mnActualTimeEqp_WACTIME		C	WACTIME	This is required for Equipment TAB record.
szTimeUnitOfMeasure_WTUOM		C	WTUOM	This is required for Equipment TAB record.
szEquipParameterText_EQPPT		C	EQPPT	This is required for Equipment TAB record.
szItemNoUnknownFormat_UITM		C	UITM	This is required for Consumables TAB record.
szWineryConsum_MCU		C	MCU	This is required for Consumables TAB record.
szLocation_LOCN		C	LOCN	This is required for Consumables TAB record.
szLot_LOTN		O	LOTN	This is required for Consumables TAB record.
mnEquipConsQuantity_ECQTY		C	ECQTY	This is required for Consumables TAB record.
szUnitOfMeasurePrimary_UOM1		C	UOM1	This is required for Consumables TAB record.
mnIdentifierShortItem_ITM		C	ITM	This is required for Consumables TAB record.
mnInstructedAfterQty_WIAV		O	WIAV
mnInstructedMoveQty_WIMV		O	WIMV
mnInstructedAlterQty_WIAD		O	WIAD
cAddOrDeleteBarrel_EV01		C	EV01	A = Add barrel U = Update Location and Rack Number E = Empty barrel D = Delete barrel
mnBarrelNumber_BRLNUM		C	BRLNUM	If AddOrDeleteBarrel_EV01 has value, then the BarrelNumber has to be passed. For required validations, see the Assumptions section.
szBarrelID_BARID		O	BARID
szBarrelLocation_LOCN		C	LOCN	If AddOrDeleteBarrel has value “U”, then this parameter might have value in it.
szRackNumber_RKNMR		C	RKNMR	If AddOrDeleteBarrel has value “U”, then this parameter might have value in it.
cFCB4ActualVolumeUsed_WAF		C	WAF	This is required if user wants to change Before Actual Volume.
mnFCB4ActualVolume_WACTVLMV		C	FCSTR	If FCB4ActualVolumeUsed has value, then this parameter should have value.
cFCAftActVolumeUsed_WAF		C	WAF	This is required if user wants to change After Actual Volume.
mnFCAftActualVolume_WACTVLMV		C	POE	If FCAftActVolumeUsed has value, then this parameter should have value.
mnV2VLineNumber_LNID		C	LNID	This is required if the user wants to delete consumables record.
Globally Unique Identifier (GUID) Fields	GUID values are all optional unless a business must comply with FDA 21 CFR Part 11 auditing requirements. Refer to Special Processing Interface Usage Guide for GUID Input Data Structure details.

O = Optional

R = Required

X = Required, but will default in if not passed

C = Conditional

M = Multi-level

Action code	Advanced Inventory Action code	Description
	A	Add Operation.
	C	Edit Operation.
A		Add record in Resource, Equipment, and Consumables tab.

Required fields

dcLINKActionCode = 'A': Create new BIP record.

This parameter is required to create a new operation for Barrel in Place. Following is a list of required fields.

BF cdsiActionCode
BF szConfigOperatShort_WCOPCD
BF szWorkflowStatusName_WSD
BF szWinery_MCU
BF szCreator_ALKY
BF cPerformAfterMeasure_WPAD
BF cPerformSurveyMeasure_WPSD
BF szVesselNumber_WVNUM
BF nVesselSequenceNo_WVSEQ

dcLINKActionCode = ‘C': Edit existing BIP record.

This parameter is required to edit existing operations for Barrel in Place, which will change From After Actual Volume within In Place Tab. Following is a list of required fields.

BF cdsiActionCode
BF mnOperationNumber_WOPN
BF nOperationID_WOPID
BF szConfigOperatShort_WCOPCD
BF szWorkflowStatusName_WSD
BF szWinery_MCU
BF szCreator_ALKY
BF cPerformAfterMeasure_WPAD
BF cPerformSurveyMeasure_WPSD
BF szVesselNumber_WVNUM
BF nVesselSequenceNo_WVSEQ
BF cFCAftActVolumeUsed_WAF
BF mnFCAftActualVolume_WACTVLMV

dcLINKActionCode = ‘C': Add Barrel to existing BIP record.

This parameter is required to add barrel to existing BIP operation. The user would then be able to Add/Empty and Delete the barrel from VBT. Following is a list of required fields.

BF cdsiActionCode
BF mnOperationNumber_WOPN
BF nOperationID_WOPID
BF szConfigOperatShort_WCOPCD
BF szWorkflowStatusName_WSD
BF szWinery_MCU
BF szCreator_ALKY
BF cPerformAfterMeasure_WPAD
BF cPerformSurveyMeasure_WPSD
BF szVesselNumber_WVNUM
BF nVesselSequenceNo_WVSEQ
BF cAddOrDeleteBarrel_EV01
BF mnBarrelNumber_BRLNUM

dcLINKActionCode = ‘C': Add Barrel to existing VBTMT or TRANSMTVBT record.

This parameter is required to add barrel to existing VBTMT and TRANSMTVBT operation. The user would be able to Add the barrel from VBT. Following is a list of required fields.

BF cdsiActionCode
BF mnOperationNumber_WOPN
BF nOperationID_WOPID
BF szConfigOperatShort_WCOPCD
BF szWorkflowStatusName_WSD
BF szWinery_MCU
BF szCreator_ALKY
BF cPerformAfterMeasure_WPAD
BF cPerformSurveyMeasure_WPSD
BF szVesselNumber_WVNUM
BF cAddOrDeleteBarrel_EV01
BF mnBarrelNumber_BRLNUM - For further information, see the assumptions section.

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	Create a new BIP operation order	Edit existing BIP operation	Add barrel to existing BIP order
BF cdsiActionCode	A	C	C
BF mnOperationNumber_WOPN		1608	2229
BF nOperationID_WOPID		989	1687
BF szConfigOperatShort_WCOPCD	BIP	BIP	BIP
BF szWorkflowStatusName_WSD	ACTIVE	ACTIVE	ACTIVE
BF szWinery_MCU	W10	W10	W10
BF szCreator_ALKY	2207072	2207072	2207072
BF cPerformAfterMeasure_WPAD	1
BF cPerformSurveyMeasure_WPSD	1
BF szVesselNumber_WVNUM	VBT 14 00000566	VBT 14 00000193	VBT 14 00001333
BF nVesselSequenceNo_WVSEQ	1	2	2
BF cFCAftActVolumeUsed_WAF		1
BF mnFCAftActualVolume_WACTVLMV		240
BF cAddOrDeleteBarrel_EV01			A
BF mnBarrelNumber_BRLNUM			1579

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
0002	Record Invalid. This error is returned when an error has been detected from one of these three business functions: dcLINK Set User ID, dcLINK Utility Set Audit Info, or dcLINK Utility Write Signature Capture Record.
295WIM	Purchase Order Number/Type/Line Number Invalid. This is set when the sub header function returned reservation error.
778WIM	Significant Change has Occurred. In this interface, this will be set if the calculate Significant Volume Change function has any errors.
630WIM	Cannot Enter Actuals on Vessel. This is set if the Before Lot no longer exists.
001H	No Grid Record Selected This is set when the user tries to delete a barrel from VBT, but the barrel is not yet empty, or the barrel does not exist against this VBT.

References

The following table provides a list of the objects related to D3N used to support this NER.

Object Name	Description
BD3N0009	dcLINK Utility – Turn Debug On and Off
DD3N0009	dcLINK Utility – Turn Debug On and Off
BD3NSETU	dcLINK Set User ID
DD3NSETUSR	dcLINK Set User ID
BD3NSETA	dcLINK Utility Set Audit Info
DD3NSETA	dcLINK Utility Set Audit Info
BD3N3B06	PO Retrieval – Blend Operation Header
BD3N3B04	PO Retrieval – Blend Edit Operation
ND3N3B6D	dsi Interface Add Barrel To VBT
SD3N3B87	dsi Blend Sub-Function Operation Header

Assumptions

The following information should be assumed when implementing the Blend Volume Transactions interface.

Validation is required before calling the interface for Blend operations when adding a barrel to the VBT detail.

The mnBarrelNumber_BRLNUM parameter value needs to be found in Barrel Master with the correct volume status before submitting the interface call for the selected configured operation.

Example: TRANSMTVBT or VBTMT configured operations requires the volume to be set as EMPTY status on the barrel master (F31B03).

The following list provides possibilities that can occur if the barrel master is not valid.

The Barrel master is found, but the volume status is set to FULL.

The barrel master record volume status will change to a setting of EMPTY when the barrel is added to the blend operation.

Barrel number Duplication.

If the barrel number is submitted more than once, the app needs to check to see if the barrel has been inserted in the F31B101 VBT detail table for this VBT vessel number.

The Barrel number is invalid in the Barrel Master.

The interface call will create an invalid barrel record in the F31B101 VBT Detail table.

There was a problem loading this topic

Mobile Enterprise Platform