how to restrict posting of journals.

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
stalinvstalin@gmail.com
Posts: 74
Joined: Wed Aug 26, 2009 5:24 pm
Location: India

how to restrict posting of journals.

Post by stalinvstalin@gmail.com »

Hi all,

I have business requiremnet that i have two responsibilites in gl for monitaring journals (clerk,manager)
clerk will enter journals and manager will review them and post either manual,subledgers,legacy.

the requirement is clerk should not have the possibality to edit or post journals he just can enter journal and view journals.how can we achieve this


Thanks &regards,
stalin
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Dear Stalin,

this is a very common requirement, which can by met by MENU EXCLUSIONS feature provided in Oracle System Administrator responsibility while creating your responsiblities for the users ...
You should remove the Posting Functionality from a GL responsibility that is being assigned to the Clerk, so that he will be in a position to enter the journals and view already created journals, but he will not be in a position to post the same ......

Also there is another feature available in GL called JOURNAL APPROVAL, where the users after entering the journals need to submit the journal for review .... a notification is sent to the approver ... upon approving the journal, it becomes eligible for posting ....

Regards,
Karthikeyan
stalinvstalin@gmail.com
Posts: 74
Joined: Wed Aug 26, 2009 5:24 pm
Location: India

Post by stalinvstalin@gmail.com »

Hi karthikeyan,

thanks for your explination.we can restrict posting ok but how can e restrict from editing(doing any modificatins)

for example journals come from legacy,subledger he should not have facility to edit them.

how can we achieve this.

regards,
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Dear Stalin,

I am not sure about the possibility of having "Entering Journals" and "Not Editing entered journals" functionality in the same responsibility ....
We can either deny an user from completly entering any journals or we can deny the user from posting completly ....
Not sure as to whether personalisation / customization could be of any use out here ... will await for other members to comment as to the solution / workaround

Regards,
Karthikeyan
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post by hiszaki »

Hi stalin

You can restrict from editing(doing any modifications) for some / all journals by check the Freeze journals in the Journals source.

But this function will restrict the modification of journals for all responsibilities.

Thanks
Hisham
stalinvstalin@gmail.com
Posts: 74
Joined: Wed Aug 26, 2009 5:24 pm
Location: India

Post by stalinvstalin@gmail.com »

HI,

Can we restrict clerk to edit journals coming from subledgers( either by source or category).I want it for only clerk responsibility as he can enter and edit manual journals but restricted to edit for journals coming from subledgers.

Regards,
Stalin
karthikeyanp1981
Posts: 463
Joined: Thu Nov 09, 2006 4:50 pm
Location: India
Contact:

Post by karthikeyanp1981 »

Dear Stalin,

For transactions that are being transferred from Subledgers, they use very limited account code combinations. For all those natural account segment values you can place the Segment Qualifier of Control Account, which will restrict creating/editing transactions from GL for those account code combinations..... This can be used provided you do not use those subledger code combinations for any other purpose in General Ledger.

Regards,
Karthikeyan
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Try different solutions already posted above and also such controls you can easily implement using Forms personalization. Let us know if still any issue. tks
selvalee
Posts: 1
Joined: Fri Jan 18, 2013 2:00 am
Location: India

Post by selvalee »

[quote]Try different solutions already posted above and also such controls you can easily implement using Forms personalization. Let us know if still any issue. tks

<i><div align="right">Originally posted by admin
Krishi.shonu
Posts: 3
Joined: Tue Feb 05, 2013 8:00 am
Location: India

Post by Krishi.shonu »

Hi,

First: Use Menu Exclusion and take off all the Posting Functions from the Clerk responsibility.

Second: Use Form Personalisation and restrict the editing of all the Journals where journal source is not Manual (Remember when ever you create manually a journal in Oracle it source as standard will be Manual) and spread sheet if you are using web ADI. Any Technical can help you do this.
Post Reply

Who is online

Users browsing this forum: Google Adsense [Bot] and 4 guests