Monday, June 20, 2011

Trial balance report outputs and log files are coming with inverse question marks

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:


Reports finished with
MSG-00123: NVL(GLB.TRANSLATED_FLAG,'x') != 'R' AND GLB.CURRENCY_CODE='AED'



Trial balance report outputs and log files are coming with inverse question marks.


Explanation:


ZERO_INDICATOR format trigger was returning null value
Also referred BUG 7584735 - R12:TRIAL BALANCE DETAIL COMPLETES WITH STATUS OF ERROR 



Modified the ZERO_INDICATOR format trigger. It returns 0 instead of NULL.
Fixed in the file version -- GLRTBD.rdf 120.8.12000000.7

Also referred Note 782662.1 - Trial Balance Detail Completes with Error for Selected Secured Pagebreak Values



Solution:


1) Please apply the patch 7584735:R12.GL.A
2) Bounce the server
3) Retest the issue
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: