OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » GL enquiries (EBus 11i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GL enquiries [message #442874]

Thu, 11 February 2010 02:03

sbuda84@gmail.com
Messages: 2
Registered: February 2010
Location: South Africa

Junior Member

Hi i need help with writing the three scripts

GL Open Bal :

GL_ACCOUNT
GL_ACCOUNT_TYPE
OPEN_BALANCE
PERIOD_NAME

(For table "GL Open Bal" Please provide a record count and total for field "Open_Balance")

GL Close Bal :

GL_ACCOUNT
GL_ACCOUNT_TYPE
CLOSING_BALANCE
PERIOD_NAME

(For table "GL Close Bal" Please provide a record count and total for field "Closing_Balance")

Journal Approvers :

Employee
Authorization Limit
Approvers

(For table "Journal Approvers" Please provide a record count)

I'm really struggling with this as I'm an Oracle Apps dba and a newbei in Oracle Apps.

You help is appricated.

Thanks
Sibusiso

Report message to a moderator

Re: GL enquiries [message #442924 is a reply to message #442874]

Thu, 11 February 2010 06:53

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

You may need to provide sample data and required output.

By
Vamsi

Report message to a moderator

Re: GL enquiries [message #442926 is a reply to message #442924]

Thu, 11 February 2010 06:55

sbuda84@gmail.com
Messages: 2
Registered: February 2010
Location: South Africa

Junior Member

Hi

does this make sense

SELECT cc.concatenated_segments "GL Account",
cc.gl_account_type "Account Type",
nvl(sum(bal.begin_balance_dr - bal.begin_balance_cr + bal.period_net_dr - bal.period_net_cr),0) "Closing Balance",
bal.period_name "Period Name"
FROM gl_code_combinations_kfv cc,
gl_balances bal
WHERE cc.code_combination_id = bal.code_combination_id AND bal.period_name ='ADJ-2009' AND bal.set_of_books_id ='1' GROUP BY cc.concatenated_segments,
cc.gl_account_type,
bal.period_name
ORDER by cc.concatenated_segments;

Report message to a moderator

Re: GL enquiries [message #443282 is a reply to message #442926]

Sun, 14 February 2010 21:39

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Anyway you got the answer in the OTN thread.

By
Vamsi

Report message to a moderator

Previous Topic:	inventory items import issue (merged 2)
Next Topic:	Dependent package of per_all_people_f table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 18:10:03 CST 2024