My Oracle Support Banner

R12:JL:AP: User Defined Document Category Populated on Supplier Site Is not Showed at Invoices (Doc ID 1624352.1)

Last updated on JUNE 12, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


The invoice is not stamped with the correct document category, which is user defined and populated on the supplier site record.

Expect to have the correct document category stamped on the invoice

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Italian localization
2. Path: Invoices -> Entry -> Invoices
3. Query an invoice

The invoice is not stamped with the correct document category, which is user defined and populated on the supplier site record.
This issue is only occurring for the invoices that are created and assigned the user defined document categories through the supplier,
others using the seeded document categories work fine.

The issue occurs as soon as invoice is saved, Voucher Number is assigned which has wrong sequence number.

The main issue is that the document category assigned on the supplier site is not assigned to the invoice.
Document category assigned on GDFF on supplier site (i.e. UL_IT_INVOICE) is not being assigned to the invoice when created and saved.

Although Document Categories of UL_IT_INVOICE and UL_ECC_INVOICE have been defined and assigned to supplier sites,
document categories are not being assigned accordingly to the invoices.
It appears that the document category for standard invoices is incorrectly being assigned to these Invoices.
When entering new invoice, sequence number does not start with 1, it starts with 28767 series which was assigned
to standard invoices instead of UL_IT_INVOICE and UL_EC_INVOICE.

In accordance with Italian fiscal purpose the first invoice booked within an year should have sequence number 1.
This sequence number should be the same value of the print sequence number on the VAT book.

See below the first invoices booked in Jan 2013 as they appear on the VAT book.
The below sequence number each year was reset to 1 by UL IT into respectively:

• UL_IT_INVOICE for domestic invoices
• UL_EEC_INVOICE for foreign invoices

The supplier site setting is UL_IT_INVOICE, but the invoice doc category is "Standard Invoice" and it should be UL_IT_INVOICE.

Setting up the default document category in GDF for Italy at supplier's site, and entering an invoice,
even though the defaut category is setup it is not assigned to the invoice as expected.
 The category for standard invoices is being assigned instead of UL_IT_INVOICE or UL_EEC_INVOICE.

For already entered invoices, if they have saved and completed, then the user should reenter invoices,
using new document sequences if needed (due to legal restrictions in Italy).
The user expects a data fix as the sequence should start with 1 for the first invoice entered for the year,
due to govermnent requirement.

The issue has the following business impact:

Italy Users are unable to create invoices with the correct document sequence numbering for government reporting purposes.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.