1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Is there any programmers to find out the duplicate invoice entries ? What are those?

Discussion in 'Oracle Apps Technical' started by ramprasad.cgs, Jan 13, 2015.

  1. ramprasad.cgs

    ramprasad.cgs Active Member

    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    100
    Is there any programmers to find out the duplicate invoice entries ? What are those ?
     
  2. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Re: Is there any programmers to find out the duplicate invoice entries ? What are tho

    Hi,

    Oracle will not allow duplicate invoice entries to be made. invoice_id is unique in the system (AP_INVOICES_ALL).

    However different vendors can have same invoice number. i.e (vendor_id, invoice_num) combination is unique, therefore no duplicate.
     
  3. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Re: Is there any programmers to find out the duplicate invoice entries ? What are tho

    Hi,

    The "standard" duplicate invoice is already detected/controlled and not allowed in Oracle EBS (AP) - like Yowan mentioned above.

    If Oracle EBS has allowed "duplicate" invoices (as per your definition), it can't be above case.

    So, what do you mean by duplicate invoice ?
    What is the criteria you use to decide if an invoice is a duplicate or not ?

    Once you identify the fields which are supposed to be part of your key, then you can build up your query based on AP_INVOICES_ALL.

    General queries to detect duplicates can be found by searching on this site or googling around. Lots of examples have been posted in many sites.

    Have a look at following link, for example, which is similar:
    http://www.club-oracle.com/forums/how-to-create-duplicate-invoice-report-t1140/