Home » Applications » Oracle Fusion Apps & E-Business Suite » Excise Invoice number Skipping at regular interval (11.5.10.2)
Excise Invoice number Skipping at regular interval [message #357844] Thu, 06 November 2008 22:24 Go to next message
dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member

Hi All ,

We have migrated from 11.5.7 to 11.5.10.2 recently in the Month of August 2008. Since then excise invoice no is skipping on a regular interval although the sequence is set as gap less and (increment by 1) as it was in the previous version (11.5.7).
We do not have any work around for this problem.

Pls guide

Regards,

Dhrubajyoti Nath


Re: Excise Invoice number Skipping at regular interval [message #358286 is a reply to message #357844] Mon, 10 November 2008 09:14 Go to previous messageGo to next message
oteixeira
Messages: 33
Registered: May 2007
Member
Hello.

Find the name of the sequence you are using. Open an sql session.
SQL>select db_sequence_name from fnd_document_sequences where name = <the name you found>

This will return your db_sequence_name, then:
SQL>alter sequence <your db_sequence_name> nocache;

This will stop the system to skip numbers.

Octavio
Re: Excise Invoice number Skipping at regular interval [message #358447 is a reply to message #358286] Tue, 11 November 2008 06:45 Go to previous message
dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member


On further investigation in the matter (Excise Invoice number Skipping), I have found that all the skipped excise invoice numbers in case of outbound dispatches from RFG warehouse have been used in RTV process by Stores department.

Now please let me know how to segregate the Excise invoice serial number of both the process as outbound is using FG inventory for dispatches while RTV (return to vendor) are using purchased items return to vendor.

Also please let us know is this necessary to maintain a single set of Excise invoice across the same Org_id.

Regards,

Dhrubajyoti Nath
Previous Topic: Move_order_line_id not created when order is booked
Next Topic: OM Shipping Exception Error
Goto Forum:
  


Current Time: Sat Dec 10 11:00:23 CST 2016

Total time taken to generate the page: 0.04790 seconds