Have you checked our new Android App!!! Please download and learn oracle at ease

November 22, 2014

Error in Pack Slip Generation during Ship Confirmation

bishnupc / / 3

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.

3 comments:

  1. 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.

    Contact 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 training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com

    LinkedIn profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

    ReplyDelete
  2. Hi this is abinaya i am having 3 years of experience as a java developer and i am certified. i have knowledge on OOPS concepts in java but dont know indepth. After learning oracle will be enough to get a good career in IT with good package? and i crossed Oracle Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks, abinaya

    ReplyDelete
  3. Hi this is abinaya i am having 3 years of experience as a java developer and i am certified. i have knowledge on OOPS concepts in java but dont know indepth. After learning oracle will be enough to get a good career in IT with good package? and i crossed oracle training chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks, abinaya

    ReplyDelete

Help us to know you

Do you like learnoracle.in

Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here