My Oracle Support Banner

Why Are the Subledger Journal Entry Lines Exported To a Text (.txt) File in R12? (Doc ID 1275476.1)

Last updated on JULY 23, 2021

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.


In Release 11i when you exported the journal lines from a drilldown from an FSG report, the lines were exported into a .tsv file and opened into Excel.  In R12 the system exports one line at a time into a .txt file.  When you leave the account inquiry form to drilldown on the journal, the page you get is jelinesgldrilldownco.  On that page is the list of transactions raised against that particular code combination.  These have a select radio button beside them and there is a an export button at the top of the table along with view transaction and view journal entry.  These buttons all apply to the selected transaction.  There is no method that allows you to generate a spreadsheet with all lines for this account.  They come out one by one.


To view full details, 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 a vibrant support community of peers and Oracle experts.