Wednesday, 15 July 2015

Error in Pack Slip Generation during Ship Confirmation

Pack Slip Generating Issues

During Ship confirmation, below error is coming and Pack Slip is not generating

Error

Error: There is an error generating/validating the sequence number. Please check the assignments are defined and are valid.
------------------------------------
Warning: Pack Slip information could not be automatically created for delivery 115506201.
------------------------------------
Error: There is an error generating/validating the sequence number. Please check the assignments are defined and are valid.
------------------------------------
Warning: Bill of Lading information could not be automatically created for Delivery 115506201.
------------------------------------
Submitted 1 out of 1 documents for this document set. (REQ_IDS=293613)
------------------------------------
Warning: Failed to submit document set for delivery 115506201
------------------------------------
Interface Trip Stop request 293614 has been submitted
------------------------------------
Warning: 1 deliveries will be marked as In-Transit/Closed.

Issue:

This order will be able to ship confirm, if re-queried but Pack Slip will not be generated.

Solution:

As in this case, this is not able to properly generate the sequence number, it cannot insert record into WSH_DOCUMENT_INSTANCES table
In most business, Delivery Name been used as the pack slip number.
So for every pack slip document, data being inserted into the table with entity_id as the delivery name.
So as in this case, it is not able to generate the sequence number, this will not be inserted in the table and pack slip canot be generated.
So for this issue, the solution is to do the below profile option setup in following level
Profile OptionSequential Numbering
ValueAlways Used
LevelApplication
Application Level valuesShipping Execution and Order Management
If you don’t want to use the same value across all sites, then you can do the setup at specific responsibility levels too.

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete