Skip to main content

Q35UpdateWorkOrderConditional

Cantara Business Function to update a Work Order and conditionally only updates specific fields. Fields to be updated are preceded in the input data structure with a flag which indicates if that field is to be updated. 

Oracle Doc:  Setting Processing Options for the Work Order Revisions Program (P17714) (oracle.com)

Explanation:  Enter a ‘1’ in the appropriate “EV01_UseProvided__” parameter to update that field on the work order.

Calls

This function calls the following Q35 functions:

Data Structure

Name

Type

Inclusion

Direction

Parameter Notes 

DOCO_mnOrderNumber

INTEGER

OPTIONAL

IN


VERS_szP17714Version

STRING

OPTIONAL

BOTH


EV01_cReserveObject

CHARACTER

OPTIONAL

IN


EV01_cSuppressErrors

CHARACTER

OPTIONAL

IN


DTAI_szErrorMessages

ERRORALIAS

OPTIONAL

OUT


EV01_cUseProvidedACDN

CHARACTER

OPTIONAL

BOTH


ACDN_mnActualDowntimeHours

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedAMLC

CHARACTER

OPTIONAL

BOTH


AMLC_mnEstimatedLaborAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedAMMC

CHARACTER

OPTIONAL

BOTH


AMMC_mnEstimatedMaterialAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedAMOT

CHARACTER

OPTIONAL

BOTH


AMOT_mnEstimatedOtherAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedAMTC

CHARACTER

OPTIONAL

BOTH


AMTC_mnChargeToOriginalAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedAN8

CHARACTER

OPTIONAL

BOTH


AN8_mnCustomerNumber

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedANO

CHARACTER

OPTIONAL

BOTH


ANO_mnOriginatorNumber

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedANP

CHARACTER

OPTIONAL

BOTH


ANP_mnAssignedToAddressNumber

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedANPA

CHARACTER

OPTIONAL

BOTH


ANPA_mnSupervisor

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedANSA

CHARACTER

OPTIONAL

BOTH


ANSA_mnManager

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedANT

CHARACTER

OPTIONAL

BOTH


ANT_mnInspectorNumber

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedAPRT

CHARACTER

OPTIONAL

BOTH


APRT_szApprovalType

STRING

OPTIONAL

BOTH


EV01_cUseProvidedAR1

CHARACTER

OPTIONAL

BOTH


AR1_szPhoneAreaCode1

STRING

OPTIONAL

BOTH


EV01_cUseProvidedCOVGR

CHARACTER

OPTIONAL

BOTH


COVGR_szCoverageGroup

STRING

OPTIONAL

BOTH


EV01_cUseProvidedCRCD

CHARACTER

OPTIONAL

BOTH


CRCD_szCurrencyCodeFrom

UDC

OPTIONAL

BOTH


EV01_cUseProvidedCRDC

CHARACTER

OPTIONAL

BOTH


CRDC_szCurrencyCodeTo

UDC

OPTIONAL

BOTH


EV01_cUseProvidedCRR

CHARACTER

OPTIONAL

BOTH


CRR_mnCurrencyConverRateOv

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedCRRM

CHARACTER

OPTIONAL

BOTH


CRRM_cCurrencyMode

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedCTR

CHARACTER

OPTIONAL

BOTH


CTR_szCountry

STRING

OPTIONAL

BOTH


EV01_cUseProvidedDCTO

CHARACTER

OPTIONAL

BOTH


DCTO_szOrderType

UDC

OPTIONAL

BOTH


EV01_cUseProvidedDL01

CHARACTER

OPTIONAL

BOTH


DL01_szWODescription

STRING

OPTIONAL

BOTH


EV01_cUseProvidedDOC

CHARACTER

OPTIONAL

BOTH


DOC_mnDocVoucherInvoiceE

INTEGER

OPTIONAL

BOTH


EV01_cUseProvidedDPL

CHARACTER

OPTIONAL

BOTH


DPL_jdPlannedCompletionDate

DATE

OPTIONAL

BOTH


EV01_cUseProvidedDRQJ

CHARACTER

OPTIONAL

BOTH


DRQJ_jdRequestedDate

DATE

OPTIONAL

BOTH


EV01_cUseProvidedDUAL

CHARACTER

OPTIONAL

BOTH


DUAL_cDualUnitOfMeasureItem

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedENTCK

CHARACTER

OPTIONAL

BOTH


ENTCK_szEntitlementCheck

STRING

OPTIONAL

BOTH


EV01_cUseProvidedESDN

CHARACTER

OPTIONAL

BOTH


ESDN_mnEstimatedDowntimeHours

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedEXR1

CHARACTER

OPTIONAL

BOTH


EXR1_szTaxExplanationCode1

STRING

OPTIONAL

BOTH


EV01_cUseProvidedGLCCV

CHARACTER

OPTIONAL

BOTH


GLCCV_szGLCategoryCovered

STRING

OPTIONAL

BOTH


EV01_cUseProvidedGLCNC

CHARACTER

OPTIONAL

BOTH


GLCNC_szGLCategoryNonCovered

STRING

OPTIONAL

BOTH


EV01_cUseProvidedHRSA

CHARACTER

OPTIONAL

BOTH


HRSA_mnHoursActual

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedHRSO

CHARACTER

OPTIONAL

BOTH


HRSO_mnEstimatedHours

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedISSUE

CHARACTER

OPTIONAL

BOTH


ISSUE_szISSUE

STRING

OPTIONAL

BOTH


EV01_cUseProvidedITM

CHARACTER

OPTIONAL

BOTH


ITM_mnShortItemNumber

SHORTITEM

OPTIONAL

BOTH


EV01_cUseProvidedLBAM

CHARACTER

OPTIONAL

BOTH


LBAM_mnActualLaborAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedLNGP

CHARACTER

OPTIONAL

BOTH


LNGP_szLanguagePreference

STRING

OPTIONAL

BOTH


EV01_cUseProvidedLOCN

CHARACTER

OPTIONAL

BOTH


LOCN_szLocation

LOCATION

OPTIONAL

BOTH


EV01_cUseProvidedLOTN

CHARACTER

OPTIONAL

BOTH


LOTN_szLotNumber

STRING

OPTIONAL

BOTH


EV01_cUseProvidedMCU

CHARACTER

OPTIONAL

BOTH


MCU_szBusinessUnit

BUSINESSUNIT

OPTIONAL

BOTH


EV01_cUseProvidedMCULT

CHARACTER

OPTIONAL

BOTH


MCULT_szWorkCenterLeadCraft

BUSINESSUNIT

OPTIONAL

BOTH


EV01_cUseProvidedMMCU

CHARACTER

OPTIONAL

BOTH


MMCU_szBranchPlant

BUSINESSUNIT

OPTIONAL

BOTH


EV01_cUseProvidedMTAM

CHARACTER

OPTIONAL

BOTH


MTAM_mnActualMaterialAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedMTHPR

CHARACTER

OPTIONAL

BOTH


MTHPR_cMethodofPricing

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedNAN8

CHARACTER

OPTIONAL

BOTH


NAN8_mnNextAddressNumber

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedNUMB

CHARACTER

OPTIONAL

BOTH


NUMB_mnAssetNumber

ASETNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedOTAM

CHARACTER

OPTIONAL

BOTH


OTAM_mnAmountActualOther

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedPARS

CHARACTER

OPTIONAL

BOTH


PARS_szParentOrderNumber

STRING

OPTIONAL

BOTH


EV01_cUseProvidedPC

CHARACTER

OPTIONAL

BOTH


PC_mnPercentComplete

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedPHN1

CHARACTER

OPTIONAL

BOTH


PHN1_szPhoneNumberOne

STRING

OPTIONAL

BOTH


EV01_cUseProvidedPRODF

CHARACTER

OPTIONAL

BOTH


PRODF_szProductFamily

STRING

OPTIONAL

BOTH


EV01_cUseProvidedPRODM

CHARACTER

OPTIONAL

BOTH


PRODM_szProductModel

STRING

OPTIONAL

BOTH


EV01_cUseProvidedPRTS

CHARACTER

OPTIONAL

BOTH


PRTS_cWOPriority

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedPTWO

CHARACTER

OPTIONAL

BOTH


PTWO_mnPegToWorkOrder

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedQTYT

CHARACTER

OPTIONAL

BOTH


QTYT_mnQuantityShippedToDate

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedREGION

CHARACTER

OPTIONAL

BOTH


REGION_szGeographicRegion

STRING

OPTIONAL

BOTH


EV01_cUseProvidedRSTM

CHARACTER

OPTIONAL

BOTH


RSTM_mnResponseTime

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedRYIN

CHARACTER

OPTIONAL

BOTH


RYIN_cPaymentInstrumentA

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedSAID

CHARACTER

OPTIONAL

BOTH


SAID_mnServiceAddressNumber

ADDRESSNUMBER

OPTIONAL

BOTH


EV01_cUseProvidedSBLI

CHARACTER

OPTIONAL

BOTH


SBLI_cSubledgerInactiveCode

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedSEET

CHARACTER

OPTIONAL

BOTH


SEET_mnRequestedFinishTime

INTEGER

OPTIONAL

BOTH


EV01_cUseProvidedSEQN

CHARACTER

OPTIONAL

BOTH


SEQN_mnSequenceNumber2

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedSEST

CHARACTER

OPTIONAL

BOTH


SEST_mnTimeScheduledStart

INTEGER

OPTIONAL

BOTH


EV01_cUseProvidedSHFT

CHARACTER

OPTIONAL

BOTH


SHFT_cShiftCode

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedSHNO

CHARACTER

OPTIONAL

BOTH


SHNO_szMessageNumber

STRING

OPTIONAL

BOTH


EV01_cUseProvidedSOBK

CHARACTER

OPTIONAL

BOTH


SOBK_mnUnitsQuanBackorHeld

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedSOCN

CHARACTER

OPTIONAL

BOTH


SOCN_mnUnitsQuantityCanceled

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedSOQS

CHARACTER

OPTIONAL

BOTH


SOQS_mnUnitsQuantityShipped

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedSPRT

CHARACTER

OPTIONAL

BOTH


SPRT_cFlashMessage

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedSQOR

CHARACTER

OPTIONAL

BOTH


SQOR_mnUnitsSecondaryQtyOr

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedSRST

CHARACTER

OPTIONAL

BOTH


SRST_szWOStatus

STRING

OPTIONAL

BOTH


EV01_cUseProvidedSRYN

CHARACTER

OPTIONAL

BOTH


SRYN_cEligibleSupplierRecovery

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedSSOQ

CHARACTER

OPTIONAL

BOTH


SSOQ_mnSecondaryQtyCompleted

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedSTCM

CHARACTER

OPTIONAL

BOTH


STCM_szStatusComment

STRING

OPTIONAL

BOTH


EV01_cUseProvidedSTRT

CHARACTER

OPTIONAL

BOTH


STRT_jdStartDate

DATE

OPTIONAL

BOTH


EV01_cUseProvidedSTRX

CHARACTER

OPTIONAL

BOTH


STRX_jdCompletionDate

DATE

OPTIONAL

BOTH


EV01_cUseProvidedSUB

CHARACTER

OPTIONAL

BOTH


SUB_szSubsidiary

STRING

OPTIONAL

BOTH


EV01_cUseProvidedTBM

CHARACTER

OPTIONAL

BOTH


TBM_szTypeOfBill

STRING

OPTIONAL

BOTH


EV01_cUseProvidedTIMEZONES

CHARACTER

OPTIONAL

BOTH


TIMEZONES_szTimeZoes

STRING

OPTIONAL

BOTH


EV01_cUseProvidedTMCO

CHARACTER

OPTIONAL

BOTH


TMCO_mnTimeCompleted

INTEGER

OPTIONAL

BOTH


EV01_cUseProvidedTRDJ

CHARACTER

OPTIONAL

BOTH


TRDJ_jdDateTransactionJulian

DATE

OPTIONAL

BOTH


EV01_cUseProvidedTRT

CHARACTER

OPTIONAL

BOTH


TRT_szTypeOfRouting

STRING

OPTIONAL

BOTH


EV01_cUseProvidedTXA1

CHARACTER

OPTIONAL

BOTH


TXA1_szTaxArea1

STRING

OPTIONAL

BOTH


EV01_cUseProvidedTYPS

CHARACTER

OPTIONAL

BOTH


TYPS_cWOType

CHARACTER

OPTIONAL

BOTH


EV01_cUseProvidedUOM

CHARACTER

OPTIONAL

BOTH


UOM_szUnitOfMeasure

STRING

OPTIONAL

BOTH


EV01_cUseProvidedUOM2

CHARACTER

OPTIONAL

BOTH


UOM2_szUnitOfMeasureSecondary

STRING

OPTIONAL

BOTH


EV01_cUseProvidedUORG

CHARACTER

OPTIONAL

BOTH


UORG_mnQtyOrdered

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedVR01

CHARACTER

OPTIONAL

BOTH


VR01_szReference

STRING

OPTIONAL

BOTH


EV01_cUseProvidedVR02

CHARACTER

OPTIONAL

BOTH


VR02_szReference2

STRING

OPTIONAL

BOTH


EV01_cUseProvidedWHO2

CHARACTER

OPTIONAL

BOTH


WHO2_szContactName2

STRING

OPTIONAL

BOTH


EV01_cUseProvidedWR01

CHARACTER

OPTIONAL

BOTH


WR01_szWOCategoryCode001

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR02

CHARACTER

OPTIONAL

BOTH


WR02_szWOCategoryCode002

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR03

CHARACTER

OPTIONAL

BOTH


WR03_szWOCategoryCode003

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR04

CHARACTER

OPTIONAL

BOTH


WR04_szWOCategoryCode004

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR05

CHARACTER

OPTIONAL

BOTH


WR05_szWOCategoryCode005

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR06

CHARACTER

OPTIONAL

BOTH


WR06_szWOCategoryCode006

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR07

CHARACTER

OPTIONAL

BOTH


WR07_szWOCategoryCode007

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR08

CHARACTER

OPTIONAL

BOTH


WR08_szWOCategoryCode008

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR09

CHARACTER

OPTIONAL

BOTH


WR09_szWOCategoryCode009

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR10

CHARACTER

OPTIONAL

BOTH


WR10_szWOCategoryCode010

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR11

CHARACTER

OPTIONAL

BOTH


WR11_szECOworkbenchselections

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR12

CHARACTER

OPTIONAL

BOTH


WR12_szCategoriesWorkOrder12

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR13

CHARACTER

OPTIONAL

BOTH


WR13_szCategoriesWorkOrder13

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR14

CHARACTER

OPTIONAL

BOTH


WR14_szCategoriesWorkOrder14

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR15

CHARACTER

OPTIONAL

BOTH


WR15_szCategoriesWorkOrder15

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR16

CHARACTER

OPTIONAL

BOTH


WR16_szCategoriesWorkOrder16

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR17

CHARACTER

OPTIONAL

BOTH


WR17_szCategoriesWorkOrder17

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR18

CHARACTER

OPTIONAL

BOTH


WR18_szCategoriesWorkOrder18

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR19

CHARACTER

OPTIONAL

BOTH


WR19_szCategoriesWorkOrder19

UDC

OPTIONAL

BOTH


EV01_cUseProvidedWR20

CHARACTER

OPTIONAL

BOTH


WR20_szCategoriesWorkOrder20

UDC

OPTIONAL

BOTH


EV01_cUseProvidedPBTM

CHARACTER

OPTIONAL

BOTH


PBTM_mnPlannedFinishTime

INTEGER

OPTIONAL

BOTH


EV01_cUseProvidedSETC

CHARACTER

OPTIONAL

BOTH


SETC_mnCrewSize

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedURCD

CHARACTER

OPTIONAL

BOTH


URCD_szUserReservedCode

STRING

OPTIONAL

BOTH


EV01_cUseProvidedURDT

CHARACTER

OPTIONAL

BOTH


URDT_jdUserReservedDate

DATE

OPTIONAL

BOTH


EV01_cUseProvidedURAT

CHARACTER

OPTIONAL

BOTH


URAT_mnUserReservedAmount

FLOAT

OPTIONAL

BOTH


EV01_cUseProvidedURAB

CHARACTER

OPTIONAL

BOTH


URAB_mnUserReservedNumber

INTEGER

OPTIONAL

BOTH


EV01_cUseProvidedURRF

CHARACTER

OPTIONAL

BOTH


URRF_szUserReservedReference

STRING

OPTIONAL

BOTH


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.