发运确认停靠站错误

第一个问题:出现错误:没有为单据类别分配有效的序号
解决方法:解决方法: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. 重新测试一下
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值