Purchasing

Get Involved. Join the Conversation.

Topic

    Niamath Jeddy
    BPA backed PO Creation (FBDI) : Line Price Logic
    Topic posted July 17, 2019 by Niamath JeddyGold Trophy: 10,000+ Points, tagged Agreements, Orders 
    92 Views, 9 Comments
    Title:
    BPA backed PO Creation (FBDI) : Line Price Logic
    Summary:
    BPA backed PO Creation (FBDI) : Line Price Logic
    Content:

    Hi,

    • I am using the FBDI method to create a PO
    • PO is backed by a BPA (source agreement columns are populated at PO line level)
    • When the PO is created, it is observed that the
      • PO Line price specified in PO line FBDI template is not used
      • The PO Line price is also not taken as per the quantity price breaks
      • The PO line price is taken from BPA line.

    Shouldn't the price be taken as per the slab instead of BPA line price?

    Also, in case the 'Allow price override' flag of BPA is 'Y', then shouldn't the price specified in PO line FBDI template be used ?

    If anyone has loaded legacy POs (referencing BPA with price breaks), can you share your experience?

    Also requesting some points from product management on this feature.

    Please refer below snapshot.

    Regards,

    Niamath

     

     

    Image:

    Comment

     

    • Nitin Katare

      Hi Niamath,

      From the above, would your expectation be as follows? Please comment on each of the 3 points below.

      1. For line 1 on the PO FBDI template for qty of 10 where the price is $7 and is not to be derived from a BPA, the Source Agreement Number and Source Agreement Line Number fields should be blank. This implies that this PO line is not coming from any specific BPA. Is this case, with these 2 fields as null, after import, the price should be $7

      2. For line 2 on the PO FBDI template, as you have mentioned a price of $3, is your expectation that the price should be $3 after import (that this price overrides any other price coming from the BPA)? Would the Allow Price Overide flag be checked in the PO Import template?

      3. For the 3 case for importing a quantity of 60, since you have specified a null value in price, the system takes into account the BPA Line price of $ 4. It does not look at price breaks, but, looks only at the BPA line price for the item. This is happening as per design and you are getting a value of $4. Is this your expectation given that the import program does not take into account the price breaks during import.

      Thanks

      Nitin

    • Niamath Jeddy

      Nitin,

      1. For line 1 on the PO FBDI template for qty of 10 where the price is $7 and is not to be derived from a BPA, the Source Agreement Number and Source Agreement Line Number fields should be blank. This implies that this PO line is not coming from any specific BPA. Is this case, with these 2 fields as null, after import, the price should be $7

      • This is a case where the PO is based on the BPA. BPA has 'Allow override flag =Y' and hence the PO has a different price than the BPA one. 

      2. For line 2 on the PO FBDI template, as you have mentioned a price of $3, is your expectation that the price should be $3 after import (that this price overrides any other price coming from the BPA)? Would the Allow Price Overide flag be checked in the PO Import template?

      • This is a clean case. PO qty is 40 which falls in BPA 2nd slab whose price is 3. The PO price is also 3. Hence, after import, price should have been 3. However, Oracle seems to be stamping a price of 4. I am trying to understand the reason behind it.

      3. For the 3 case for importing a quantity of 60, since you have specified a null value in price, the system takes into account the BPA Line price of $ 4. It does not look at price breaks, but, looks only at the BPA line price for the item. This is happening as per design and you are getting a value of $4. Is this your expectation given that the import program does not take into account the price breaks during import.

      • Should it not respect the price break and take 2 as the price since 60 qty falls in that slab? If i do this on UI, it will take the price break price. Why is the behavior different for FBDI import? Why does the program not take price breaks into account during import?

      Regards,

      Niamath

      • Nitin Katare

        Hi Niamath,

        Thanks for the clarification. I am in the process of getting more insight internally. Will revert once I know more.

        From my understanding:

        1. Case 1 - should have returned $7 as the allow price override flag is checked.

        2. Case 2 - should have returned price $3 as long as you have mentioned this on the PO line price in the import template and allow price override as Y. (Same as Case 1). As far as I know price breaks are not supported in the FBDI template.

        3. Case 3 - The FBDI PO import does not honor price breaks at this time. This is an ER and ideally, in most cases, functionality available in the UI and in the FBDI Import should match. Will revert with additional information once I know more.

        Regards

        Nitin

        • Niamath Jeddy

          Nitin,

          Thanks for your inputs. After your response, I cross checked my BPA once again and  noticed that the 'Allow Price Override' flag was not set for these lines. My bad. Apologies for that.

          When I loaded now with the flag set, 7,3,4 got taken as prices for case1,2,3.

          Hence, based on the testing and your inputs, Can I conclude as below?

          1. If 'Allow price override' flag is 'No' , then,
            1.  FBDI program will always take the BPA line price and stamp on the PO line.The price specified in FBDI file is not considered.
            2. PO FBDI upload program currently takes only the BPA line price. Currently it does not respect BPA price breaks.
          2. If 'Allow price override' flag is 'Yes', then
            1. Price present in the FBDI file is taken.

          Ism't conclusion point 1.2 (BPA price breaks not being respected) a defect? 

          Regards,

          Niamath

           

           

          • Nitin Katare

            Hi Niamath

            Can you please log an SR so that Development can review it. The price breaks should be honored, but would let development look into it once we get the SR logged. Please share the SR number here.

            Thanks

            Nitin

            • Niamath Jeddy

              Nitin,

              SR# is as below:

              SR 3-20525396501 : FBDI PO upload not taking PO line price as per BPA Line Price Breaks

              Regards,

              Niamath

              • Nitin Katare

                Thanks Niamath. I have communicated the SR back to Development. Will revert once we have had a chance to review. Please give us a few days.

                Thanks

                Nitin

    • Suman Guha

      Confirming 1.2 above is a defect and will be taken up by development for a fix. Thanks for bringing it to our attention.

       

    • Niamath Jeddy

      Nitin, Suman, 

      Thanks much for analyzing this.

      I will followup in the SR to check if the fix can be prioritized as we are on the verge of doing conversion on production.

      Regards,

      Niamath