Archive | profile options RSS feed for this section

Error in Pack Slip Generation during Ship Confirmation

22 Nov

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.

To Query Profile option details for any user or responsibility

2 May

SELECT FPO.PROFILE_OPTION_ID,
      FPO.PROFILE_OPTION_NAME,
      FPOT.USER_PROFILE_OPTION_NAME,
      FPOV.LEVEL_ID,
      DECODE(FPOV.LEVEL_ID,
             ‘10001’,
             ‘Site’,
             ‘10002’,
             ‘Appllication’,
             ‘10003’,
             ‘Responsibility’,
             ‘10004’,
             ‘User’,
             FPOV.LEVEL_ID) LEVEL_TYPE,
      FPOV.LEVEL_VALUE,
      DECODE(FPOV.LEVEL_ID,
             ‘10001’,
             ‘Site’,
             ‘10002’,
             (SELECT APPLICATION_NAME
                FROM APPS.FND_APPLICATION_TL
               WHERE APPLICATION_ID =FPOV.LEVEL_VALUE),
             ‘10003’,
             (SELECT RESPONSIBILITY_NAME
                FROM APPS.FND_RESPONSIBILITY_TL
               WHERE RESPONSIBILITY_ID =FPOV.LEVEL_VALUE),
             10004,
             (SELECT DESCRIPTION
                FROM APPS.FND_USER
               WHERE USER_ID = FPOV.LEVEL_VALUE),
             FPOV.LEVEL_ID) LEVEL_VALUE,
      FPOV.PROFILE_OPTION_VALUE,
      FPOV.LAST_UPDATE_DATE,
      FPO.SQL_VALIDATION,
      TRUNC(FPOV.LAST_UPDATE_DATE),
      (SELECT DESCRIPTION
         FROM APPS.FND_USER
        WHERE USER_ID = FPOV.LAST_UPDATED_BY)UPDATED_BY
 FROM APPS.FND_PROFILE_OPTIONS       FPO,
      APPS.FND_PROFILE_OPTION_VALUES FPOV,
      APPS.FND_PROFILE_OPTIONS_TL    FPOT
WHERE FPOV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID
  AND FPOT.PROFILE_OPTION_NAME =FPO.PROFILE_OPTION_NAME
  AND FPOV.LEVEL_VALUE =
      (SELECT USER_ID FROM FND_USER WHERE USER_NAMEIN (‘305030341’)) –for user
  /*AND (FPOV.LEVEL_ID = 10003 AND
      FPOV.LEVEL_VALUE IN
      (SELECT RESPONSIBILITY_ID
          FROM FND_RESPONSIBILITY_TL
         WHERE RESPONSIBILITY_NAME LIKE ‘%%’)) –for responsibility*/
  /*AND UPPER(FPOT.USER_PROFILE_OPTION_NAME) LIKE ‘%WMS%TCP%’ — for profile option*/ 

Order Management: Profile Options

7 Jan

Order Management: Profile Options

During implementation, you set a value for each user profile option to specify how Order Management controls access to and processes data.

Profile Categories

Profiles have been categorized so that they can be easily classified or grouped. The following table displays the profile categories and the profile options that belong to each one. Some profile options belong to more than one category and are indicated in the table below.

Profile Category Name  Profile Option(s) 
Configurations OM: Allow model  fulfilment without configuration;
OM: Configuration Quick Save;
OM: Copy Model DFF to child lines;
OM: Included Item Freeze Method;
OM: Party Totals Currency;
OM: Use Configurator;
Customer Usage OM: Add Customer;
OM: Add Customer (Order Import);
OM: Create Account Information;
OM: E-Mail Required on New Customers;
OM: Party Totals Currency;
OM: Sales Order Form: Restrict Customers
Debug OM: Debug Log Directory;
OM: Debug Level;
OM: Generate Diagnostics for Error Activities;
Deployment OM: DBI Installation;
OM: Orders Purge Per Commit;
OM: New EDI Acknowledgment Framework;
OM: Printed Document Extension Class Name;
OM: Use Configurator;
Electronic Messaging OM: Change SO Response Required;
OM: Electronic Message Integration Event Sources
OM: New EDI Acknowledgment Framework;
OM: Order Accept State for XML;
OM: Run Order Import for XML;
OM: Send Acknowledgment for Change PO Response;
Forms UI OM: Add Customer;
OM: Administer Public Queries;
OM: Automatically Open Related Items Window;
OM: Contact Center Actions Menu Name;
OM: Cust Item Shows Matches;
OM: Display Actions Button vs. Poplist;
OM: Display Current Selections in Pricing/Availability;
OM: Enable Related Items and Manual Substitutions;
OM: Item View Method;
OM: Quick Sales Order Form: Auto Refresh;
OM: Quick Sales Order Form: Defer Pricing;
OM: Sales Order Form: Cascade Header Changes to Line;
OM: Sales Order Form: Refresh Method (Query Coordination);
OM: Sales Order Form: Restrict Customers;
OM: Sales Order navigation from Pricing/Availability form;
OM: Sales Orders Form preference;
OM: Scheduling Role;
OM: Show Line Details;
OM: Show Process Messages Flag;
OM: Use Configurator;
OM: View Cancel Lines;
OM: View Closed Lines;
OM: View Pricing & Availability Information in Related Items;
Fulfillment OM: Allow model fulfillment without configuration;
OM: Included Item Freeze Method;
OM: Over Return Tolerance;
OM: Over Shipment Tolerance;
OM: Population Of Buyer Code For Dropship Lines;
OM: Source Code;
OM: Under Return Tolerance;
OM: Under Shipment Tolerance;
OM: Automatically Interface Lines to IB on Fulfillment
Holds OM: Modify Seeded Holds;
OM: Prevent Booking for Line Generic Holds;
Invoicing OM: Interface freight tax code from line;
OM: Invoice Numbering Method;
OM: Set Receivables Transaction Date as Current Date for Non-Shippable Lines;
OM: View Intercompany AR Invoice
Item Usage OM: Customer Item Shows Matches;
OM: Enable Related Items and Manual Substitutions;
OM: Item Flexfield;
OM: Restrict Customer Items for Line Level Ship To Address;
Logistics OM: Sequence for TP Ship/Deliver Deadline;
OM: Source for TP Early Ship/Deliver Date;
Order Import OM: Add Customer (Order Import);
OM: Import Multiple Shipments;
OM: Unique Order Source, Orig Sys Document Ref Combination For Each Customer;
Payments OM: Commitment Sequencing;
OM: Credit Card Privileges;
OM: Preserve External Credit Balances
Portal UI OM: Customer Service Feedback;
OM: Customer Service Report Defect;
OM: Records On Summary Page For External Users;
Pricing OM: Charges For Backorders;
OM: Charges for included item;
OM: Charging Privilege;
OM: Discounting Privileges;
OM: Enable Group pricing for DSP lines;
OM: Item Change Honors Frozen Price;
OM: List Price Override Privilege;
OM: Negative Pricing;
OM: Promotion Limit Violation Action;
OM: Send Changed Lines to Pricing;
OM:Unit Price Precision Type;
OM: UOM Class for Charge Periodicity;
OM: Price Adjustment Modifier for AIA Order Lines
Returns OM: Customer Service Feedback;
OM: Customer Service Report Defect;
OM: Over Return Tolerance;
OM: Notification Approver;
OM: Return Item Mismatch Action;
OM: Return Unfulfilled Referenced Line Action;
OM: Under Return Tolerance;
Scheduling OM: Assign New Set For Each Line;
OM: Authorized To Override ATP;
OM: Auto Push Group Date;
OM: AutoSchedule;
OM: Enforce Shipping Method for Ship Sets;
OM: Schedule ATO Item Without BOM;
OM: Scheduling Role;
Security OM: Add Customer;
OM: Add Customer (Order Import);
OM: Administer Public Queries;
OM: Authorized To Override ATP;
OM: Cascade Service;
OM: Charging Privilege;
OM: Create Account Information;
OM: Credit Card Privileges;
OM: Discounting Privileges;
OM: List Price Override Privilege;
OM: Modify Seeded Holds;
OM: Scheduling Role;
OM: Authorized To Override ATP;
Service OM: Cascade Service;
Transaction Entry OM: Apply Automatic Attachments;
OM: Cascade Service;
OM: Configuration Quick Save;
OM: Copy Model dff to child lines;
OM: Default Blanket Agreement Type;
OM: Default Blanket Transaction Phase;
OM: Default Sales Transaction Phase;
OM: Default Salesrep;
OM: Display New Order After Copy
OM:Enforce check for duplicate Purchase Orders;
OM: Generic Update Constraints Apply to DFF?;
OM: Prevent Booking for Line Generic Holds;
OM: Return Item Mismatch Action;
OM: Return Unfulfilled Referenced Line Action;
Upgrade OM: Context Responsibility for Upgraded Orders;
OM: Notification Approver;

Navigate to System Administrator Responsibility

Profiles à System


Order Management: Profile Options

7 Jan

Order Management: Profile Options

During implementation, you set a value for each user profile option to specify how Order Management controls access to and processes data.

Profile Categories

Profiles have been categorized so that they can be easily classified or grouped. The following table displays the profile categories and the profile options that belong to each one. Some profile options belong to more than one category and are indicated in the table below.

Profile Category Name  Profile Option(s) 
Configurations OM: Allow model  fulfilment without configuration;
OM: Configuration Quick Save;
OM: Copy Model DFF to child lines;
OM: Included Item Freeze Method;
OM: Party Totals Currency;
OM: Use Configurator;
Customer Usage OM: Add Customer;
OM: Add Customer (Order Import);
OM: Create Account Information;
OM: E-Mail Required on New Customers;
OM: Party Totals Currency;
OM: Sales Order Form: Restrict Customers
Debug OM: Debug Log Directory;
OM: Debug Level;
OM: Generate Diagnostics for Error Activities;
Deployment OM: DBI Installation;
OM: Orders Purge Per Commit;
OM: New EDI Acknowledgment Framework;
OM: Printed Document Extension Class Name;
OM: Use Configurator;
Electronic Messaging OM: Change SO Response Required;
OM: Electronic Message Integration Event Sources
OM: New EDI Acknowledgment Framework;
OM: Order Accept State for XML;
OM: Run Order Import for XML;
OM: Send Acknowledgment for Change PO Response;
Forms UI OM: Add Customer;
OM: Administer Public Queries;
OM: Automatically Open Related Items Window;
OM: Contact Center Actions Menu Name;
OM: Cust Item Shows Matches;
OM: Display Actions Button vs. Poplist;
OM: Display Current Selections in Pricing/Availability;
OM: Enable Related Items and Manual Substitutions;
OM: Item View Method;
OM: Quick Sales Order Form: Auto Refresh;
OM: Quick Sales Order Form: Defer Pricing;
OM: Sales Order Form: Cascade Header Changes to Line;
OM: Sales Order Form: Refresh Method (Query Coordination);
OM: Sales Order Form: Restrict Customers;
OM: Sales Order navigation from Pricing/Availability form;
OM: Sales Orders Form preference;
OM: Scheduling Role;
OM: Show Line Details;
OM: Show Process Messages Flag;
OM: Use Configurator;
OM: View Cancel Lines;
OM: View Closed Lines;
OM: View Pricing & Availability Information in Related Items;
Fulfillment OM: Allow model fulfillment without configuration;
OM: Included Item Freeze Method;
OM: Over Return Tolerance;
OM: Over Shipment Tolerance;
OM: Population Of Buyer Code For Dropship Lines;
OM: Source Code;
OM: Under Return Tolerance;
OM: Under Shipment Tolerance;
OM: Automatically Interface Lines to IB on Fulfillment
Holds OM: Modify Seeded Holds;
OM: Prevent Booking for Line Generic Holds;
Invoicing OM: Interface freight tax code from line;
OM: Invoice Numbering Method;
OM: Set Receivables Transaction Date as Current Date for Non-Shippable Lines;
OM: View Intercompany AR Invoice
Item Usage OM: Customer Item Shows Matches;
OM: Enable Related Items and Manual Substitutions;
OM: Item Flexfield;
OM: Restrict Customer Items for Line Level Ship To Address;
Logistics OM: Sequence for TP Ship/Deliver Deadline;
OM: Source for TP Early Ship/Deliver Date;
Order Import OM: Add Customer (Order Import);
OM: Import Multiple Shipments;
OM: Unique Order Source, Orig Sys Document Ref Combination For Each Customer;
Payments OM: Commitment Sequencing;
OM: Credit Card Privileges;
OM: Preserve External Credit Balances
Portal UI OM: Customer Service Feedback;
OM: Customer Service Report Defect;
OM: Records On Summary Page For External Users;
Pricing OM: Charges For Backorders;
OM: Charges for included item;
OM: Charging Privilege;
OM: Discounting Privileges;
OM: Enable Group pricing for DSP lines;
OM: Item Change Honors Frozen Price;
OM: List Price Override Privilege;
OM: Negative Pricing;
OM: Promotion Limit Violation Action;
OM: Send Changed Lines to Pricing;
OM:Unit Price Precision Type;
OM: UOM Class for Charge Periodicity;
OM: Price Adjustment Modifier for AIA Order Lines
Returns OM: Customer Service Feedback;
OM: Customer Service Report Defect;
OM: Over Return Tolerance;
OM: Notification Approver;
OM: Return Item Mismatch Action;
OM: Return Unfulfilled Referenced Line Action;
OM: Under Return Tolerance;
Scheduling OM: Assign New Set For Each Line;
OM: Authorized To Override ATP;
OM: Auto Push Group Date;
OM: AutoSchedule;
OM: Enforce Shipping Method for Ship Sets;
OM: Schedule ATO Item Without BOM;
OM: Scheduling Role;
Security OM: Add Customer;
OM: Add Customer (Order Import);
OM: Administer Public Queries;
OM: Authorized To Override ATP;
OM: Cascade Service;
OM: Charging Privilege;
OM: Create Account Information;
OM: Credit Card Privileges;
OM: Discounting Privileges;
OM: List Price Override Privilege;
OM: Modify Seeded Holds;
OM: Scheduling Role;
OM: Authorized To Override ATP;
Service OM: Cascade Service;
Transaction Entry OM: Apply Automatic Attachments;
OM: Cascade Service;
OM: Configuration Quick Save;
OM: Copy Model dff to child lines;
OM: Default Blanket Agreement Type;
OM: Default Blanket Transaction Phase;
OM: Default Sales Transaction Phase;
OM: Default Salesrep;
OM: Display New Order After Copy
OM:Enforce check for duplicate Purchase Orders;
OM: Generic Update Constraints Apply to DFF?;
OM: Prevent Booking for Line Generic Holds;
OM: Return Item Mismatch Action;
OM: Return Unfulfilled Referenced Line Action;
Upgrade OM: Context Responsibility for Upgraded Orders;
OM: Notification Approver;

Navigate to System Administrator Responsibility

Profiles à System