2. Create goods shipment
- Short description:Create a goods shipment from a sales order
- Steps:
- Login as userA
- Go to Sales management->Transactions->Create shipments from orders
- Select the sales order and click process
ERROR=ORA-20000 : inline 10productWithoutAttributeSet@
成功(データ 依存?)
Process completed successfully
Order No. 50008 -> Shipment No. 500000- COMPLETE SHIPMENT CREATED;
Order No. 50008 -> Shipment No. 500000- COMPLETE SHIPMENT CREATED;
- Issues to verify:
- The sales order must be disappear
- Go to Goods shipment and see that it is created
- Move to Lines tab and verify the link "Sales Order Line" is related to the correct one
https://issues.openbravo.com/view.php?id=2126
返信削除列の不足
確認用失敗監査
select 'audit execute on erp.'||object_name||' by access whenever not successful ;' from dba_objects where owner='E
RP' and object_type='PROCEDURE' ;
select 'audit execute on erp.'||object_name||' by access ;' from dba_objects where owner='ERP'and object_type='PROCEDURE' ;
返信削除INSERT INTO M_INOUTLINE (M_INOUTLINE_ID, LINE, M_INOUT_ID, C_ORDERLINE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, M_PRODUCT_ID, C_UOM_ID, M_LOCATOR_ID, MOVEMENTQTY, DESCRIPTION, ISINVOICED,QUANTITYORDER,M_PRODUCT_UOM_ID, M_ATTRIBUTESETINSTANCE_ID) VALUES (0 , 0 , 0 , 0 , 1 , 1000000 , 'Y', NOW(), 0, NOW(), 0, 100,1000007 , 1000000 , 1000000 , 1000001 , 'N', 1000002 , 10 , 1000002 )
返信削除*
行1でエラーが発生しました。:
ORA-01403: データが見つかりません。
ORA-06512: "ERP.M_IOLINE_CHK_RESTRICTIONS_TRG", 行31
ORA-04088: トリガー'ERP.M_IOLINE_CHK_RESTRICTIONS_TRG'の実行中にエラーが発生しました