Information

Title	Error A1327 : Could not access pack information from pack tables.

Summary	Unable to take a Worklist line into the Worksheet without getting an error A1327.

URL Name	ErrorA1327---Could-not-access-pack-information-from-pack-tables

Resolution

Diagnose:

A.)
In JDA Allocation double-click the WorkList line to show the shape associated with the WorkList line.
In case no shape information is available, the message "There are no details available for this WorkList line." is shown.

B.)
Verify via SQL Plus

1. Determine the corresponding shape table for the merchandise shape type in question. If you are unsure which table it is, first identify the shape type column value in the Worklist for that Worklist key, then go to Step 10 of Database Setup to determine which shape table to query.
2. Execute the following query in SQL Plus. Replace the items in chevrons with the correct values:

SQL> select * from where wl_key = ;

=> This should show the same information as A.)

Resolution:

Use the host interface to resend the WorkList and shape table information for the problematic WorkList keys.
If using the MMS-Allocation interface, you can choose to do this via a Worklist update (aalwrk) or let the nightly rebuild (aalrwk) take care of it.

Products	Allocation

Module	Worklist

Version	All

Error Message Code

On screen (GUI) messages:
Error A1327 : Could not access pack information from pack tables.
Error A1327 : There are no details available for the WorkList key(s) <91>

aamdebug.log: (recorded whilst whilst running auto-allocation, level #2 Trace)
06 Jun 17 12:24:33 - PID:0xf94,TID:0x340 SQL> SELECT STATUS_CODE, SHAPE_TYPE FROM WORKLIST WHERE AA_JOB_NBR = '510'
06 Jun 17 12:24:33 - PID:0xf94,TID:0x340 SQL> SELECT DISTINCT bulk_pack_flag FROM unique_key_header WHERE mer_type = 3
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (B) CTarget::OnGotoWorksheet()
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 Selected WorkList Line(s)
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (T) CBabyICE::DoGotoWorksheet() for WL Keys [91]
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (B) IceCmd::OnActionsAllocate()
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (B) CIceApi::ActionsAllocate()
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (B) CIceApi::IsAvailableForAlloc()
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 SQL> SELECT ALLOC_NBR, WL_KEY, STATUS_CODE, TROUBLE_CODE, SHAPE_TYPE, AA_JOB_NBR, USER_ID FROM WORKLIST WHERE WL_KEY=91
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 STMT> BEGIN TRANSACTION
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 SQL> SELECT WL_KEY FROM WORKLIST WHERE WL_KEY = 91 FOR UPDATE
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 SQL> SELECT BULK_PACK_FLAG,TABLE_NAME FROM UNIQUE_KEY_HEADER WHERE MER_TYPE = 3
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 SQL> SELECT DISTINCT PACK_COLOR.WL_KEY FROM PACK_COLOR WHERE PACK_COLOR.WL_KEY IN (91)
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (E) CIceApi::ActionsAllocate() - return value = 79
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 JDA Allocation 8.2 (Build 4).
06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 Function IsAvailableForAlloc() line 1445.
SQL error (from IceOutputErrorMessageEx2(), line 317
SQL failure:
'RetVal[79], Type[ActionsAllocate], WL Key[91]
ApplicationInfo[There are no details available for the WorkList keys(s) 91]
').

06 Jun 17 12:24:33 - PID:0xf94,TID:0x15c4 (T) Error A1327 : There are no details available for the WorkList keys(s) 91

when run via auto-allocation:

AA$BATCH_HEADER.STATUS & AA$BATCH_DETAIL.DESCRIPTION also showing: "Error A1833 : There is a problem with the shape of at least one of the packs that you have selected. Please contact your administrator."

Cause

WorkList key not having related shape table information.
When Allocation attempts to build the Worksheet matrix for that WorkList line it can't because it does not find the information it needs to complete the task.

Additional Information

Publication Status	Published