Receipts Workbench Issue: Unable to Post Receipts to GL - RCA 2009/03 Event Id Is Not Getting Stamped By Create Events Using Request ID (Doc ID 1514037.1)

Last updated on FEBRUARY 09, 2016

Applies to:

Oracle Receivables - Version 12 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

Event id is not getting stamped by create events using request id.

You are not able to post receipts to GL.

Checked the data for the receipts and found the following:

crh_id created_from status cr_id ev_id pcid gl_date
==================================================================
16578765 ARRERGW CONFIRMED 116718119 12092472 22-JAN-09
16579178 ARZARM REMITTED 116718119 12092472 22-JAN-09
16740658 ARREVREM CONFIRMED 116718119 -3 30-MAR-09

As seen above the receipt has been created in CONFIRMED status and has been REMITTED.

The receipt has changed to the CONFIRMED status but the event_id is not stamped in ar_cash_receipt_history_all table.

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