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 Option: Sequential Numbering
Value: Always Used
Level: Application
Application Level values: Shipping 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.
I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 1000+ Professionals Most of them are Working in Real Time now.
ReplyDeleteContact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at [email protected] | [email protected] | +91 – 9581017828 | http://www.oracleappstechnical.com
LinkedIn profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/