Business Unit Invalid on Item Branch creation using R4101Z1I

okiedokie

okiedokie

Member
I'm attempting to create Item Branch record with R4101Z1I and our F0006 format for MCU is ' 9310' with required description
Has anyone received the same "Business Unit Invalid" message from N4101060 before when all the required F4101Z1 fields look correct?
The c function seems to alternate success, then fail as I single step thru F0006 Get Business Unit / IsColumnInBusinessUnitTable (ISCOLBU.c) returns 2.

This is a global client running 9.1.3.3 but i'm working with US/English data only.

The servers are Wintel (2008) and AIX 7.1.
Any comments, advice, or thoughts greatly appreciated

John

Here's a debug log excerpt below:
********************************************************************************
Jul 14 15:52:37.542017 - 3596/5580 WRK:Starting jdeCallObject *** Start dumping data structure for business function EditRetrieveDeleteCategoryCodes
Jul 14 15:52:37.542018 - 3596/5580 WRK:Starting jdeCallObject **********************************************************************************
Jul 14 15:52:37.542019 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 1] <Item>: szBranchPlant <type>: STRING <Value>: [ 9310 ]
Jul 14 15:52:37.542020 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 2] <Item>: mnIdentifierShortItem <type>: MATH_NUMERIC <Value>: [1269302]
Jul 14 15:52:37.542021 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 3] <Item>: cStatus <type>: CHAR <Value>: []
Jul 14 15:52:37.542022 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 4] <Item>: jdEffectiveThruDate <type>: JDEDATE <Value>: [7/14/2015]
Jul 14 15:52:37.542023 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 5] <Item>: mnDocVoucherInvoiceE <type>: MATH_NUMERIC <Value>: [3529442]
Jul 14 15:52:37.542024 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 6] <Item>: szDocumentType <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542025 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 7] <Item>: jdEffectiveFromDate <type>: JDEDATE <Value>: []
Jul 14 15:52:37.542026 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 8] <Item>: mnKeyValueSerialNumber <type>: MATH_NUMERIC <Value>: [0]
Jul 14 15:52:37.542027 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 9] <Item>: szTransactionAction <type>: STRING <Value>: [A ]
Jul 14 15:52:37.542028 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 10] <Item>: cUpdateMasterFile <type>: CHAR <Value>: [1]
Jul 14 15:52:37.542029 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 11] <Item>: cWorkflow <type>: CHAR <Value>: []
Jul 14 15:52:37.542030 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 12] <Item>: cInteroperability <type>: CHAR <Value>: []
Jul 14 15:52:37.542031 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 13] <Item>: cProcessEdits <type>: CHAR <Value>: [ ]
Jul 14 15:52:37.542032 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 14] <Item>: cPendingProcessing <type>: CHAR <Value>: [ ]
Jul 14 15:52:37.542033 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 15] <Item>: cSuppressErrorMessage <type>: CHAR <Value>: [ ]
Jul 14 15:52:37.542034 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 16] <Item>: szErrorMessageId <type>: STRING <Value>: [3091]
Jul 14 15:52:37.542035 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 17] <Item>: szProgramId <type>: STRING <Value>: [ER4101Z1I]
Jul 14 15:52:37.542036 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 18] <Item>: szVersion <type>: STRING <Value>: []
Jul 14 15:52:37.542037 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 19] <Item>: szSalesReportingCode1 <type>: STRING <Value>: [BM]
Jul 14 15:52:37.542038 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 20] <Item>: szSalesReportingCode2 <type>: STRING <Value>: [AX]
Jul 14 15:52:37.542039 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 21] <Item>: szSalesReportingCode3 <type>: STRING <Value>: [22]
Jul 14 15:52:37.542040 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 22] <Item>: szSalesReportingCode4 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542041 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 23] <Item>: szSalesReportingCode5 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542042 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 24] <Item>: szSalesReportingCode6 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542043 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 25] <Item>: szSalesReportingCode7 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542044 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 26] <Item>: szSalesReportingCode8 <type>: STRING <Value>: [N]
Jul 14 15:52:37.542045 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 27] <Item>: szSalesReportingCode9 <type>: STRING <Value>: [40]
Jul 14 15:52:37.542046 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 28] <Item>: szSalesReportingCode10 <type>: STRING <Value>: [AX22]
Jul 14 15:52:37.542047 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 29] <Item>: szPurchasingReportCode1 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542048 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 30] <Item>: szPurchasingReportCode2 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542049 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 31] <Item>: szPurchasingReportCode3 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542050 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 32] <Item>: szPurchasingReportCode4 <type>: STRING <Value>: [841]
Jul 14 15:52:37.542051 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 33] <Item>: szPurchasingReportCode5 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542052 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 34] <Item>: szPurchReportingCode6 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542053 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 35] <Item>: szPurchReportingCode7 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542054 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 36] <Item>: szPurchReportingCode8 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542055 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 37] <Item>: szPurchReportingCode9 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542056 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 38] <Item>: szPurchReportingCode10 <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542057 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 39] <Item>: mnCarrier <type>: MATH_NUMERIC <Value>: [0]
Jul 14 15:52:37.542058 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 40] <Item>: mnPreferCarrierPurchasin <type>: MATH_NUMERIC <Value>: [0]
Jul 14 15:52:37.542059 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 41] <Item>: szShippingConditionsCode <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542060 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 42] <Item>: szShippingCommodityClass <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542061 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 43] <Item>: szCycleCountCategory <type>: STRING <Value>: [ ]
Jul 14 15:52:37.542062 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 44] <Item>: cErrorsExist <type>: CHAR <Value>: [1]
Jul 14 15:52:37.542063 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 45] <Item>: szCopyBranchPlant <type>: STRING <Value>: []
Jul 14 15:52:37.542064 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 46] <Item>: mnCopyIdentifierShort <type>: MATH_NUMERIC <Value>: [0]
Jul 14 15:52:37.542065 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 47] <Item>: cUpdateItemBranch <type>: CHAR <Value>: [2]
Jul 14 15:52:37.542066 - 3596/5580 WRK:Starting jdeCallObject OUT->[ 48] <Item>: idPointerCategoryCodes <type>: ID <Value>: [0]
Jul 14 15:52:37.542067 - 3596/5580 WRK:Starting jdeCallObject **********************************************************************************
Jul 14 15:52:37.542068 - 3596/5580 WRK:Starting jdeCallObject *** End dumping data structure for business function EditRetrieveDeleteCategoryCodes
Jul 14 15:52:37.542069 - 3596/5580 WRK:Starting jdeCallObject **********************************************************************************
Jul 14 15:52:37.542070 - 3596/5580 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Jul 14 15:52:37.542071 - 3596/5580 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Jul 14 15:52:37.542072 - 3596/5580 WRK:Starting jdeCallObject Return value is 2 for EditRetrieveDeleteCategoryCodes. (BSFNLevel = 1)
 
Maybe a space thing ? "________9310" as opposed to "9310" - remember that MCU is a string, not a number field.
 
Use format business unit function before you load the value into Z table to avoid this error.

Chan
 
Back
Top