제품 : FIN_AR 작성날짜 : 2003-11-18 RECEIPT APPLICATION ERROR: APP-FND-00531 ======================================== PURPOSE ------- Receipt Application 시 발생하는 error를 효과적으로 해결한다. Problem Description ------------------- Applications 11.0.3: Transaction을 생성 한 후 Receipt 과 Apply 할 때 다음과 같은 error 가 발생하였다. APP-FND-00531 Amount Cannot Be Correctly Formatted The Amount XXX.XXX Could Not Be Formally Formatted. The Correct Format Is 999.99 And -999.99 Workaround ---------- 1. 해당 data 를 bakcup 받아 놓는다. 2. 다음 update script을 수행한다. Update ar_payment_schedules_all set amount_due_original = round(amount_due_original,2), amount_due_remaining= round(amount_due_remaining,2), acctd_amount_due_remaining = round (acctd_amount_due_remaining, 2) where customer_trx_id=xxx update ra_customer_trx_lines_all set extended_amount=round(extended_amount,2) where customer_trx_id=xxx and line_type='TAX' update ra_cust_trx_line_gl_dist_all set amount=round(amount,2) where customer_trx_id=xxx Solution Description -------------------------- Applications 11.0.3에서 Tax / Freight Defaultation Program이 rounding 처리를 잘 못하여 ra_cust_trx_line_gl_dist_all 에 데이타가 corrupted 된 것으로 보인다. 잘 못된 data를 rounding 처리하여 저장해준다. Reference Documents ------------------- Note 247018.1
Comments
Tags: Application ERROR: APP-FND-00531, ERROR: APP-FND-00531, Ora Error, Oracle Application Error, oracle application ERROR: APP-FND-00531, Oracle APPs DBA, Oracle DBA, Oracle ebs error, oracle error, oracle ERROR: APP-FND-00531, oracle issues, RECEIPT APPLICATION ERROR: APP-FND-00531