Advanced Pricing - EBS (MOSC)

MOSC Banner

Why is API QP_PREQ_PUB.PRICE_REQUEST not pulling prices correctly when price formula is used?

edited Feb 20, 2019 6:41AM in Advanced Pricing - EBS (MOSC) 4 commentsAnswered

Hi,

We're using R12.1.3 of Oracle EBS.

Some reason QP_PREQ_PUB.PRICE_REQUEST is not pulling the correct price information if the modifier line uses a price Formula.

Please advise.

Thanks,

Ram

Code--

SET SERVEROUTPUT ON SIZE UNLIMITED;

DECLARE

   p_line_tbl                 qp_preq_grp.line_tbl_type;

   p_qual_tbl                 qp_preq_grp.qual_tbl_type;

   p_line_attr_tbl            qp_preq_grp.line_attr_tbl_type;

   p_line_detail_tbl          qp_preq_grp.line_detail_tbl_type;

   p_line_detail_qual_tbl     qp_preq_grp.line_detail_qual_tbl_type;

   p_line_detail_attr_tbl     qp_preq_grp.line_detail_attr_tbl_type;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center