UNABLE TO CREDIT TRANSACTION ORA-01476 divisor is equal zero ORA-06512 APPS.ARP_PROCESS_CREDIT_INS_COVER

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:

On 11.5.10 in Production:UNABLE TO CREDIT TRANSACTION  ORA-01476 divisor is equal zero ORA-06512 APPS.ARP_PROCESS_CREDIT_INS_COVER

1.       Open credit transaction window.
2. Enter all details.
3. Save record.
4. Got error

Not able to credit transaction through credit transaction window.
ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.ARP_PROCESS_CREDIT_INS_COVER", line 261

Symptoms:

Log files:

Debug LOG FILE
--------------------------
*** This Transaction Is Not Being Monitored ***
EXCEPTION: Error executing insert dist stmt
EXCEPTION: arp_credit_memo_module.write_cm_sched_to_table()
EXCEPTION: Error fetching select cm lines
EXCEPTION: arp_credit_memo_module.credit_rule_transactions()
EXCEPTION: arp_credit_memo_module.credit_transactions_ins_mode(654996, , 436099, , )
EXCEPTION: derive_credit_information
EXCEPTION: arp_process_credit.insert_header
EXCEPTION : arp_process_credit_cover.insert_header_cover

Solution:

It is a bug 8489702

References:

Navigate to Oracle Diagnostics and run the Transaction Data Collection test
( Note 223834.1 ) for the affected transaction and check the output

Check the output of the Applications Collection Tool (ACT) for product AR
See Note 183274.1.

Note 398834.1 - Script Catalogue for Receivables Support Transaction and Reconciliation Issues

    

Get Oracle Certifications for all Exams
Free Online Exams.com