My Oracle Support Banner

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.

Goal

 

 

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
          30 ItemA Description01 P S IN30  
         M30 ItemA Description01 M S IN30  

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,

DMAAI (F4095)

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  
2      X       F4102 1 Stocking Type STKT  

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?
 

 

 

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.