This discussion is archived
2 Replies Latest reply: Nov 20, 2012 8:11 AM by Vishal Majithia RSS

Error in Formula Processing

Vishal Majithia Newbie
Currently Being Moderated
Hi,

For a specific formula NVL(1,2) where 1 is a Factor list and 2 is List Price, we are getting this error. ERROR IN FORMULA PROCESSING....We are on R12.1.3 instance and this is upgraded from 11.5.9

There is a metalink note QPXPRFOR OEXOEORD: Saving an Order Results in Error in Formula Processing [ID 156396.1] mentioning about the same issue but the solution part is not clear.

If anyone faced similar kind of issue, please help.
  • 1. Re: Error in Formula Processing
    JasonBatzlaff Explorer
    Currently Being Moderated
    You state that you have the following formula:

    NVL(1,2)

    Where:

    1 = Factor List
    2 = List Price

    What if 2 is also NULL? You should also handle this case. For example:

    NVL(1, NVL(2, 3))

    Where:

    1 = Factor List
    2 = List Price
    3 = Numeric Constant with component = <value you want when no data is found> . You might want this to be $0 or maybe a very large price $999999.

    Try making this change. Be sure to re-run the Build Formula Package process.

    When you do Formulas, you need to be very careful that you handle Nulls properly. An ultimate value of NULL will cause these types of issues.

    Good Luck.

    Regards,
    Jason Batzlaff
  • 2. Re: Error in Formula Processing
    Vishal Majithia Newbie
    Currently Being Moderated
    Hi,

    Thanks for the update.

    Actually, my problem got resolved. After analyzing the debug file myself, I narrowed down the error as below

    ----------------------------------------
    Normal flow Formula Processing begin
    In ---Routine:QP_PREQ_GRP.Formula_Processing---
    PRICING_PHASE_ID: 2
    Processing Formula ID :7512
    Line Index: 1
    Start Formula...
    Formula Line Type = ML, Step = 1
    Before populating formula stepvalues temp table
    Other Exception ORA-01403: no data found
    Exception occurred. Formula value returned is
    Formula return status: U
    Formula Base Price :
    Error returned by QP_FORMULA_PRICE_CALC_PVT.Calculate
    ----------------------------------------

    And, as per the oracle support note "Error Returned By Qp_formula_price_calc_pvt.Calculate [ID 1282519.1]", after setting the profile value to N, the issue is resolved.

    With Regards,
    Vishal Majithia

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points