You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Adding Item Facility to Web Report causes report to fail

in Warehouse Management

Summary:

We are building a Commercial Invoice web report that requires pulling two facility-specific item attributes from the item_facility entity — cust_attr_2 (Reference Cost) and cust_attr_3 (Country of Origin) — scoped to two different facility contexts per line:

  • Shipping facility cost/COO — item_facility scoped to load.facility_id
  • Receiving facility cost/COO — item_facility scoped to ob_stop.shipto_facility_id

Adding item_facility as a data object causes the report to either run indefinitely or fail with:

ORA-12801: error signaled in parallel query server
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

What We Have Attempted

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!