E1: 42: 017F (Fetch Unsuccessful) in Flexing F4102.STKT for Nonstock Item in R42800
(Doc ID 2378160.1)
Last updated on MARCH 27, 2018
Applies to:JD Edwards EnterpriseOne Sales Order Processing - Version 9.0 and later
Information in this document applies to any platform.
Q1> Why R42800 (Sales Update) writes work center error message as below,
Fetch Unsuccessful (Error Code 017F)
even when it contains error above, a user is able to post sales records without having any problem.
Business case 1:
To represent better cost of inventory, same item can have two different stocking type as below,
|Branch/Plant||Item Number||Description||Stocking Type||Line Type||G/L Class||Sales Code 2|
Depending on the Branch/plant, the Subledger has to be P or M which is the stocking type of Item Branch File (F4102).
To meet this expectation,
- AAI Table Number: 4230 (Revenue/Sales)
- Company: 00200 and 00001
- Document Type: SO (Sales Order)
|Co||Do Ty||Description||G/L Cat||Description G/L||Branch Plant||Obj Acct||Sub|
|00200||SO||Sales Order||IN30||Manufactured Finished Goods||5015|
Flex Settings (F4096)
|Seq||Business Unit||Subsidiary||Subledger||Item||Cost Object||Cost Type||File Name||Len||Description||Data Item||Data Type|
|1||X||F4101||8||Item Number - Short||ITM|
Since the stocking type in F4101 (Item Master) can be only a single value so the stocking type is only option to record it. Plus, F4211 (Sales Order Detail File) does not contain the stocking type (STKT) in it.
Q2> What is the usage of FC Adjustment Name in [Flex Rule Definition] P40296|W40296C? Can this setting allows the system to skip Flex routine not to hit the error 017F?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document