Home » Applications » Oracle Fusion Apps & E-Business Suite » Query in Order Import (Oracle Applications - ( order Management ))
Query in Order Import [message #392693] Wed, 18 March 2009 23:12
Messages: 4
Registered: February 2009
Junior Member

Hi Gurus

I am going to import the ORDER records from external table using ORDER IMPORT concurrent request.

In External order line table, there are UNIT SELLING PRICE, UNIT LIST PRICE and PRICE LIST ID are available and also inserted the same into order line interface table - OE_LINES_IFACE_ALL .
Here, UNIT SELLING PRICE contains the discounted price.
For Example, UNIT LIST PRICE = 1000 Rs. and UNIT SELLING PRICE = 900 Rs.

Now, when I going to import this record from interface to base table using order import concurrent request, the UNIT SELLING PRICE is also updated with UNIT LIST PRICE .

How can I set the UNIT SELLING PRICE to its discounted value ?
( Here, as per example set to Rs. 900 )

For discounted UNIT SELLING PRICE, is there any interface/table, i have to accessed ?

Please help me if anyone has any idea.

Regards & Thanks in advance ...
Sanjay Desai .
Previous Topic: Oracle Order Management Sales Orders to Manhattan
Next Topic: prepayment invoice shows unpaid already paid prepayment invoice
Goto Forum:

Current Time: Wed Oct 26 15:11:28 CDT 2016

Total time taken to generate the page: 0.16481 seconds