Earlier today (5 minutes ago?) I blogged about Oracle Financials JE CAAT and gave away the necessary scripts to build the files.  Now I'm going to do the same for Solomon. 

As stated in the Oracle blog - these scripts work for us.  I offer no guarantees or warranties of any kind.

Don't forget to replace the year and the company id below.

GL Balance File:

 select b.acct as [GL_Account_Number], b.sub as [GL_Sub_Account_Number], a. descr as [Description], b.cpnyid as [Business_Unit], a.accttype as [Account_Type], b.begbal as [Beginning_Balance], b.ytdbal11 as [Ending_Balance]
from account a, accthist b
where b.acct = a.acct
    and b.fiscyr = '2008'
    and b.ledgerid = 'ACTUAL'
    and b.cpnyid = '111111'

Journal Entries File:

select refnbr as [JE_Number], acct as [GL_Account_Number], sub as [GL_Sub_Account_Number], dramt as [Debit_Amount], cramt as [Credit_Amount], cpnyid as [Business_Unit], perpost as [Effective_Period], crtd_datetime as [Entry_Date], crtd_user as [Preparer_ID], module as [Source], trandesc as [Description], batnbr as [Batch_Number]
from gltran
where fiscyr = '2008'
    and ledgerid = 'ACTUAL'
    and cpnyid = '11111'
    and posted = 'P'
order by acct