How to define oracle fusion gapless custom sequence at Ship Confirm Form Level

Fusion Generate Gapless Custom Sequence at

Ship Confirm Form Level

Requirement: As Oracle fusion, ship-confirm level shipment number sequence having a random seq. generate nature. We have required to assign a unique sequence number to shipment transaction.


Goto Home > Setup and Maintenance

Select Manufacturing and Supply Chain Material Management.

 

    1)      Select the Shipping tab from the left panel. 

    2)      Select ALL Task from LOV

Select  ‘Manage Shipping Document Sequences’. ·         Before creating shipping document sequence, create a sequence category.   ·         Go to > Setup and Maintenance > Search > Manage Document Sequence Category.
Click on Search.
Create Document New Sequences.
Add details as per below screenshots.   Assign Newly created Document Sequence with Legal Entity. Now we have to assign the following Document Sequence in shipping parameter window. Shipping Document Job Set Rule. ·         Create Shipping document Job set as per below screenshot              Define Ship Confirm Rule:- ·         Define Ship confirm rule and assign this to manage shipping parameter Goto Home > Setup and Maintenance > Manufacturing and Supply Chain Material Management.            1)      Select the Shipping tab from the left panel.      2)      Select ALL Task from LOV      3)      Select ‘Manage Shipping Parameter’
Now Create SO transaction and create Ship Confirm for the same. Now Packing Slip Number (Which is in sequence in reference of sales order) automatically generated at Ship Confirm Level. You can get that value from backend by using the following query. Shipment Number = Delivery_id = 15016 SQL Query: select delivery_id,packing_slip_number from wsh_new_deliveries where packing_slip_number is not null and delivery_id=15016

Output:

 

How to define custom sequence at DFF attributes level - Oracle Fusion

Fusion: Define Custom Sequence with DFF attributes

Goto Home > Select Setup and Maintenance Icon

 

Select Manufacturing and Supply Chain Material Management.

 

    1)      Select the shipping tab from the left panel.

    2)      Select ALL Task from LOV

 

Select ‘Manage Shipping Descriptive Flexfields’

 

Select the Search Button to find all available option.

Select Shipment for Edit.

 

Enter Details as per the screenshots

 

For Add or update Global Segment details

 

Default Value:

select trim(nvl(to_char(max(to_number(attribute1))+1,'00000000'),'10000001')) xx from wsh_new_deliveries where attribute1 is not null

and to_number(attribute1) >= 10000000

and REGEXP_LIKE(trim(attribute1), '^[[:digit:]]+$')

 

Now when you complete ship confirms process, it will automatically generate the sequence and insert into attribute1 value.

(Note: Sometimes due to browser cache issue sequence number will be duplicate)