Payables & Cash Management

Get Involved. Join the Conversation.


    Beth Bleijie
    Use a one-time supplier again (R13)
    Topic posted August 22, 2018 by Beth BleijieBronze Trophy: 5,000+ Points, last edited January 30, 2019, tagged Financials, General Ledger, Payables 
    719 Views, 9 Comments
    Use a one-time supplier again (R13)
    When looking at a "one-time" supplier the address and site have cleared (R13)

    A one-time supplier has the address and site data cleared to blank. (R13)

    I want to use a one-time supplier again, and if I try to create an address I can't use the same Address Name, even though the old one doesn't exist.  I get this message:
    A record with the value MAIN-PAY already exists. Enter a unique value.

    So, what is the function and purpose of a "one-time" supplier?  And why does it do this with the address?




    • Lori Culp

      This is interesting.   How long have you been on R13?


    • Beth Bleijie

      We've been on R13 about 4-5 weeks now.

      Not all it is cracked up to be, at this point.  Many issues, big and little; I feel like a guinea pig.

    • Felix Beaudoin

      I had a similar issue in AR with Salesperson where we deleted the record and it indicated that we could not use the same number again. Seems to be the same type of issue you are facing with the record for your supplier. Some tables in Oracle give you the option to "Delete" but when I opened an SR with Oracle, they indicated that the "Delete" functionality does not truly erase the record. It simply makes it inactive/end dated in the back-end so you still cannot use the same identifier twice.
      You can try querying the tables in the back-end to see if this is truly the case. If it is still there, you will not have any other choice than to use a different name.

    • Logan Wacker

      As a friendly FYI - its next to impossible to delete a row out of Oracle Cloud SaaS. As Felix points out, conceptually, you are inactivating a row by end dating it, and then most views, prompts, processes reference active configuration. One Time Supplier as a concept essentially serves as 'dummying out' required supplier fields so a one time AP payment can be made for whatever the use case is. Can you use one time payment instead to achieve the same result?

    • Kathryn Santello

      Hi Beth, 

      At what point did the supplier record become unavailable? We are trying to use one-time supplier but the suppliers are not moving to the inactive status after they are fully paid. 


      • Beth Bleijie


        I'm not sure at what point they became unavailable.  We've only been on Oracle for about 9 months, so we're still struggling with a lot of things. This is one of those things we were taught we could use (making a supplier "one-time") but don't really know all of the ins and outs.

      • Lori Culp

        Hi Beth,


        Did you get any answers on when they become inactive and if there is a process to run to put them in this status?

        • Beth Bleijie

          Hi Lori,

          I haven't really followed up on this, so I'm afraid I can't answer your questions.

          This is one of our smaller problems, and other Oracle problems are keeping us pretty busy.

          I hope to get back to this eventually, but not sure when.


    • Beth Bleijie

      So I've come across this again.  I want to void and replace a check to a one-time supplier, but can't seem to bring up the Site for the Supplier.

      I have deleted the Supplier's Inactive date, so the Supplier is Active again.

      I have deleted the Supplier's Address' Inactive date, so the Address is Active again.

      But I cannot get a Site to come up for this reactivated Address.

      Only solution I can see is to create a new Address for the reactivated Supplier, then I have a Site I can work with.

      I'm curious if anyone has discovered in the last six months how this is really supposed to work.