Payables and Cash Management - EBS (MOSC)

MOSC Banner

Invoice Number Check

edited Jul 1, 2010 7:49PM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered
Dear All,         As there is seeded functionality in Oracle Payables to control duplication of Invoice Number and will not allow to enter an invoice with same details.
        Normally users commit some mistakes then cancel the initial invoice and by specifying some special characters like giving dot,space they reenter invoice but this practice is needs to be controlled in proper way.
        Please suggest how can we achieve by which some alert goes to Manager that similar details are re-entered.For eg:-

select * from ap_invoices_all
where invoice_num like '%105794%'
and vendor_id=2034

10006 2/11/2003 9:35:59 PM 1026 2034  105794
10000 2/11/2003 9:35:59 PM 1026 2034 105794
10004 2/11/2003 9:35:59 PM 1026 2034 CHQ NO. 105794

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center