R12: RECEIVABLES DATA SHOWS TRANSFERED TO GL -DATA IS MISSING FROM GL (Doc ID 726002.1)

Last updated on AUGUST 04, 2016

Applies to:

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

Symptoms

AR Invoices show transfered to GL Complete. Data is missing in GL. 
XLA_EVENTS,XLA_AE_HEADERS AND XLA_AE_LINES Table. Corresponding data is found in XLA_EVENTS,XLA_AE_HEADERS but not in XLA_AE_LINES and GL Tables.

AR data does indeed show posted to GL, with PCID anf GL_Posted_Date confirmed.  Records do not exist in GL_Import_References or GL_JE_LINES tables.  XLA_Events table shows Status = P, however XLA_AE_HEADERS shows Accounting_Entry_Status = F.

 

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