发运确认停靠站错误

第一个问题:出现错误:没有为单据类别分配有效的序号
解决方法:解决方法:Note:  if the document category was not defined correctly,  there is a good chance that document sequences and sequence assignments were not defined correctly either.    In this case,  user will only encounter a new warning message at ship confirm, such as "A valid sequence  assignment does not exist",  and the shipping document will still not be printed.   Perform the following steps to set up the document sequence and the sequence assignments correctly:


A. Define Document Sequence:
1. Navigate to shipping->setup->documents->document sequences
2  Click on the Search icon, and limit your search to '%Shipping Execution%
3  All of the sequences valid for shipping execution are displayed
4  Check to see if there is an existing sequence meeting the following criteria:
   4.1 There is no end date, or the end date is a future date (the sequence becomes invalid when the end date is reached)
   4.2 Type is Automatic
   4.3 Initial Value is what you want for the first Bill of lading to have as its Bill of Lading number
5  If none of the existing sequences meet these criteria, create a new sequence which does meet your criteria by clicking on the New icon

B.  Define a document sequence assignment:
1 Navigate to shipping >setup->documents->assign sequences
   1.1  This is the form where you assign a specific sequence to a specific shipping report.
   1.2  If you found an existing document sequence in step A which meets your criteria,
          1.2.1  Search for application shipping transactions
          1.2.2  In the list returned, find a sequence which refers to category BOL (which you verified or created in the main section of this note)
          1.2.3  Select that sequence, and click on the Assignment tab
          1.2.4  In the assignment window, verify:
                 1.2.4.1 The sequence assignment you selected references the document sequence you verified or created in step A
                1.2.4.2 There is no end date, or if there is an end date, it is a date significantly in the future
                  (the sequence assignment becomes invalid when this end date is reached)
2  If you created a new sequence in step A, or if you did not find a usable sequence assignment in step 1.2 click on the new button and create a new sequence assignment. which meets the criteria defined in step 1.2.4

3. Retest your issue: Ship confirm any delivery using the document set " Ship Confirm Documents", and verify:
    3.1 You do not encounter the error message "A valid document category does not exist"
    3.2 A Bill of Lading report is generated for the delivery, and it has the BOL number specified as the initial value in the document sequence (step A)
就是在定义文档序列和分配时,发运管理系统中要有 BOL、MBOL、PKSLP,并分配了序列,选择了分类帐。

若是第二个错误:意外错误:例程 WSH_NEW_DELIVERY_ACTIONS.setInTransit 出错,Oracle 错误 - -29280
ORA-29280: 目录路径无效
ORA-06512: 在 "SYS.UTL_FILE", line 41
ORA-06512: 在 "SYS.UTL_FILE", line 478
ORA-06512: 在 "APPS.ADS_UTIL_PKG", line 22
ORA-06512: 在 "APPS.ADS_WSH_DELIVERY_DET_TRG1", line 67
ORA-01403: 未找到任何数据
ORA-04088: 触发器 'APPS.ADS_WSH_DELIVERY_DET_TRG1' 执行过程中出错
解决方法就是你把这个'APPS.ADS_WSH_DELIVERY_DET_TRG1' 触发器取消掉:
1. 用apps帐号登录SQLPLUS
2. SQL>alter trigger
ADS_WSH_DELIVERY_DET_TRG1 disable;
3. 重新测试一下
posted @ 2012-02-28 23:16  郭振斌  阅读(1491)  评论(0编辑  收藏  举报