E1: 42: 017F (Fetch Unsuccessful) in Flexing F4102.STKT for Nonstock Item in R42800
(Doc ID 2378160.1)
Last updated on APRIL 07, 2025
Applies to:
JD Edwards EnterpriseOne Sales Order Processing - Version 9.0 and laterInformation 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,
- AAI Table Number: 4230 (Revenue/Sales)
- Company: 00200 and 00001
- Document Type: SO (Sales Order)
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! |
In this Document
| Goal |
| Solution |
| References |