Home » Applications » Oracle Fusion Apps & E-Business Suite » GL_IMPORT_REFERENCES and XLA_AE_LINES (R12)
GL_IMPORT_REFERENCES and XLA_AE_LINES [message #564802] Tue, 28 August 2012 14:43 Go to next message
jimmyjohn
Messages: 1
Registered: August 2012
Junior Member
For some of the invoices, GL_SL_LINK_ID between GL_IMPORT_REFERENCES and XLA_AE_LINES is not returning any data. I am not seeing data in gl_import_references but data exists in xla_ae_lines. Is this something related to configuration in EBS ?

Is there any other way to join get xla information from gl_je_lines if not through gl_import_references ?
Re: GL_IMPORT_REFERENCES and XLA_AE_LINES [message #565047 is a reply to message #564802] Thu, 30 August 2012 03:19 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is there any pattern for these missing records?
I hope you are looking for ONLY transferred records (xla_ae_headers.gl_transfer_status_code = 'Y')

If you don't get any clue, try the MOS Note "GL Transfer Datafixes 883557.1"

By
Vamsi
Previous Topic: Error When create new emplyee
Next Topic: Query Related to Oracle Inventory
Goto Forum:
  


Current Time: Thu Aug 28 18:20:08 CDT 2014

Total time taken to generate the page: 3.19506 seconds