Oracle eBS經驗分享

<Solution>

使用Workflow Administrator 權限進去處理

Find out 該Employee and PO number.

把那張PO 找出, Retry it again.

/* Formatted on 2010/04/21 11:55 (Formatter Plus v4.8.8) */
SELECT interface_line_id
     , agreement_id
     , comments
     , conversion_date
     , conversion_rate
     , conversion_type
     , credit_method_for_acct_rule
     , credit_method_for_installments
     , currency_code
     , customer_bank_account_id
     , cust_trx_type_id
     , document_number
     , document_number_sequence_id
     , gl_date
     , header_attribute1
     , header_attribute2
     , header_attribute3
     , header_attribute4
     , header_attribute5
     , header_attribute6
     , header_attribute7
     , header_attribute8
     , header_attribute9
     , header_attribute10
     , header_attribute11
     , header_attribute12
     , header_attribute13
     , header_attribute14
     , header_attribute15
     , header_attribute_category
     , initial_customer_trx_id
     , internal_notes
     , invoicing_rule_id
     , orig_system_bill_address_id
     , orig_system_bill_contact_id
     , orig_system_bill_customer_id
     , orig_system_ship_address_id
     , orig_system_ship_contact_id
     , orig_system_ship_customer_id
     , orig_system_sold_customer_id
     , orig_system_batch_name
     , previous_customer_trx_id
     , primary_salesrep_id
     , printing_option
     , purchase_order
     , purchase_order_date
     , purchase_order_revision
     , reason_code
     , receipt_method_id
     , related_customer_trx_id
     , set_of_books_id
     , term_id
     , territory_id
     , trx_date
     , trx_number
     , interface_line_attribute3   -- optional rule
  FROM ra_interface_lines_all
WHERE trx_number = '1828481'

How to obtain the Mobile Debug Log

For Release 11i
1. Navigate to 'cd $MWA_TOP/secure'
2. Open the file mwa.cfg
3. In this file, check for the log level setting , it should be set as
'mwa.LogLevel=trace'
Also check for 'mwa.logdir' to be set accordingly
4. Restart Mobile Server for e.g. on Unix using $MWA_TOP/bin/mwactl.sh start port-number
5. After doing a test case there will be files created in log directory
(specified in mwa.cfg) like
port-number.WMS.log
port-number.INV.log
port-number.system.log

Notes : 565756.1

PO Shipment Line裡有一個[Receiving Controls]的Button

點進去喔<Over Receipt Tolerance>是控制是否允許超收數量。

這個設定Default是抓哪的呢？

         Message Page
------------------------------
|Pick drop failed|Error in Txn Manager. Press any key to continue.