E1: 41: P4114 Inventory Adjustment Issues an 'Item Number Invalid' with Flex Account - CASE STUDY
Last updated on MARCH 01, 2018
Applies to:
JD Edwards EnterpriseOne Inventory Management - Version 9.1 and laterInformation in this document applies to any platform.
Goal
This document is a case study only with general debugging methods.
Issue
P4114 (Inventory Adjustment) issues error with Flex Account on as below,
Item Number Invalid
A form level error has occurred.
CAUSE.... The Item Number entered does not exist in the Basic Item Master
(P4101).
ER Details:
Form P4114_W4114A
Control Id 1
Control Title Grid
Event Row is Exit & Changed - Asynch
Line No 61
BSFN Details:
Source File x4101.c
Source Line 1321
Error ID 0267
Error representation in the JDEDEBUG
Same repeats in JDEDEBUG.log as below,
sql> SELECT IMITM, IMLITM, IMAITM, IMDSC1, IMDSC2, IMIFLA, IMTFLA, IMTMPL, IMSEG1, IMSEG2, IMSEG3, IMSEG4, IMSEG5, IMSEG6, IMSEG7, IMSEG8, IMSEG9, IMSEG0, IMMIC FROM PRODDTA.F4101 WHERE ( IMITM = 741386741386.000000 )
No More Data found (hRequest 0A6F44C0)
ERROR INFO JDEERR - ID= 0, Error= 0267 - x4101.c, Line= 1321
Note:
- Compare this outcome with error presentation in HTML client.
- X4101 is the function getting item master information based on Short Item Number
As - Is Flex Account Setup using P40296 (Flex Rules Definition)
Flex Rule Definition - Flexible Sales Account Revisions
AAI Table Number 4124 Company 00001
Document Type IA
Seq | Business Unit | Subsidiary | Subledger | Item | Cost Object | Cost Type | File Name | Len | Description | Data Item | Data Type |
1 | X | F4102 | 6 | Category Code 7 | SRP7 | ||||||
2 | X | F4102 | 8 | Item Number - Short | ITM | ||||||
3 | X | F4102 | 8 | Item Number - Short | ITM | ||||||
4 | 3 | P | F4102 | 3 | Commodity Class | PRP1 | |||||
5 | 3 | P | F4102 | 3 | Commodity Class | PRP1 | |||||
6 | 4 | G | F4102 | 3 | Supplier Rebate Code | PRP3 | |||||
7 | 4 | G | F4102 | 3 | Supplier Rebate Code | PRP3 |
Note:
- Row 2 is to record F0911.ITM based on F4102.ITM
- Row 3 affects 741386741386 where F4102.ITM = 741386
- P40296 allows you to define duplicated definition which is functioning as designed because some may set it such way intentionally.
Solution
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 hundreds of Community platforms