How to Troubleshoot application P45550 (F4072 Global Update Engine)

Purpose of Document

Purpose of this document is to guide user how to debug issue in P45550 (F4072 Global Update Engine) and P45510 (Search Agent) by explaining as-is routine of this application.

Some contents in this document requires developer level knowledge.

Before proceed further, refer below knowledge documents:
<Document 625697.1> E1: 45: Mass Maintenance (P45550/P45501)
<Document 625696.1> E1: 45: Search Agents (P45510)
<Document 625667.1> E1: 45: Pricing Workbench (P45501 / P45550)
<Document 1376252.1> E1: 40: Workfiles in Distribution and Manufacturing
<Document 1366505.1> E1: 45: Advanced Pricing FAQ (P4070/P4071/P4072/R42750)

Through this document,

Data Manipulation through P45550 (F4072 Global Update Engine)
Layout of W45550A [Price Adjustments Global Revisions] form
How data get inserted into F4072W (Price Adjustment Detail Work File)

Case 1 - Search Agent is Not used
Case 2 - Search Agent is Used

Tables used for form W45550A

F4072W
F40941 (Item Key ID Master File), F40942 (Customer Key ID Master File) and F40943 (Order Group Key ID Master File).

Data Manipulation through P45510 (Search Agent Maintenance)
Business Functions used in P45510
Forms related with data creation for Search Agent
Tables related with Search Agent
- Query Example F45511 and WHERE clause construction
- F45511W (Search Agent Directives Work File)
- F45511 (Search Agent Directives Detail)
- F45510 (Search Agent Directives Header)
- UDC 45/RT - Relationship Type
Error Implementation
Conclusion

Data Manipulation in P45550 (F4072 Global Update Engine):

Action	Hook up	Key	Others
insert F4072W	Find button Clicked Cancel button Clicked (when Copy is selected)	CTID, JOBS, PEID, TCID, AST, ITM, AN8, IGID, OGID, CGID, CRCD, UOM, MNQ, EXDJ	Through business function F4072 Search Engine (B4500500 - F4072SearchEngine)
delete F4072W	Find button Clicked (when there are exiting data for previous action) Cancel button clicked All Grid Recs Updated to DB (when copy is selected)	CTID, JOBS, PEID, TCID	Through business function F4072W Delete All Records (B4500610 - F4072WDeleteAll
insert F4072	Update Grid Rec to DB-Before	ITM, AST, AN8, IGID, CGID, OGID, CRCD, UOM, MNQ, EXDJ, UPMJ, TDAY	Through Table I/O Note that the form W45550A is based on F4072W not F4072

Note:

Addition takes place when you click Find button
Deletion takes place when you click Cancel button

Layout of W45550A form

: Grid information is based on F4072W, F40941, F40942 and F40943. You can use any columns for additional filteration.
W45550A
Explanation on Form Controls:

a - Search Agent Name: (Do not leave it blank in clicking Find button). Enter the Search Agent you have created. If you do not specify value for this control, it reads all data from F4072 so (if you leave it blank) this will performance heavily. This controls is case sensitive, so if possible, try to use all upper cases.
b - Table Name: This control is mainly for Search Agent which enable you to create Search Agent dynamically based on whatever table you enter in this control. In case you are not accessing form exits (SA Properties and SA Revisions) and in your clicking Find button the value is to be set 'F4072'.
c - (Push Button) Refresh Grid
d - (Push Button) Update Grid Only
A - Machine Key: (F4072W.CTID): this is returned through business method GetAuditInfo (cf., business function b9800100) which is running in JAS (because we defined it through LocalLogicCatalog.xml file in JAS) so this value returns JAS machine name. For detail on business method running in JAS, refer to <Document 1090584.1> E1: BSFN: Frequently Asked Questions on Business Functions/Methods Running on JAS.
B - Job Number: F4072W.JOBS): Internal Job Number (cf., NN 00|4 for server batch job for UBE) this value is returned by JDE API JDB_GetInternalNextNumber() in calling GetInternalNextNumber (B0000564). The value gets stored in memory (not table) and increment 1 whenever this API gets called. A number of business function can call this API to set unique cache name in the routine. For example, if you enter any inventory transaction, this number is to be increased.
C - Process ID: (F4072W.PEID): CallObject Kernel Process ID or, Inter-Process Communication Process ID. There is chance to have same process ID, though you log off/on EnterpriseOne because 15~20 uses share a single CallObject Kernel process though you log out/on again there is chance to have same process ID. This value is returned through JDE API jdeGetPid(). The number returned here is to be same with the process ID you can verify through Task Manager, SAW (serveradministrationworkbench.exe) and Server Manager. We can not guarantee this number is unique per specific users because this ID is determined by the operating system where logic is running.
D - Transaction ID: (F4072W.TCID): This value is determined through business function RetrieveProcessAndTransactionID (B0001060) which calls same API JDB_GetInternalNextNumber(). So TCID = JOBS + 1 because in getting JOBS increment of 1 took place and there is not any other routine which gets internal next number.
F - (Internet Browser Close button)
G - Cancel button

Note:

Before press Find button, create Search Agent in advance based on your business requirement
A, B, C and D are not to be appeared in standard application. These controls are used for filtering data in grid based on F4072W
Do not click Close button (F - Close Internet Browser button) which resulted in orphaned data into F4072W. Same orphaned data can be found when your session got expired. Meaning that if there is no hook up event data from F4074W will be remained.
Variables for CTID, JOBS, PEID and TCID is being set through "Dialog is Initialized" event so these value are to be remained till you finish your session by clicking OK or Cancel button in W45550A. In other words, you are not able to update these values at once session started.
Filtering data through QBE (Query By Example) does not impact selecting data from F4072 (Price Adjustment Detail) Flie. So it is important to set up proper Search Agent and make use of it to minimize any possible problem in this application.
Deletion takes place based on CTID, JOBS, PEID and TCID which is different from primary key
In case you click Close windows button or come across session time out (or abandoned transaction) there is high chance to have records from F4072W
Do truncate table F4072W when no users are accessing data from same table

How data get inserted into F4072W?
Case 1 - Search Agent is not specified:

No Search Agent

Note:

Storing the return value of F4072 in a different variable. If there is no matching F4071 record for F4072 then we should not skip the while loop which fetches F4072 instead we should not show that specific record in MassMaintenance(P45550) and show all the other matching record
Do not fetch from F4071 again if Adjustment Name is the same (performance reason)
Do not write to F4072W if it is a non-Sales adjustment, Sliding Rate adjustment, Enhanced Basket adjustment, rounding adjustment, rebate records or preference record.

Case 2 - Search Agent is specified:

The routine are identical except the way it gets data from F4072. By specifying Search Agent before press Find/Refresh button additional where clause is to be appended. Refer below Search Agent Section.

Table used for form W45550A

Table F4072W:

	Table	Column	DD Item	Glossary	Others
1	F4072W	AST	PriceAdjustmentType [8] Price Adjustment Name	A user defined code (system 40, type TY) that identifies an adjustment definition. You define adjustments on Price Adjustment Names.	UDC 40/TY - Adjustment/Preference Name
2	F4072W	ITM	IdentifierShortItem [8] Item Number - Short
3	F4072W	LITM	Identifier2ndItem [25] 2nd Item Number
4	F4072W	AITM	Identifier3rdItem [25] 3rd Item Number
5	F4072W	AN8	AddressNumber [8] Address Number
6	F4072W	IGID	ItemGroupKeyID [8] Item Group Key ID	A number that identifies an item group or an order detail pricing group. Each pricing group is comprised of either item category codes (for an item group) or sales order detail field values (for an order detail group). For every unique combination of values in the pricing group, the system assigns a number (key ID) to identify the group. The system retrieves this number from the Next Numbers program (P0002) for the system code 40 and the line number 5.	F40941.IGID
7	F4072W	CGID	CustomerGroupKeyID [8] Customer Group Key ID	A number that identifies a customer pricing group. Each pricing group comprises customer category codes. For every unique combination of values in the pricing group, the system assigns a number (key ID) to identify the group. This number is retrieved from the Next Numbers program (P0002) using system code 45, line number 2.	F40942.CGID
8	F4072W	OGID	OrderGroupKeyID [8] Order Group Key ID	A number that identifies an order detail pricing group. Each group consists of sales order detail values. For each unique combination of values in the order group, the system assigns a number (key ID) to identify the group. The system retrieves this number from the Next Numbers program (P0002) by using system code 45 and line number.	F40943.OGID
9	F4072W	CRCD	CurrencyCodeFrom [3] Currency Code - From
10	F4072W	UOM	UnitOfMeasureAsInput [2] Unit of Measure as Input
11	F4072W	MNQ	QuantityMinimum [15] Quantity - From	A value that specifies how an adjustment or preference will be applied to a price. This value can be a quantity, weight, or amount, depending on how you have defined the level-break type in the Price Adjustment Detail table (F4072).	Edit Code M (No Comma, No -)
12	F4072W	EFTJ	DateEffectiveJulian1 [6] Date - Effective
13	F4072W	EXDJ	DateExpiredJulian1 [6] Date - Expired
14	F4072W	BSCD	BasisCode [1] Basis Code		UDC 40/BC - Basis Code
15	F4072W	LEDG	LedgType [2] Cost Method
16	F4072W	FRMN	PriceFormulaName [10] Price Formula Name
17	F4072W	FVTR	FactorValue [15] Factor Value
18	F4072W	FGY	FreeGoodsYN [1] Free Goods (Y/N)
19	F4072W	ATID	PriceAdjustmentKeyID [8] Price Adjustment Key ID
20	F4072W	URCD	UserReservedCode [2] User Reserved Code
21	F4072W	URDT	UserReservedDate [6] User Reserved Date
22	F4072W	URAT	UserReservedAmount [15] User Reserved Amount
23	F4072W	URAB	UserReservedNumber [8] User Reserved Number
24	F4072W	URRF	UserReservedReference [15] User Reserved Reference
25	F4072W	NBRORD	NumberofOrders [15] Number of Orders
26	F4072W	UOMVID	UOMforVolumneIncentives [2] Unit of Measure - Volumn Incentives
27	F4072W	FVUM	FactorValueUM [2] Factor Value Unit of Measure
28	F4072W	PARTFG	PricePartialQtyFlag [1] Price Partial Quantities Flag
29	F4072W	APRS	ApprovalStatus [1] Approval Status
30	F4072W	USER	UserId [10] User ID
31	F4072W	PID	ProgramId [10] Program ID
32	F4072W	JOBN	WorkStationId [10] Work Station ID
33	F4072W	UPMJ	DateUpdated [6] Date - Updated
34	F4072W	TDAY	TimeOfDay [6] Time of Day
35	F4072W	BKTPID	BasketParentID [8] Basket Parent ID
36	F4072W	CRCDVID	CurrencyCodeforVolumneIncentives [3] Currency Code - Volumn Incentives
37	F4072W	CTID	ComputerID [15] Computer ID		this is returned through business method GetAuditInfo (cf., business function b9800100) which is running in JAS (because we defined it through LocalLogicCatalog.xml file in JAS) so this value returns JAS machine name. For detail on business method running in JAS, refer to <Document 1090584.1> E1: BSFN: Frequently Asked Questions on Business Functions/Methods Running on JAS.
38	F4072W	JOBS	JobnumberA [8] Job Number		Internal Job Number (cf., NN 00\|4 for server batch job for UBE) this value is returned by JDE API JDB_GetInternalNextNumber() in calling GetInternalNextNumber (B0000564). The value gets stored in memory (not table) and increment 1 whenever this API gets called. A number of business function can call this API to set unique cache name in the routine. For example, if you enter any inventory transaction, this number is to be increased.
39	F4072W	PEID	ProcessID [15] Process ID		CallObject Kernel Process ID or, Inter-Process Communication Process ID. There is chance to have same process ID, though you log off/on EnterpriseOne because 15~20 uses share a single CallObject Kernel process though you log out/on again there is chance to have same process ID. This value is returned through JDE API jdeGetPid(). The number returned here is to be same with the process ID you can verify through Task Manager, SAW (serveradministrationworkbench.exe) and Server Manager. We can not guarantee this number is unique per specific users because this ID is determined by the operating system where logic is running.
40	F4072W	TCID	TransactionID [15] Transaction ID		This value is determined through business function RetrieveProcessAndTransactionID (B0001060) which calls same API JDB_GetInternalNextNumber(). So TCID = JOBS + 1 because in getting JOBS increment of 1 took place and there is not any other routine which gets internal next number.

Note:

All columns in F4072W are repeating except RULENAME (Rounding Rule Name) based on F4072
Additional 4 columns CTID, JOBS, PEID and TCID are additional columns for F4072W
The columns you can see in Grid is based on columns from F4072W, F40941, F40942 and F40943. You can use any columns from these tables to narrow down copy/update based on returned value.
Example of actual query: sql> SELECT F40943.OKSDV5,F40942.CKCGP5,F4072W.ADCRCDVID,F4072W.ADFVTR,F40943.OKSDV1,F4072W.ADBKTPID,F40941.IKIGP4,F40941.IKIGP9,F4072W.ADLITM,F4072W.ADPARTFG,F4072W.ADTCID,F40942.CKCGP9,F4072W.ADCRCD,F4072W.ADFRMN,F4072W.ADITM,F40941.IKIGP7,F4072W.ADURAB,F4072W.ADTDAY,F40941.IKIGP6,F40941.IKIGP3,F40941.IKIGP8,F4072W.ADURCD,F4072W.ADAN8,F4072W.ADBSCD,F40941.IKIGP1,F40941.IKPRGR,F4072W.ADLEDG,F40943.OKSDV3,F40942.CKCGP4,F40943.OKSDV6,F4072W.ADJOBN,F4072W.ADAPRS,F4072W.ADURDT,F4072W.ADAITM,F4072W.ADOGID,F40942.CKCGP2,F4072W.ADFVUM,F4072W.ADPID,F4072W.ADIGID,F4072W.ADEXDJ,F4072W.ADUPMJ,F4072W.ADAST,F4072W.ADMNQ,F4072W.ADCGID,F4072W.ADUSER,F40943.OKSDV2,F4072W.ADCTID,F4072W.ADEFTJ,F40943.OKSDGR,F4072W.ADUOMVID,F4072W.ADJOBS,F40941.IKIGP2,F40942.CKCGP8,F4072W.ADATID,F40942.CKCPGP,F40942.CKCGP3,F40942.CKCGP7,F40943.OKSDV7,F4072W.ADUOM,F40943.OKSDV4,F4072W.ADPEID,F40941.IKIGP10,F4072W.ADURAT,F4072W.ADFGY,F40941.IKIGP5,F40942.CKCGP1,F40942.CKCGP6,F40943.OKSDV8,F4072W.ADNBRORD,F40942.CKCGP10,F4072W.ADURRF FROM PRODDTA.F4072W T0, PRODDTA.F40941 T1, PRODDTA.F40942 T2, PRODDTA.F40943 T3 WHERE (((((F4072W.ADCTID = MFGJAPAC02 AND F4072W.ADJOBS = 17 ) AND F4072W.ADTCID = 18 ) AND F4072W.ADPEID = 13056 ))) AND (F4072W.ADIGID = F40941.IKIGID AND F4072W.ADCGID = F40942.CKCGID AND F4072W.ADOGID = F40943.OKOGID) ORDER BY F4072W.ADCTID ASC , F4072W.ADJOBS ASC , F4072W.ADPEID ASC , F4072W.ADTCID ASC , F4072W.ADAST ASC , F4072W.ADITM ASC , F4072W.ADAN8 ASC , F4072W.ADIGID ASC , F4072W.ADOGID ASC , F4072W.ADCGID ASC , F4072W.ADCRCD ASC , F4072W.ADUOM ASC , F4072W.ADMNQ ASC , F4072W.ADEXDJ ASC
In case you need to filter it further enter value at QBE (Query By Example)

Data Manipulation in P45510 (F4072 Global Update Engine):
P45510 handles data as below,

Action	Hook up	Key	Others
Insert F45511W	In clicking (in W45550A) form exit, SA Revisions - ADD: Write all columns of F4072 - UPDATE: Write only exiting columns from exiting F45511 SA Properties (same with update from SA Revisions)	CTID, JOBS, TCID, PEID, DTAI, SASEQVL	via BSFN B4500580 - F45511WLoadDataItem (F45511W Load Data Item). CTID, JOBS, TCID, PEID are inherited from W45550A [Price Adjustments Global Revisions] and this is why P45510 is to be trigged by other application
Insert F45511	In W45510F [Search Agent Revisions] - Post OK button clicked	SANAME, DTAI, SASEQVL	Through business function B4500580 - F45511CopyFromF45511W (F45511 Copy From F45511W)
Insert F45510	In W45510F [Search Agent Revisions] - Post OK button clicked (after F45511 recorded correctly)	SANAME	via BSFN B4500580 - F45510AddUpdateSearchAgent (F45510 Add or Update Search Agent)
Delete F45511W	In W45510F [Search Agent Revisions] - Post OK button clicked (work file is used to create F45511 and F45510) - Post Cancel button clicked (abort work file data) - (Form Exit) Delete Search Agent clicked	CTID, JOBS, TCID, PEID	through business function B4500580 - F45511WDelete (F45511W Delete). In case these action does not take place there is chance ot have orphaned data from F45511W

Note:

CTID, JOBS, TCID, PEID are inherited from calling routine of P45550 (F4072 Global Update Engine)
If you do not invoke delete F45511W there is chance to have orphaned data (Close button clicked or session timeout)
If you have any orphaned data from F45511W delete it using query tools

Business Functions used in P45510 (Search Agent Maintenance):

Source Module	Description	Template	Purpose	Others
B4500580	F45511CopyFromF45511W (F45511 Copy From F45511W)	D4500580A	To insert/add or update/change data into F45511W	New Data Item is selected update takes place
B4500580	F45511WDelete (F45511W Delete)	D4500580B	To delete workfile F45511W
B4500580	F45511WLoadDataItem (F45511W Load Data Item)	D4500580C	To populate data into F45511W - Add Mode: all columns in F4072 through table specification (glbltbl, or F98711) - Update/Inquiry Mode: get it from F45511	Table specification can be retrieved by calling B4500570 (GetTableSpecifications - Get Table Specifications)
B4500580	F45510DeleteSearchAgent (F45510 Delete Search Agent All)	D4500580D	To delete table F45511 and F45510	Parameter cDeleteF45511OnlyYN can be used when there is no detail information to delete header only
B4500580	F45510AddUpdateSearchAgent (F45510 Add or Update Search Agentf)	D4500580E	To update header F45510 based on data created in F45511
B4500580	F45511WGetNextSequence (F45511W Get Next Sequence Number)	D4500580F	To update/get F45511W.SASEQVL base don CTID, JOBS, TCID, PEID and DTAI

Note:

Forms related with data creation for Search Agent:

Below forms are related with maintaining Search Agent,

Search Agent

P45550|W45550A [Price Adjustment Global Revisions] This form enables you to create a new Search Agent, or select exiting Search Agent or search Advanced Price Schedule based on filteration (Search Agent) you have set.
P45510|W45510F [Search Agent Revisions] This form gives you all columns for filteration based on table F4072 (by reading glbltbl or, F98711) and additionally you can set security and Search Agent Description. The value you are seeing in grid is stored in F45511W and remained till you exit from this form.
P45510|W45510E [List of Values Revisions] Through this form you are able to populate actual value into F45511 which can be used how to filter data from table F4072

Note:

Highlighted columns (Machine Key, Job Number, Process ID, Transaction ID in W45550A and Search Agent Value Sequence in F45510E) are changed to visible for easier understanding
Only table F4072 can be used to create Search Agent
Sequence number is handled through form W45510E form
If you click Close button or session timeout F45511W leaves orphaned data

Tables related with Search Agent

Search Agent is maintained through tables,

F45511W (Search Agent Directives Work File): This is temporary (work file) to hold all columns information of table F4072.
F45511 (Search Agent Directives Detail): This table records the columns to filter, number of elements and it values
F45510 (Search Agent Directives Header): This table stores the number of directive (the number of columns to use for constructing WHERE clause) and total number of values

cf., In computer industry "Directive" can be defined: In computer programming, a directive or pragma (from "pragmatic") is a language construct that specifies how a compiler should process its input. Directives are not part of the language proper they are not part of the grammar, and may vary from compiler to compiler but instead function either as an in-band form of a command-line option, specifying compiler behavior, or are processed by a preprocessor. In some cases directives specify global behavior, while in other cases they only affect a local section, such as a block of programming code. In some cases, such as some C pragmas, directives are optional compiler hints, and may be ignored, but normally they are prescriptive, and must be followed. However, a directive does not perform any action in the language itself, only change the behavior of the compiler.

For this example, directive is JDE specific terms to build data selection against F4072.

F45511 and WHERE clause construction:

Search Agent Name (SANAME)	Data Item (DTAI)	Search Agent Value Sequence (SASEQVL)	Search Agent Relationship (SASELTY)	Search Agent Value (SAVALUE)	Directive - Number List Elements (SALSTNB)
SANAME	AN8	1	IN	4242	3
SANAME	AN8	2	IN	4245	0
SANAME	AN8	3	IN	74242	0
SANAME	BSCD	1	RE	3	2
SANAME	BSCD	2	RE	4	0

SASEQVL indicates sequence of values (1, 2, ... n)
SALSTNB indicates total number of rows for same DTAI (the number of element)
How to set sequence and total number of rows are handled through event rule in P45510
Expected query for this example: WHERE ( ( ADAN8 IN (4242, 4245, 74242) AND (ADBSCD > '3' AND ADBSCD < '4'))

F45511W - Search Agent Directives Work File

	Table	Column	DD item	Glossary	Values are from	Others
1	F45511W	CTID*	ComputerID [15] (Computer ID)		(Hidden) CTID value from W45550A	Refer above
2	F45511W	JOBS*	JobnumberA [8] (Job Number)		(Hidden) JOBS value from W45550A
3	F45511W	PEID*	ProcessID [15] (Process ID)		(Hidden) PEID value from W45550A
4	F45511W	TCID*	TransactionID [15] (Transaction ID)		(Hidden) CTID value from W45550A
5	F45511W	DTAI*	DataItem [10] (Data Item)
6	F45511W	SASEQVL*	SeachAgentValueSequence [6] (Search Agent Value Sequence Numver)			This is primary key enables you to choose multiple values for relation typeBW, IN, NL, RE.
7	F45511W	DSCA	DescriptionAlpha [40] Alpha Description			This is optional column
8	F45511W	SARELTY	SeachAgentRelationshipType [2] (Search Agent Relationship Type)	A Search Agent is a user-defined query over an One World table. The Search Agent Relationship type represents the comparison criteria for a directive. Refer UDC 45/RT - Relationship Type below.		RE - Range (Exclusive)
9	F45511W	SAVALUE	SeachAgentValue [30] (Search Agent Value)			Value for SARELTY
10	F45511W	SALSTNB	SeachAgentNbrListElements [6] (Number of List Elements - Directive)
11	F45511W	SAFLAG	SeachAgentCopyFlag [1] (Search Agent Copy Flag)

F45511 - Search Agent Directives Detail

	Table	Column	DD item	Glossary	Others
1	F45511	SANAME*	SearchAgentName [10] (Search Agent Name)
2	F45511	DTAI*	DataItem [10] Data Item
3	F45511	SASEQVL*	SeachAgentValueSequence [6] (Search Agent Value Sequence Numver)	A Search Agent is a user-defined query over an One World table. The Search Agent Value sequence number represents the sequence in which the possible values of a directive are stored in the F45511 file.	For example, if you select
4	F45511	SARELTY	SeachAgentRelationshipType [2] Search Agent Relationship Type	A Search Agent is a user-defined query over an One World table. The Search Agent Relationship type represents the comparison criteria for a directive. Refer UDC 45/RT below.	UDC 45/RT
5	F45511	SAVALUE	SeachAgentValue [30] (Search Agent Value)	A Search Agent is a user-defined query over an One World table. The Search Agent Value is the value of the criteria. The value might be a single component, a range (composed of 2 values) or a list (composed of many values).	If column specified is date (e.g., F4072.EFTJ, EXDJ) value stored is always dd/mm/yyyy regardless User Profile settings for date format and date separator
6	F45511	DSCA	DescriptionAlpha [40] (Alpha Description)
7	F45511	SALSTNB	SeachAgentNbrListElements [6] (Number of List Elements - Directive)	Directive - Number of List Elements represents the number of elements in a directive list if the relationship type is "IN LIST" or "NOT IN LIST". This number will be stored in F45511 (Search Agent Directives Detail Table) for a given data item when sequence number is 1. This number is necessary to allocate memory for the dynamic select array that will be build when the Search Agent is invoked by an external application.
8	F45511	USER	UserId [10] (User ID)
9	F45511	PID	ProgramId [10] (Program ID)
10	F45511	JOBN	WorkStationId [10] (Work Station ID)
11	F45511	UPMJ	DateUpdated [6] (Date - Updated)
12	F45511	TDAY	TimeOfDay [10] (Time of Day)

F45510 - Search Agent Directives Header

	Table	Column	DD item	Glossary	Values are from	Default	Others
1	F45510	SANAME*	SearchAgentName [10] (Search Agent Name)	A name that identifies the query. The name is stored in the Search Agent Directives Detail table (F45511).	FC Search Agent Name in W45550A	Blank	Do not leave this value blank Search/Select from W45510D Case Sensitive
2	F45510	SADESC	SeachAgentDescription [40] (Search Agent Description)	The description of a user-defined search agent. The search-agent is a query over a specific table.	FC Search Agent Description in W45510F		Form W45510F is variable only which is to be populated when user come to this form based on table F4072.
3	F45510	OMWTBLNM	TableName999 [11] (Table Name)	n/a	FC Table Name in W45550A	F4072
4	F45510	SASECUR	SeachAgentSecurity [1] (Search Agent Security Code)	A code that indicates whether security restrictions exist for a search agent. Valid values are: Blank: No security restrictions exist. 1: Only the originator of the search agent can modify the search agent.	Check box for Security in W45510F		If you select check box the value 1 is to be populated.
5	F45510	SADIRNB	SeachAgentNumberDirectives [6] (Search Agent Number of Directives)	The number of directives or relationships that define a specific search agent. A is a user-defined query over a table.			Number of columns you have selected in W45510F. This is internally how programming set up filtering condition
6	F45510	SAMAXVL	SeachAgentMaxValueSize [6] (Search Agent Maximum Value Size)	A value that indicates the maximum possible size (in bytes) of a comparison value for a specific query. The comparison value can be a single value, a range of values, or a list of values.
7	F45510	SAADDSEL	SearchAgAdditionalSelects [6] (Search Agent Additional Selection)	The Search Agent Additional Selection represents the number of additional select elements that will be added to the select array that the Search Engine uses. Additional select elements are generated by the NL (Not in List) and the RE (Range - Exclusive) types of relationship in one Search Engine directive.
8	F45510	USER	UserId [10] (User ID)
9	F45510	PID	ProgramId [10] (Program ID)
10	F45510	JOBN	WorkStationId [10] (Work Station ID)
11	F45510	UPMJ	DateUpdated [6] (Date - Updated)
12	F45510	TDAY	TimeOfDay [6] (Time of Day)

In adding a new search agent the sequence tables written are,

Write F45511W: To give guide for user to select a specific columns, values and relationship
Write F45511: To store detail information for directive
Write F45510: To summarize detailed information

UDC 45/RT - Relationship Type

: This is to guide how business function F4072SearchEngine (B4500500, F4072 Search Engine) is constructing WHERE clause to filter data from F4072.

Codes	Description 01	Hard Coded	Example of Query
	BLANK	Y	n/a
<	LESS THAN	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 < 4242.000000 ) ORDER BY ADAST ASC,ADATID ASC
<=	LESS THAN OR EQUAL	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 <= 4242.000000 ) ORDER BY ADAST ASC,ADATID ASC
<>	NOT EQUAL	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 <> 4242.000000 ) ORDER BY ADAST ASC,ADATID ASC
=	EQUAL	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 = 4242.000000 ) ORDER BY ADAST ASC,ADATID ASC
>	GREATER THAN	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 > 4242.000000 ) ORDER BY ADAST ASC,ADATID ASC
>=	GREATER THAN OR EQUAL	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 >= 4242.000000 ) ORDER BY ADAST ASC,ADATID ASC
BW	RANGE (INCLUSIVE)	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 BETWEEN 4242.000000 AND 4245.000000 ) ORDER BY ADAST ASC,ADATID ASC
IN	IN LIST	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 IN ( 4242.000000,4245.000000 ) ) ORDER BY ADAST ASC,ADATID ASC
NL	NOT IN LIST	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 NOT IN ( 4242.000000,4245.000000 ) ) ORDER BY ADAST ASC,ADATID ASC
RE	RANGE (EXCLUSIVE)	Y	SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 > 4242.000000 AND ADAN8 < 4245.000000 ) ORDER BY ADAST ASC,ADATID ASC

Note:

In case you have defined more than 1 directives, which append additional statement with AND. For example, SELECT * FROM PRODDTA.F4072 WHERE ( ADAN8 = 4242) AND (ADCRCD IN ('USD' AND 'CAD')) ORDER BY ADAST ASC, ADATID ASC.
Depending on the relational keyword you select, the performance can be vary
All codes are hard coded so do not change any value above which result in undesired outcome

Error Implemenation in P45550 and P45510

Below error can be issued,

Error Code	Description	Cause	Resolution
0001	(error) Action Invalid CAUSE . . . The action code entered either is not one of the following codes or you are not authorized to perform this action. Valid action codes are: 'A' or '1' -Add; 'C' or '2' -Change; 'D' -Delete; 'I' or '4' -Inquiry. Some programs may not allow all of the above action codes, (refer to the specific program help instructions), or you may be secured from doing a particular action through action code security. RESOLUTION. 1) If performing a change or delete, you MUST first inquire. 2) Verify that the program allows the attempted action. 3) Verify that you are not prevented from using this action through action code security.	When cPriceApprovalRequired is ON and try to update F4072	This is generic error. Currently this error can be coming along with action code in calling a certain business function.
0002	(error) Record Invalid CAUSE . . . . The record being processed either already exists for an 'ADD' function or does not exist for an 'INQUIRY', 'CHANGE' or 'DELETE' function. RESOLUTION. . If you are attempting to inquire, change or delete a record you previously added, there may be data base problems in your production library. You should notify your data processing department.	Failed to insert data into F4072 SA Properties button clicked without having valid Search Agent	This is generic error which can be issued when DML statement is failed.
0013	(error) Entry Invalid CAUSE . . . . The two fields being processed are mutually exclusive. RESOLUTION. . Change one of the fields being processed.	szItemPriceGroup szCustomerPriceGroup, or szSalesDetailGroup in calling B4503000. In calling F4072 Write Price Adjustment Detail (B4500060 - F4072WritePriceAdjustmentDetail), cMode is not in (A, C, I, D)	Error can be issued either by B4503000 (F40941UpdateItemGroupIGID, F40942UpdateCustomerGroupCGID, F40943UpdateOrderGroupOGID) or by B4500060 (F4072WritePriceAdjustmentDetail) when input parameter for cMode is not A - Add, I - Inquiry, C - Change or D - Delete
073Q	(error) Column Does Not Exist Cause : Database operation failed because column does not exist in the table Resolution: Please contact your administrator to add the column to the table	Failed to get column information from table spec (e.g., glbltbl)	via B4500570 (GetTableNextColumn - Get Table Next Column Info). Check F4072.h and F98711 (Table Columns) and flush glbltbl.xdb and ddb where error is issued.
078D		JDB_OpenTable ()	Generic error when it fails to open table. Refer to <Document 1533578.1> E1: BSFN: How to Implement SELECT DISTINCT, SELECT ALL and function COUNT(*) through JDE APIs
078F		JDB_InsertTable()	Error can come in your trying to insert F4072W, F4072, F45511W, F45511, F45510 This is a generic error
078G		JDB_DeleteTable ()	Error can come in your trying to delete work files (F4074W, F45511W) This is a generic error code
078H		JDB_UpdateTable ()	Error can come in your update F4072, F45511W, F45511, F45510
078I		JDB_FetchKeyed ()	This API tries to get data from cache/memory
078J		JDB_SelectKeyed ()	This API tries to get data from database server
078S		JDB_InitBhvr ()	Refer to Unparing API section from <Document 1464687.1> E1: BSFN: Case Study on Memory Violation, Memory Corruption, Memory Overwrite, ACCESS VIOLATION and Zombie Kernel
1947	(error) Not Authorized to Object Cause........The user is not authorized to the object. Resolution...Contact your Data Processing department to obtain authority.	User not authorized to maintain current Search Agent in clicking "SA Revisions"	In W45510F, Security On is checked and SL User ID is different from User ID in F45510/F45511
3942	(error) Value Required Cause . . . . When the PTF field equals 'N', the PTF Library must be NONE. Resolution. . Enter NONE in the PTF Library Name field.	Search Agent is not entered and Table Name is not specified	In W45550A form when FC Table Name is not specified. This is generic error message which was inherited from World software.
4363	(error) Null Pointer CAUSE . . . . The pointer has a null value. RESOLUTION. . Check to be sure that pointer contains a value.	Failed to get Table Column Pointer through GetTableNextColumn in reading the table specification of F4072	This is generic error from multiple business functions.
45A1	(error) Invalid range CAUSE: The range entered is invalid. RESOLUTION: In List of Values Revisions, if the relationship is range, the value entered in the first line must be smaller than the value entered in the second line. Either change the values or change the relationship.		In W45510D, when data type (W9210.OWTP) is, 1 - Character 2 - String 9 - Numeric 11 - Date
45A2	(error) Search Agent name can't be blank. CAUSE: The Search Agent name is blank for ADD or COPY mode. RESOLUTION: Enter a valid non-blank, new value for the Search Agent name.		In W45510F, FC Search Agent Name is not specified.
45A3	(error) Invalid number of values entered. CAUSE: Invalid number of values were entered for range or single relationship. SOLUTION: The range relationship requires exactly two values; the single relationship requires exactly one value. Enter the correct number of values or change the relationship.		In W45510D, If relationship is range, number of rows must be 2 If relationship is single, number of grid rows must be 1
45A4	(error) User not authorized to Search Agent. CAUSE: Current user does not have authority to change this Search Agent. RESOLUTION: Either copy this Search Agent to change it or contact the data processing department.	User not authorized to change this Search Agent when Security is checked.	In W45550A, User click SA Revisions form exit to either modify existing Search Agent or add new Search Agent and Security On is checked but user ID recorded in F45510/F45511 is different from log on user ID.
45A5	(error) Invalid number of values entered. CAUSE: Invalid number of values were entered for range or single relationship. SOLUTION: The range relationship requires exactly two values; the single relationship requires exactly one value. Enter the correct number of values or change the relationship.		In W45510F, Search Agent Name is in use for Add or Copy mode. Either modify/revise existing search agent or change search agent name.
45A6	(information) &1 Records Selected - INFORMATIVE. CAUSE . . . . This Search Agent selected &1 records. RESOLUTION. . Search Agent selected records successfully.	After writing F4072W through F4072SearchEngine	This is informative message to show how many records are written into F4072W through Search Agent you have defined. This message is always being issued by B4500500 (F4072SearchEngine - F4072 Search Engine).
45A7	(warning) No Records Selected in &1 - WARNING. CAUSE . . . . The Search Agent did not select any records in &1. RESOLUTION. . Check the Search Agent criteria for validity or change the values to expand the search range.	After writing F4072W through F4072SearchEngine	Through B4500500 when Search Agent did not return any records. To have message '45A6' revise your search agent.
45B0	(error) Amount update type cannot be blank. CAUSE . . . . When you enter an amount to be updated, you must define the type of update (A - add-on amount, % - percent or $ - override). RESOLUTION. . Enter a type for the update or remove the update amount.	FVTR =< 0 MNQ =< 0	In your clicking Update Grid Only from W45550A, if QBE Factor value is not correct. Correct Factor Value in QBE or remove QBE filtering.
45B1	(error) 2nd and Short items not compatible. CAUSE . . . . The 2nd and short item numbers you entered in the update line do not describe the same item. RESOLUTION. . Define only one of them and the others will default (for example: if you enter the short item number only, the 2nd and 3rd items will be defaulted when the update grid only button is clicked.)	Update Item button Validate takes places based on QC (QBE values entered)	In W4550A, Issue error: Short Item Number and 2nd Item Number not compatible. Either remove one of them or both from QBE.
45B2	(error) 2nd and 3rd items not compatible. CAUSE . . . . The 2nd and 3rd item numbers you entered in the update line do not describe the same item. RESOLUTION. . Define only one of them and the others will default (for example: if you enter the 2nd item number only, the short and 3rd items will be defaulted when the update grid only button is clicked.)	Validate takes places based on QC (QBE values entered)	In W45550A, Issue error: 2nd Item Number and 3rd Item Number not compatible. Either remove both or one of them from QBE.
45B6	(error) Short and 3rd items not compatible. CAUSE . . . . The 3nd and short item numbers you entered in the update line do not describe the same item. RESOLUTION. . Define only one of them and the others will default (for example: if you enter the short item number only, the 2nd and 3rd items will be defaulted when the update grid only button is clicked.)	Update Item button Validate takes places based on QC (QBE values entered)	In W45550A, Issue error: Short Item Number and 3rd Item Number not compatible. Either remove one of QBE or both then press Find button again.
45BA	(error) Invalid Search Agent Table CAUSE: The Table in the Search Agent is not F4072. RESOLUTION: Either enter the correct table name when creating the Seach Agent or select a new Search Agent that is based on F4072.	(Find in W45550A), table name is not F4072. Currently this application only supports F4072.	In W45550A, in your clicking Find button, if FC Table Name is not F4072
45BF	(error) Search Agent Not Found CAUSE: The Search Agent entered does not exist in the Search Agent files (F45510, F45511). RESOLUTION: Either add the Search Agent to the Search Agent files (F45510, F45511) or enter a valid Search Agent name.	(Find in W45550A), user has entered search agent name but there is no definitions from F45510.	In W45550A in clicking Mass Maintenance, Search Agent name is specified. Before click Mass Maintenance, remove search agent name.
45MM	(warning) Can't update Item/Customer/Order Groups CAUSE.....Item, Customer, and Order Groups can't be updated using this application. RESOLUTION.....These columns won't be updated		In your clicking "Update Grid Only" in W45550A form either one of QBE columns are specified, - QC Customer Group - QC Item Group - QC Order Detail
45MMA	(warning) Can't update Adjustment Name CAUSE.....Adjustment Name can not be updated using the application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC Adj Name is specified. Remove QC Adj Name to avoid this warning message.
45MMB	(warning) Can't update Basis Code CAUSE.....Basis Code can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC B C is specified.
45MMC	(warning) Can't update Currency Code CAUSE.....Currency Code can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC Cur Cod is specified.
45MMD	(warning) Can't update Cost Method CAUSE.....Cost Method can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC Cost Meth is specified.
45MME	(error) Can't update Formula Name CAUSE.....Formula Name can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC Formula Name is specified.
45MMF	(warning) Can't update Free Goods Flag CAUSE.....The Free Goods Flag can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC F G is specified.
45MMG	(warning) Can't update VIUM CAUSE.....VIUM can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC VI UM is specified.
45MMH	(warning) Can't update Basket Parent ID CAUSE.....Basket Parent ID can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC Bskt. Parent ID is specified.
45MMI	(warning) Can't update VI Currency CAUSE.....Volume Incentive Currency can not be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC VI Cur is specified.
45MMJ	(warning) Can't update Number of Orders CAUSE.....Number of Orders can not be updated using this application. RESOLUTION..... This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC Number of Orders is specified.
45MMK	(warning) Can't update FV UM CAUSE.....FV UM cannot be updated using this application. RESOLUTION.....This column will not be updated.		In your clicking "Update Grid Only" in W45550A QC FV UM is specified.
PCACHEWARN	(warning) APRE is active The Accelerated Pricing Resolution Engine is active. Changes made to cached pricing tables may not be used in transactions until the cache is reloaded. The reload can be done in P4530 or R45391.	When CacheStatus is ACTIVE through Get Pricing Cache State (B4504650 - GetPricingCacheState)	In W45550A when you have implemented APRE is active. Refer to <Document 760588.1> E1: 45: Accelerated Pricing Resolution Engine (F4072, F4092, F40941, F40942, F40943) for APRE

Note: In case you wanted to debug error/warning/information by yourself, capture jasdebug.log and analyze it becaue a number of error messge is handled through event rule

Conclusion:

Understand Search Agent and make use of it
Do not press find button without specifying Search Agent because,

Excessive processing time by reading all data from F4072
Unnecessary errors

Truncate work file (or, temporary data repository) regular basis

F45511W (Search Agent Directives Work File)
F4072W (Price Adjustment Detail Work File)
These files can be remained as orphaned data by terminating session (either click Close button or Session timeout)