Tuesday, October 4, 2011

UNABLE TO CREDIT TRANSACTION: ORA-01476: DIVISOR IS EQUAL TO ZERO ORA-06512

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: UNABLE TO CREDIT TRANSACTION: ORA-01476: DIVISOR IS EQUAL TO ZERO ORA-06512

Symptoms:
Credit Transactions screen/
credited trx: 45223

tries to create CM 100% on Line

Error:
ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.ARP_PROCESS_CREDIT_INS_COVER", line 261




Output for
SELECT * FROM ad_bugs WHERE bug_number in ('7602515', '7585468', '7113428', '4969347', '6935700');
BUG_ID APPLICATION_SHORT_NAME BUG_NUMBER CREATION_DATE ARU_RELEASE_NAME CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY
214593 4969347 11/5/2007 15:01 11i 5 11/5/2007 15:01 5


Solution:



Issue caused by:
Bug 10354518 - UNABLE TO CREDIT TRANSACTION: ORA-01476: DIVISOR IS EQUAL TO ZERO ORA-06512

Apply the following patches in test instance:
9881153
8402113

the retest and let us know.
Defect 10354518 has been created via Defect Workbench iBug portal request id: (2823604).




Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: