Finding Projects Data not transferred to GL via front-end

Hi,

A customer I support is on 12.2.9, patch set level R12.PA.C.9 for Projects.

Sometimes their PRC: Generate Cost Accounting Events errors with a Signal 11 error (that issue is already covered here).

Once last year, a load of data ended up not transferred from PA to GL and was found via this SQL:

    SELECT fat.application_id
       , fat.application_name
       , xte.entity_id
       , xte.entity_code
       , xte.source_id_int_1
       , xte.transaction_number
       , xah.*
     FROM xla.xla_ae_headers xah
     JOIN xla.xla_transaction_entities xte ON xah.entity_id = xte.entity_id AND xah.application_id = xte.application_id
     JOIN fnd_application_tl fat on xte.application_id = fat.application_id and fat.language = userenv('lang')
     WHERE 1 = 1
      AND fat.application_name = 'Projects'
      AND xah.gl_transfer_status_code = 'N'
      AND 1 = 1;