ERROR for defining document sequencing number over 8 digits

ERROR for defining document sequencing number over 8 digits

Problem:

While creating an invoice, after entering header level when we will click on line, the following error through

Solution :

Actually when we have defined document sequence for AP invoice, there actually we should not define document sequence number more than 8 digits which are not recommended by oracle.

 
System Administrator => Application => Sequential Numbering => Define

ORA-1455 error message is caused by a document sequence setup with sequence values higher than 8 digits.

To get this functionality an Service Request (SR) needs to be logged.
To correct the present data use the instructions found in Note:210440.1


As per Bug:1218782, clients on AP can apply one of the following patches:

1) Patch:8506412 -> delivers apiimptb.pls 115.231 (Payables Invoices Import package)

2) Patch:1218782 -> delivers apiimptb.pls 115.222 (Payables Invoices Import package)  

                                             

 Find the last number used by the sequence reported in the log file from the Journal Import process.

  select sequence_owner, sequence_name, min_value, max_value,

         increment_by, cache_size, last_number

  from dba_sequences

  where sequence_name like '&sequence_name

 Identify the document sequence with problems.

 select a.doc_sequence_id, a.name,a.start_date, a.initial_value,

        b.start_date, b.end_date, b.category_code, b.set_of_books_id

 from fnd_document_sequences a, fnd_doc_sequence_assignments b

 where a.doc_sequence_id = b.doc_sequence_id

 and a.application_id=b.application_id

 and a.db_sequence_name = '&sequence_name'

 Disable the document sequence.

 Using a GL responsibility:

 (N) > Setup > Financials > Sequences > Assign

 Define a new document sequence if necessary.

 Using a GL responsibility:

 (N) > Setup > Financials > Sequences > Define