求教内部價目表設定問題

智者

不知那位有關于Oracle ERP内部價目表的相關資料？可供出來參考一下嗎？

success

收到~帮你联系中。

zhaoyin

不懂什么叫 内部價目表？

captain

是销售价目表吧?

智者

也可以這樣說。不過是組織間的銷售價目表啊。

智者

我們在咝泄�司間商業發票時，總是不成功。提示信息是價目表有問題，但不管怎麽查看其設定及相關信息還是沒有找到其原因，所以想了解一下，有沒有這方面的標準設定？

zhaoyin

看过相关资料，好像说对于内部订单，price list不起什么作用，具体没做过test

智者

哦，不知其他誰還有此方面的資料啊？援助一下了，急於了解！！

captain

这个还真没用过,帮你顶

智者

謝謝版主了！！！大家眾人拾柴火焰高啊！！！

[ 本帖最后由 智者 于 2007-1-9 13:42 编辑 ]

智者

我想問一下，在價目表中的“優先級順序”是怎麽使用的？？？

zhaoyin

解决冲突用的,有可能一个价目表里有不同大定价方式,比如by item by catogory等等,如果同时满足的话就需要有个判断了

智者

哦，這個問題太深奧了，我們現在就是價目表出現沖突，找不到什麽原因，很急人的阿！！！

zhaoyin

具体说说你怎么个冲突法?

智者

具體問題情況：我在進行公司間交易（内部交易）時，做到“開立公司間AR商業發票”時出現錯誤警告，導致不能繼續進行。看警告LOG文檔發現是價目表処出現錯誤，但是找不到具體原因是什麽。
具體LOG文檔内容如下：
$Header: inciar.opc 115.40.115100.10 2005/06/03 16:28:31 sbitra ship $
+---------------------------------------------------------------------------+
Inventory: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

INCIAR module: Create Intercompany AR Invoices
+---------------------------------------------------------------------------+

Current system time is 11-JAN-2007 08:00:41

+---------------------------------------------------------------------------+

In inlico.lpc, inilppa()
Create Intercompany AR Invoices

Arguments
--------------------
Shipping/Procuring Operating Unit ... 108
Line Description ....................

Getting The IC_CURRENCY_CONVERSION_TYPE profile
convType is Corporate

Current system time is 11-JAN-2007 08:00:41

Mark inelligible records in mmt
Current system time is 11-JAN-2007 08:00:42

Start Processing Transaction Records
         txnId = 1464705
         Inventory Organization: 116 < >
         Inventory Item ID: 118 < 08DH02001A >
         global.uom is  PCS

Start Processing Transaction ID : 1464705


Getting Org Information
        In inlico.lpc, inilcoi()
        shipOrgId = 108 global->shipOrgId = 0 sellOrgId = 113 global->sellOrgId = 0
        Shipping organization has changed; recache buffer
        ========================================================
        IC-SHIP ORG/PROCURING ORG INFORMATION
        In inlico.lpc, getOrgInfo()
        Information not cached yet, allocate memory and cache now
        Getting Org hierarchy
        Getting SOB information
        Getting currency information
        In inlico.lpc, printOrgInfo()

        organization_id ..... 108 < OU>
        legal_entity_id ..... 101 < LE>
        set_of_books_id ..... 1001 < SOB>
        chart_of_accts_id ... 50268
        currency_code ....... RMB

        ...Returning success
        Selling organization has changed; recache buffer
        ------------------------------------
        IC-SELL ORG/RECEIVING ORG INFORMATION
        Calling getorginfo from inilcoi
        In inlico.lpc, getOrgInfo()
        Information not cached yet, allocate memory and cache now
        Getting Org hierarchy
        Getting SOB information
        Getting currency information
        In inlico.lpc, printOrgInfo()

        organization_id ..... 113 < OU >
        legal_entity_id ..... 106 < LE>
        set_of_books_id ..... 1005 < SOB>
        chart_of_accts_id ... 50273
        currency_code ....... USD

        ...Returning success
        Start executing gettrxflow

        ItemId = 118 global->itemId = 118
        txnId = 1464705 global->txnId = 1464705
        global_invOrgId = 116
        Getting the Process Org Flag
        processOrgFlag = 0

        Getting Transaction flow information
        global->invInfo.ap.custTrxLnId = -1218508603
        custTrxLnId = -1218508603
        Discrete Org
        After getting transaction flow header id
        transaction flow header id is 32
        logicalTrxTypeCode is 0
        NewAccountingFlag is 0
        invCur = 1
        global->newAccountingFlag is 0
        global->trxFlowHeaderId is 32
        global->logicalTrxTypeCode is 0
        global->incrCurr is 1

        Calling function passed as parameter to this function


Inside inarcii Caching the AR Invoice Information

         trxFlowHeaderId is 32

Getting customer/site defaults, price list and payment Term

        batchSource = Intercompany salesCredit = 0
        global->invInfo.ar.batchSource  = Intercompany

        In inlico.lpc, inilgov()
        orgId = 108
        pname = AR_ALLOW_TAX_CODE_OVERRIDE

        Unable to read the profile value at resp level
         So finding at site level
        Returning true from inilgov()
        pvalue for AR_ALLOW_TAX_CODE_OVERRIDE is Y
        In inlico.lpc, inilgov()
        orgId = 108
        pname = OE_INVOICE_FREIGHT_AS_LINE

        Unable to read the profile value at resp level
         So finding at site level
        Returning true from inilgov()
        pvalue for OE_INVOICE_FREIGHT_AS_LINE is N
        For debugging purposes:
                payTermId ........ 1011
                trxTypeId ........ 1004
                crMemoTypeId ..... 1001
                crMemoSign ....... -1
                priceListId ...... 32935
                freightTaxFlag ... 1
                freightAsLine .... 0
                freightItemId .... 0
                frItemDesc .......
                uom .............. PCS
                batchSource....... Intercompany

        Returned success in inilcoi()

After Getting Org Information

............
Processing shipment transaction, ID = 1464705
Calling inarums(global), global->newAccountingFlag is 0

        global->logicalTrxTypeCode is 0
Calling inarcil(global)

        global->newAccountingFlag is 0
        global->logicalTrxTypeCode is 0
Global->internalOrderFlag = 0
internalOrderFlag = ..0
Global->rae_flag = 0
rae_flag = 0
        global->newAccountingFlag is 0, global->logicalTrxTypeCode = 0
        global->trxFlowHeaderId = 32
        batchSource = Intercompany
        newAccountingFlag is 0, logicalTrxTypeCode = 0
        trxFlowHeaderId = 32
        INV: Use Model & Options for Configuration Pricing= 1
        baseItemId = 0
Calling inargtp to get the transfer price
         In inliar.lpc, inargtp()
... Establishing Transfer Price         txnId is 1464705
         invOrgId is 116
         itemId is 118
         shipOrgId is 108
         sellOrgId is 113
         priceListId is 32935
         internalOrderFlag is 0
         baseItemId is 0
         tmpIncrCurr is 1
         atoFlag is No

returned from External API...

calling QP API...
returned from QP API...
QP API returnStatus=E

Return Warning from inarcil.

Warning: Cannot create invoice line

End Processing Transaction ID: 1464705
Transaction ID: 1464705          Status = FAILURE

++++++++++++++++++++++++++++++++++ End of Transaction ++++++++++++++++++++++++++++++

Begin Build contexts
Called Build Sourcing at line level----------
Called Build Sourcing at header level----------
Number of qual attrs got from Get_Attribute_Values - 0
Number of pricing attrs got from Get_Attribute_Values - 0
Printing line attributes ----------
End Build contexts
##### Total Time in Build_Contexts(in sec) : .02 #####
Begin Build contexts
Called Build Sourcing at line level----------
Gathering product details
After product assigned
hw/src/L: change to g_no
Number of qual attrs got from Get_Attribute_Values - 0
Number of pricing attrs got from Get_Attribute_Values - 1
Called Build Sourcing at header level----------
Printing line attributes ----------
line index 56869
attribute type PRODUCT
context ITEM
attribute PRICING_ATTRIBUTE1
value from 118
validated flag N
-----------------------------------------
Tata Inserting line attributes ----------
Java Engine not Installed ----------
End Inserting line attributes ----------
End Build contexts
##### Total Time in Build_Contexts(in sec) : .01 #####
******** New Session:3579201****09-01-07:09.19.22 **********
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ORDER
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: line_index               => 25265
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 13-11-06
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: line_quantity            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: line_uom_code            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 25265
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: LINE
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: line_index               => 56869
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 14-11-06
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: line_quantity            => 1200
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: line_uom_code            => PCS
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          => 1200
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          => PCS
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 31604
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...
Java Engine not Installed ----------
[09-01-07 09:19:22] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=2
G_REQUEST_TYPE_CODE = IC
01 Java Engine not Installed ----------
Rounding profile value ROUND_ADJ
PRICE REQUEST PUB: Begin GSA check
Begin CHECK_GSA_INDICATOR N
Cursor fetched N
PRICE REQUEST PUB: GSA_indicator N
PRICE REQUEST PUB: GSA_profile
BEGIN PRICE REQUEST PUB: request_type_code IC
BEGIN PRICE REQUEST PUB: check_cust_view_flag N
BEGIN PRICE REQUEST PUB: round_indv_adj ROUND_ADJ
BEGIN PRICE REQUEST PUB: Version /* $Header: QPXPPREB.pls 115.248.11510.15 2005/04/20 18:27:43 julin ship $ */
BEGIN PRICE REQUEST PUB: temp table insert flag N
BEGIN PRICE REQUEST PUB: calculate_flag Y
BEGIN PRICE REQUEST PUB: check_cust_view_flag  reqtype IC
BEGIN PRICE REQUEST PUB: pricing_event ICBATCH
BEGIN PRICE REQUEST PUB: rounding_flag Y
BEGIN PRICE REQUEST PUB: gsa_check
BEGIN PRICE REQUEST PUB: full_pricing
BEGIN PRICE REQUEST PUB: get_freight_flag N
BEGIN PRICE REQUEST PUB: pricing_event ICBATCH,
02 Java Engine not Installed ----------
begin initialize_constants
1 initialize_constants
2 initialize_constants
3 initialize_constants
4 initialize_constants
5 initialize_constants
5.5 initialize_constants
5.6 initialize_constants
6 initialize_constants
Before update_rounding_factor:calculate_flag Y rounding_flag Y
6.5 initialize_constants
QP_PREQ_PUB before insert source line quantity
QP_PREQ_PUB before insert source line amt
7.5 initialize_constants
l_order_header_id 25265
QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE IC-25265
8.0 initialize_constants
03 Java Engine not Installed ----------
***Entering Oracle Pricing***
Please set debug level 3 in profile option to see all Pricing Debug Messages
-----------------New Engine Call----------------------
Pricing Event: ICBATCH,
Pricing Engine Version: /* $Header: QPXGPREB.pls 115.643.11510.16 2005/04/28 08:38:25 nirmkuma ship $ */
Java Engine not Installed ----------
G_SECURITY_CONTROL: ON
G_CURRENT_USER_OP_UNIT: 113
In direct insert Loop / performance path
Before Pricing Line Index: 25265
Before Pricing Unit Price:
Before Pricing Price Flag: Y
In direct insert Loop / performance path
Before Pricing Line Index: 56869
Before Pricing Unit Price:
Before Pricing Price Flag: Y
G_PRICE_LIST_SEQUENCE: 0
Rounding flag: Y
Calling application inserted into temp tables
Direct Temp Table Insert Price Flag Yes Only : Y
Java Engine not Installed ----------
After calling update_procss--
=CONTEXT PASSED: ITEM
=ATTRIBUTE     : PRICING_ATTRIBUTE1
=VALUE         : 118
=LINE INDEX    : 56869
================================
Request Type Code: IC
Line Index: 25265
Line Type Code: ORDER
Price Flag: Y
Price List Header Id: -9999
Rounding Factor :
Request Type Code: IC
Line Index: 56869
Line Type Code: LINE
Price Flag: Y
Price List Header Id: -9999
Rounding Factor :
G_REQUEST_TYPE_CODE: IC
G_TEMP_TABLE_INSERT_FLAG: N
G_ROUNDING_FLAG: Y
G_BEFORE_PRICING_ORD_AMT: 0
BEFORE event phase loop
Price Flag Yes Only : Y
Working on phase: 1
In Procedure Update_Price_List_Information...
after update1...
after update2
Call from Public API , Update_Price_List_Information
Trying to Update Unit Price To Null
after update3
after update4
update_rounding_factor...
Calling Round Factor function for : 1 price list,currency,pricing date combinations
Price List Id :
Currency Code : RMB
Pricing Date  : 14-11-06
BEGIN qp_util_pub.get_rounding_factor
p_use_multi_currency = Y
p_price_list_id =
p_currency_code = RMB
p_pricing_effective_date = 14-11-06
BEGIN round_price
p_operand =
p_rounding_factor =
p_use_multi_currency = Y
p_price_list_id =
p_currency_code = RMB
p_pricing_effective_date = 14-11-06
p_operand_type = R
Profile : rounding options =
Profile : OE unit price rounding =
Do rounding
l_rounding_factor =
x_rounded_operand =
x_status_code = S
END round_price
l_rounding_factor =
l_status_code = S
END qp_util_pub.get_rounding_factor
Rounding factor in QP_PREQ_GRP after the function call :
Number of lines updated with rounding factor : 0
IN ROUTINEP_PREQ_GRP.LIST_HEADER_SEARCH
cursor open l_list_cur_currency-multi-currency TRUE
cursor l_list_cur_currency-multi-currency TRUE - delete tables
cursor l_list_cur_currency-multi-currency TRUE - bulk fetch
cursor close l_list_cur_currency-multi-currency TRUE
#100
cursor open l_list_qual_cur_currency-multi-currency TRUE
cursor l_list_qual_cur_currency-multi-currency TRUE - delete tables
cursor l_list_qual_cur_currency-multi-currency TRUE - bulk collect
cursor close l_list_qual_cur_currency-multi-currency TRUE
#106
LOOOOOOOOOOOP Count : 0
In Update Request Line Status : FAILURE
Trying to Perform Secondary Search
QP_QUALIFY_SECONDARY_PRICE_LISTS:N
cursor l_sec_list_cur_currency-multi-currency TRUE
In Update Request Line Status : FAILURE
DUMMMMMMMMMMMMMMY: X
DUMMMMMMMMMMMMMMY1000: X
l_further_search: Y
l_further_search: Y
Before Big Select
p_pricing_phase_id: 1
p_freeze_override_flag: N
cursor for l_prod_qual_cur_currency-multi-currency TRUE
before l_prod_qual_pric_cur_currency...
before l_prod_cur_currency...
before l_prod_pric_cur_currency...
In Evaluate Between
Before Opening Price List Character Date Between Cur
Before Opening Price List Numeric Between Cur
In procedure Eliminate_Multiple_Hierarchies
Grouping begin
Pricing phase id: 1
In grouping
Deleted Line Details in Table
Successful Line Details in Table
In Pure Line Level grouping
Deleted Line Details in Pure Line Grouping Table
Successful Line Details in Pure Line Grouping Table
grouping ends
In Evaluate Between
Before Opening Price List Numeric Between Cur
Determine_Pricing_UOM
After Determine_Pricing_UOM
Pricing Phase Id:1
QP_TIME_UOM_CONVERSION Profile Setting: STANDARD
Incomp Return Status : S
In Update Request Line Status : SUCCESS
Calling Round Factor function for : 1 price list,currency,pricing date combinations
Price List Id :
Currency Code : RMB
Pricing Date  : 14-11-06
BEGIN qp_util_pub.get_rounding_factor
p_use_multi_currency = Y
p_price_list_id =
p_currency_code = RMB
p_pricing_effective_date = 14-11-06
BEGIN round_price
p_operand =
p_rounding_factor =
p_use_multi_currency = Y
p_price_list_id =
p_currency_code = RMB
p_pricing_effective_date = 14-11-06
p_operand_type = R
Profile : rounding options =
Profile : OE unit price rounding =
Do rounding
l_rounding_factor =
x_rounded_operand =
x_status_code = S
END round_price
l_rounding_factor =
l_status_code = S
END qp_util_pub.get_rounding_factor
Rounding factor in QP_PREQ_GRP after the function call :
Number of lines updated with rounding factor : 0
In ---Routine:QP_PREQ_GRP.Formula_Processing---
PRICING_PHASE_ID: 1
multi-currency TRUE - calling QP_MULTI_CURRENCY_PVT.CURRENCY_CONVERSION_API
Currency_Conversion_API - Enter
Currency_Conversion_API - p_user_conversion_rate
Currency_Conversion_API - p_user_conversion_type
Currency_Conversion_API - p_function_currency
Currency_Conversion_API - p_rounding_flagY
Currency_Conversion_API - record count = 0
Currency_Conversion_API - BEFORE updating the temp tables =
Currency_Conversion_API - line_index_t.count0
Currency_Conversion_API - after updating the temp tables
------Before 1st call cal-----------
-------------In call calculation engine-----------
GSA Enabled Flag : N
Freeze_override_flag: N
  G_REQUEST_TYPE_CODE: IC
  G_ROUNDING_FLAG: Y
-----l_request_line_cur I loop ------
  line_index: 25265
  line_type_code: ORDER
  rounding_factor:
  price_list_header_id:
Routine:QP_PREQ_GRP.Call_Calculation_Engine Before calling cal engine
In Procedure Calculate_Price...
selling price rounding options : ROUND_ADJ
Rounding Flag  : Y
Rounding Factor  :
WARNING: rounding_flag is Y, but rounding_factor is NULL!!!
The request line tables count is: 0
V_List_Price is null
List Price after rounding:
List Price after rounding1:
List Price after rounding2:
Before Update List Price after rounding1:
GSA Status Code :
In Line Update Information100
In Line Update Information200
In Line Update Information300
Related Pl/sql table count : 0
In Line Update Information400
#7
-----l_request_line_cur I loop ------
  line_index: 56869
  line_type_code: LINE
  rounding_factor:
  price_list_header_id:
Routine:QP_PREQ_GRP.Call_Calculation_Engine Before calling cal engine
In Procedure Calculate_Price...
selling price rounding options : ROUND_ADJ
Rounding Flag  : Y
Rounding Factor  :
WARNING: rounding_flag is Y, but rounding_factor is NULL!!!
The request line tables count is: 0
V_List_Price is null
List Price after rounding:
List Price after rounding1:
List Price after rounding2:
Before Update List Price after rounding1:
GSA Status Code :
In Line Update Information100
In Line Update Information200
In Line Update Information300
Related Pl/sql table count : 0
In Line Update Information400
#7
percent price:
related item price:
#8
Start G_ORGANIZATION_ID =
l_application_id = 401
inv_org_id from profile QP_ORGANIZATION_ID = 115
End G_ORGANIZATION_ID = 115
Start G_ORGANIZATION_ID = 115
End G_ORGANIZATION_ID = 115
----Updating status code for LDETS---------
In Line Update Information500
In Line Update Information600
In Line Detail Update Information2
In Line Detail Update Information3
In End Update Information
calling Set_Order_List_Rltd
Price Flag Yes Only : Y
Starting new a phase, pricing phase id :2
In rare_phase_id:2 exec_flag set to N
calling Set_Order_List_Rltd
Price Flag Yes Only : Y
Starting new a phase, pricing phase id :3
In rare_phase_id:3 exec_flag set to N
calling Set_Order_List_Rltd
Price Flag Yes Only : Y
Starting new a phase, pricing phase id :4
In rare_phase_id:4 exec_flag set to N
calling Set_Order_List_Rltd
Price Flag Yes Only : Y
Starting new a phase, pricing phase id :5
In rare_phase_id:5 exec_flag set to N
calling Set_Order_List_Rltd
Price Flag Yes Only : Y
Starting new a phase, pricing phase id :7
In rare_phase_id:7 exec_flag set to N
calling Set_Order_List_Rltd
Price Flag Yes Only : Y
Starting new a phase, pricing phase id :6
In rare_phase_id:6 exec_flag set to N
calling Set_Order_List_Rltd
Pricing Install Status : I
Limits Install Status : N
------Not calling calculation Engine of limits-----------
------Not Calling Calculation Engine as the call is from Public Engine Call-----------
Calling QP_COUPON_PVT.REDEEM_COUPONS with simulation_flag:
Entering QP_COUPON_PVT.Redeem_Coupons
hw/pre: change to g_yes
***Exiting Oracle Pricing***
Total time taken in PUB Pkg: .76
redo log in PUB:
End Price Request
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: Status_Code=IPL Status_Text=料號 08DH02001A 與單位 PCS 皆不在價目表  上
[09-01-07 09:19:23] 9: tfrPrice is
[09-01-07 09:19:23] 9: inside if
[09-01-07 09:19:23] 9: Getting the transaction flow header Id and trxDate from MMT
[09-01-07 09:19:23] 9: After getting transaction flow header id from MMT
[09-01-07 09:19:23] 9: Transaction Id, Transaction date, Transaction Source Id and Transaction Action Id are: 1490088, 08-12-06, 2 and 1
[09-01-07 09:19:23] 9: Transaction flow header id : 32
[09-01-07 09:19:23] 9: shipOrgId : 108 sellOrgId :113
[09-01-07 09:19:23] 9: l_trxFlowHeaderId = 32
[09-01-07 09:19:23] 9: l_logicalTrxTypeCode = 0
[09-01-07 09:19:23] 9: l_new_accounting_flag = 0
[09-01-07 09:19:23] 9: l_inv_cur = 1
[09-01-07 09:19:23] 9: Assigning the local variables to the C local variables
[09-01-07 09:19:23] 9: QP is installed
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Enabling QP debug option...
Before Process_Order
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP trace file is /usr/tmp/l1029266.dbg
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP Version : /* $Header: QPXGPREB.pls 115.643.11510.16 2005/04/28 08:38:25 nirmkuma ship $ */
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Line Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_transaction_id = 1490088
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_order_line_id = -9999
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_inventory_item_id = 2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_uom_code = PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_cto_item_flag = N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_organization_id = 116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Header Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Primary UOM...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Building Global Structure...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: l_base_item_id is 0
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: p_cto_item_flag is N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Hdr_Initialize: Populating G_HDR...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating IC fields...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating G_LINE...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: InventoryItemId=2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship From=116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship To=1108
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Build Context for line...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating Lines temp table...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ORDER
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 1400
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1400
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 9301
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            => 452
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          => 452
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 7901
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=2
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Initializing control record...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Calling QPrice Request routine ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating QP results ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: Status_Code=IPL Status_Text=料號 133H04052B 與單位 PCS 皆不在價目表  上
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[09-01-07 09:19:23] 9: tfrPrice is
[09-01-07 09:19:23] 9: inside if
[09-01-07 09:19:23] 9: Getting the transaction flow header Id and trxDate from MMT
[09-01-07 09:19:23] 9: After getting transaction flow header id from MMT
[09-01-07 09:19:23] 9: Transaction Id, Transaction date, Transaction Source Id and Transaction Action Id are: 1490098, 08-12-06, 2 and 1
[09-01-07 09:19:23] 9: Transaction flow header id : 32
[09-01-07 09:19:23] 9: shipOrgId : 108 sellOrgId :113
[09-01-07 09:19:23] 9: l_trxFlowHeaderId = 32
[09-01-07 09:19:23] 9: l_logicalTrxTypeCode = 0
[09-01-07 09:19:23] 9: l_new_accounting_flag = 0
[09-01-07 09:19:23] 9: l_inv_cur = 1
[09-01-07 09:19:23] 9: Assigning the local variables to the C local variables
[09-01-07 09:19:23] 9: QP is installed
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Enabling QP debug option...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP trace file is /usr/tmp/l1029266.dbg
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP Version : /* $Header: QPXGPREB.pls 115.643.11510.16 2005/04/28 08:38:25 nirmkuma ship $ */
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Line Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_transaction_id = 1490098
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_order_line_id = -9999
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_inventory_item_id = 2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_uom_code = PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_cto_item_flag = N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_organization_id = 116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Header Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Primary UOM...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Building Global Structure...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: l_base_item_id is 0
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: p_cto_item_flag is N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Hdr_Initialize: Populating G_HDR...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating IC fields...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating G_LINE...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: InventoryItemId=2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship From=116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship To=1108
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Build Context for line...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating Lines temp table...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ORDER
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 1403
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1403
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 2683
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            => 3888
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          => 3888
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1280
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=2
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Initializing control record...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Calling QP:Price Request routine ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating QP results ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: Status_Code=IPL Status_Text=料號 133H04052B 與單位 PCS 皆不在價目表  上
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[09-01-07 09:19:23] 9: tfrPrice is
[09-01-07 09:19:23] 9: inside if
[09-01-07 09:19:23] 9: Getting the transaction flow header Id and trxDate from MMT
[09-01-07 09:19:23] 9: After getting transaction flow header id from MMT
[09-01-07 09:19:23] 9: Transaction Id, Transaction date, Transaction Source Id and Transaction Action Id are: 1490099, 08-12-06, 2 and 1
[09-01-07 09:19:23] 9: Transaction flow header id : 32
[09-01-07 09:19:23] 9: shipOrgId : 108 sellOrgId :113
[09-01-07 09:19:23] 9: l_trxFlowHeaderId = 32
[09-01-07 09:19:23] 9: l_logicalTrxTypeCode = 0
[09-01-07 09:19:23] 9: l_new_accounting_flag = 0
[09-01-07 09:19:23] 9: l_inv_cur = 1
[09-01-07 09:19:23] 9: Assigning the local variables to the C local variables
[09-01-07 09:19:23] 9: QP is installed
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Enabling QP debug option...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP trace file is /usr/tmp/l1029266.dbg
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP Version : /* $Header: QPXGPREB.pls 115.643.11510.16 2005/04/28 08:38:25 nirmkuma ship $ */
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Line Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_transaction_id = 1490099
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_order_line_id = -9999
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_inventory_item_id = 2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_uom_code = PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_cto_item_flag = N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_organization_id = 116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Header Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Primary UOM...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Building Global Structure...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: l_base_item_id is 0
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: p_cto_item_flag is N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Hdr_Initialize: Populating G_HDR...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating IC fields...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating G_LINE...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: InventoryItemId=2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship From=116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship To=1108
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Build Context for line...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating Lines temp table...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ORDER
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 1402
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1402
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 2681
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            => 1296
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          => 1296
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1279
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=2
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Initializing control record...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Calling QP:Price Request routine ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating QP results ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: Status_Code=IPL Status_Text=料號 133H04052B 與單位 PCS 皆不在價目表  上
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[09-01-07 09:19:23] 9: tfrPrice is
[09-01-07 09:19:23] 9: inside if
[09-01-07 09:19:23] 9: Getting the transaction flow header Id and trxDate from MMT
[09-01-07 09:19:23] 9: After getting transaction flow header id from MMT
[09-01-07 09:19:23] 9: Transaction Id, Transaction date, Transaction Source Id and Transaction Action Id are: 1490691, 09-12-06, 2 and 1
[09-01-07 09:19:23] 9: Transaction flow header id : 32
[09-01-07 09:19:23] 9: shipOrgId : 108 sellOrgId :113
[09-01-07 09:19:23] 9: l_trxFlowHeaderId = 32
[09-01-07 09:19:23] 9: l_logicalTrxTypeCode = 0
[09-01-07 09:19:23] 9: l_new_accounting_flag = 0
[09-01-07 09:19:23] 9: l_inv_cur = 1
[09-01-07 09:19:23] 9: Assigning the local variables to the C local variables
[09-01-07 09:19:23] 9: QP is installed
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Enabling QP debug option...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP trace file is /usr/tmp/l1029266.dbg
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QP Version : /* $Header: QPXGPREB.pls 115.643.11510.16 2005/04/28 08:38:25 nirmkuma ship $ */
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Line Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_transaction_id = 1490691
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_order_line_id = -9999
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_inventory_item_id = 2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_uom_code = PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_cto_item_flag = N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_Transfer_price: p_organization_id = 116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Header Identifier...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Selecting Primary UOM...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Building Global Structure...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: l_base_item_id is 0
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: p_cto_item_flag is N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Hdr_Initialize: Populating G_HDR...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating IC fields...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: Populating G_LINE...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.G_Line_Initialize: InventoryItemId=2729
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship From=116
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: Ship To=1108
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Build Context for line...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating Lines temp table...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ORDER
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 1405
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1405
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: -----------------------------------------------
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_index               => 2687
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_effective_date   => 12-12-05
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first        =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_first_type   =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second       =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: active_date_second_type  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_quantity            => 332
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: line_uom_code            => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: request_type_code        => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_QUANTITY          => 332
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICED_UOM_CODE          => PCS
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: CURRENCY_CODE            => RMB
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UNIT_PRICE               =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PERCENT_PRICE            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UOM_QUANTITY             =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ADJUSTED_UNIT_PRICE      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: UPD_ADJUSTED_UNIT_PRICE  =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: price_flag               => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_ID                  => 1282
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PROCESSING_ORDER         =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: pricing_status_code      => X
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_STATUS_TEXT      =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FLAG            => Y
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: ROUNDING_FACTOR          =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: QUALIFIERS_EXIST_FLAG    => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICING_ATTRS_EXIST_FLAG => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_LIST_ID            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: VALIDATED_FLAG           => N
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: PRICE_REQUEST_CODE       => IC
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: USAGE_PRICING_TYPE       => REGULAR
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: LINE_CATEGORY            =>
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=2
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Initializing control record...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Calling QP:Price Request routine ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating QP results ...
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: Status_Code=IPL Status_Text=料號 133H04052B 與單位 PCS 皆不在價目表  上
[09-01-07 09:19:23] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[09-01-07 09:19:23] 9: tfrPrice is
[09-01-07 09:19:23] 9: inside if
+---------------------------------------------------------------------------+
從 FND_FILE 關閉日誌訊息
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
正在執行請求完成選項...


已完成請求完成選項的執行.
並行程式失敗, 但沒有說明失敗原因.

+---------------------------------------------------------------------------+
並行請求已完成
目前的系統時間是 09-01-2007 09:18:10

+---------------------------------------------------------------------------+

[ 本帖最后由 智者 于 2007-1-12 14:11 编辑 ]

gaoyiming

价目表  qp_list_lines
有关价格表的查询


select qph.name MZ,qpl.product_attr_val_disp ITEM,qpl.OPERAND JG,qph.language,qpl.INVENTORY_ITEM_ID,qph.list_header_id,qpl.*
from
qp.qp_list_headers_tl  qph
,apps.qp_list_lines_v      qpl
where qph.list_header_id=qpl.list_header_id
and qph.language='ZHS'
--AND LENGTH(QPL.PRODUCT_ATTR_VAL_DISP)<>20
--AND QPL.ORGANIZATION_ID=83

--and qph.name like '%XSTJL斜交价格表%'
and qph.list_header_id='11676'
AND QPL.PRODUCT_ATTR_VAL_DISP LIKE 'N%'
--and to_char( qph.last_update_date,'yyyymmddHH24') >= '2006030100'
order by 2

winson

Do you mean the pricing module of Oracle EBS or advance price list ?

智者

是的，就是那個東西啊

bingmao0124

顶一下

xdp4507

碰到同样的问题，楼主有解决了吗？