GL - Cross validation

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
cherry
Posts: 14
Joined: Thu Dec 06, 2007 6:11 am
Location: India

GL - Cross validation

Post by cherry »

Guys need your help.

We hve a requirement where in, we have to restrict some CCIDs to be entered from say 'R' responsibility.

We cannot achieve it through cross validation rule because it is based on the SOB level, not at resp.

Kindly let me know of any workarounds if you know of.

Thanks in advance.
farhatmfc
Posts: 24
Joined: Fri Nov 24, 2006 12:10 pm
Location: India

Post by farhatmfc »

can go for security rule but that would be applicable on responsiblilty and not on some specific code combinations
cherry
Posts: 14
Joined: Thu Dec 06, 2007 6:11 am
Location: India

Post by cherry »

Thanks for your reply. Im aware of security rule. But we need to restrict it on CCID's for FEW responsibilities.

Any idea?
AmanKhan
Posts: 387
Joined: Wed Sep 26, 2007 2:51 am
Location: Pakistan

Post by AmanKhan »

Hi,

Security Rules are applicable to responsibilities...

thanks,

AmAn
cherry
Posts: 14
Joined: Thu Dec 06, 2007 6:11 am
Location: India

Post by cherry »

I know security rules are applicable for responsibilities.

My question is, how to restrict CCIDs for a specific resp?

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

Post by admin »

The security can be applied on Flexfield segments but seems cherry you are looking for security on ID's in a table? Please elaborate. If so then check Forms Personalization. Thanks
cherry
Posts: 14
Joined: Thu Dec 06, 2007 6:11 am
Location: India

Post by cherry »

Thanks Admin for your reply.

Let me elaborate. I have single SOB with multiple responsibilities (say R1, R2). When entering Journals, I want to restrict R1 resp user from entering this combination (01.1234.12345678.123.0000).

Above combination is just an example. I have a list of such combinations. Hope it clarifies.

Any suggestions now from experts?
Thanks
Cherry
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

I got your point. You want to restrict code combination at responsibility level and I don't think there is any direct way to do so. What you can do is to create security rules on each segment and include/exclude the values and assign to the responsibility. Now let us know the issue if any you are facing to solve your problem with the help of security rules. Thanks
raviteja.manchu
Posts: 53
Joined: Wed Feb 21, 2007 3:38 am
Location: India

Post by raviteja.manchu »

HI ,

This can not be done with the help security rule or cross validation.So better try with form personalisation.

Thanks & Regards,
Ravi Manchu
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest