Receipts Workbench: Applying a Receipt to Invoice, But Cannot Save it and Receive No Error. (Doc ID 2099105.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to apply a Receipt to an Invoice, but receive no error:

 

Fnd debug message are as follows.

--------------------------------------------
ar.plsql.arp_auto_accounting.flex_manager account_class=UNEARN
ar.plsql.arp_auto_accounting.flex_manager line_id=358463
ar.plsql.arp_auto_accounting.flex_manager trx_type_id=3002
ar.plsql.arp_auto_accounting.flex_manager salesrep_id=-3
ar.plsql.arp_auto_accounting.flex_manager inv_item_id=
ar.plsql.arp_auto_accounting.flex_manager memo_line_id=1001
ar.plsql.arp_auto_accounting.flex_manager ccid_tax=
ar.plsql.arp_auto_accounting.flex_manager int_ccid_tax=
ar.plsql.arp_auto_accounting.flex_manager site_use_id=1898
ar.plsql.arp_auto_accounting.flex_manager warehouse_id=
.
ar.plsql.arp_auto_accounting.dump_ccid_record Dumping CCID record:
.
ar.plsql.arp_auto_accounting.dump_ccid_record trx_type_ccid_unearn=13379
.
ar.plsql.arp_auto_accounting.dump_ccid_record site_use_ccid_unearn=-1 ** Note1
ar.plsql.arp_auto_accounting.dump_ccid_record site_use_ccid_suspense=-1
.
.
ar.plsql.arp_auto_accounting.assemble_code_combination.end arp_auto_accounting.assemble_code_combination()- 05-JAN-16 03:38:28
ar.plsql.arp_auto_accounting.assemble_code_combination ccid= -1
ar.plsql.arp_auto_accounting.assemble_code_combination concat_segs= 01.1000.001..000.00.000 ** Note2
ar.plsql.arp_auto_accounting.assemble_code_combination interim_tax_ccid=
ar.plsql.arp_auto_accounting.assemble_code_combination interim_tax_concat_segs=
ar.plsql.arp_auto_accounting.flex_manager.end arp_auto_accounting.flex_manager()- 05-JAN-16 03:38:28
ar.plsql.arp_auto_accounting.flex_manager process_line: Failure count : 1
ar.plsql.arp_auto_accounting.flex_manager p_failure_count=1
ar.plsql.arp_auto_accounting.do_autoaccounting_internal.end arp_auto_accounting.do_autoaccounting_internal()- 05-JAN-16 03:38:28
ar.plsql.arp_auto_accounting.do_autoaccounting_internal p_failure_count=1
ar.plsql.arp_auto_accounting.do_autoaccounting_internal raising no_ccid
ar.plsql.arp_auto_accounting.do_autoaccounting_internal earn_or_unearn: Unexpected error User-Defined Exception at AR_Revenue_Adjustment_PVT.earn_or_unearn()+
ar.plsql.arp_auto_accounting.do_autoaccounting_internal Unearn_Revenue: Unexpected error User-Defined Exception at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+
ar.plsql.arp_auto_accounting.do_autoaccounting_internal RME encountered an ERROR with RAM!
ar.plsql.arp_auto_accounting.do_autoaccounting_internal p_customer_trx_id : 317175
ar.plsql.arp_auto_accounting.do_autoaccounting_internal p_customer_trx_line_id : 358463
ar.plsql.arp_auto_accounting.do_autoaccounting_internal Error Reported By RAM API:
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ar.plsql.arp_auto_accounting.do_autoaccounting_internal OTHERS: adjust_revenue
ar.plsql.&GENERIC_TEXT ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ar.plsql. (1) OTHERS: receipt_analyzer
ar.plsql.&GENERIC_TEXT ORA-20001: APP-AR-11526: &GENERIC_TEXT (GENERIC_TEXT=)
ar.plsql.&GENERIC_TEXT EXCEPTION: arp_process_application.reverse
ar.plsql.ARP_XLA_EVENTS.Create_Events validate_args: EXCEPTION: arp_reverse_receipt.reverse
ar.plsql.ARP_XLA_EVENTS.Create_Events Exception in arp_process_receipts.update_cash_receipts

--------------------------------------------

** Note1:
site_use_ccid_unearn=-1
The unearn account did not define in customer site level.

** Note2:
concat_segs= 01.1000.001..000.00.000
The segment4 does not have value.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms