Purchasing

Get Involved. Join the Conversation.

Topic

    Amy Chan
    Define value set with bind variableAnswered
    Topic posted March 14, 2019 by Amy ChanSilver Medal: 2,000+ Points, tagged FAQ, Financials, Fusion, How-To, Orders, Setup 
    205 Views, 11 Comments
    Title:
    Define value set with bind variable
    Summary:
    Define value set with bind variable
    Content:

    I have a requirement to define a value set in PO Distribution level and such value always the same as the PO charge account segment3.

    SELECT cc.segment3 DEPT,

     FROM po_distributions_all po_dis,

                 gl_code_combinations cc

     WHERE po_dis.CODE_COMBINATION_ID = cc.CODE_COMBINATION_ID

     and        po_dis.po_distribution_id = ?????? (screen UI)

    Best Comment

    Niamath Jeddy

    I think ability to use parameters in  value set definitions is currently supported for requisitions alone in the procurement family.

    I do not think it is supported yet in purchasing screen.

    Please refer below note for requisitions alone

    Configuring Descriptive Flexfield Segments With Requisition Parameters (Doc ID 2303017.1)

    Regards,

    Niamath

    Comment

     

    • Niamath Jeddy

      I think ability to use parameters in  value set definitions is currently supported for requisitions alone in the procurement family.

      I do not think it is supported yet in purchasing screen.

      Please refer below note for requisitions alone

      Configuring Descriptive Flexfield Segments With Requisition Parameters (Doc ID 2303017.1)

      Regards,

      Niamath

      • Amy Chan

        Thanks Niamath,

        It is very useful..... also I have searched similar functionality in AP invoice but couldn't find any.

        Please share if you have.

         

    • Suman Guha

      If it's always equal to the value of an already captured field, wondering why you need to capture it separately in yet another field.

    • Ivan Pena

      Hi Amy,

      As pointed out above, Purchasing Cloud currently does not support any DFF parameters. Wondering how do you plan to use this value, as there might be other ways to achieve the same.

      Ivan 

      • Amy Chan

        Hi Ivan,

        I will put this value in PR instead of PO (no choice). Please share if you have any ideas to achieve the same in Purchasing.

        Thanks.

         

        • Ivan Pena

          Hi Amy,

          My question was what will you be using this value for? (e.g, to drive approvals? print on the PO PDF?) to see if the same end result can be achieved by other means. 

          Ivan

          • Amy Chan

            Hi Ivan,

            The purpose of this value is to drive the AP invoice approval. Let me explain more.

            Our invoice approval should base on the PO charge account (third segment value which is our Business Unit, not balancing segment). However, I was told (by Oracle consultant) the BPM invoice approval cannot get the value from PO charge account to derive the AP invoice approval.

            This is show stopper and sucking here for a while.

            Please share your thought.

            • Ivan Pena

              Hi Amy,

              Wondering why the PO charge account is different from the Invoice distribution account? Guess you are using accrue on receipt and the account on the invoice distribution is the accrual account instead of the charge account? 

              If both the PO and invoice account are the same, refer to the example on page 9 of the document attached to note 2207905.1 which shows how to drive invoice approvals based on the invoice distribution account.

              Ivan

              • Amy Chan

                Hi Ivan,

                Yes. We use Accrue on receipt.

                Do you have any ideas to resolve this?

                • Ivan Pena

                  Hi Amy,

                  Note charge account is not available as a parameter for the Requisition DFF, so you won't be able to carry the account value from the requisition DFF to the PO DFF to the Invoice DFF.

                  I cannot think of a solution right now. I suggest you post the question to the Financials forum, so people more familiar with the invoice approval workflow can help you,

                  Ivan