Posts Tagged ‘oracle application ERROR: APP-FND-00531’

RECEIPT APPLICATION ERROR: APP-FND-00531

April 28th, 2018, posted in Oracle Queries
Share
제품 : 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
Share