OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to make non editable Recovery Rate filed in Invoice Distributions?

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to make non editable Recovery Rate filed in Invoice Distributions? (11.5.10.2)

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

how to make non editable Recovery Rate filed in Invoice Distributions? [message #423576]

Fri, 25 September 2009 06:39

Chinnu_7707
Messages: 5
Registered: January 2008
Location: Bangalore

Junior Member

Hi,

Our customer have the requirement to disable Recovery Rate in distributions in order to avoid changes of recovery rate.

I've tried using Forms Personalization but unfortunately I couldn't figure out the correct parameters to set in order to have no errors.

My Form Personalization Setup in Requisition:
1. Function Name: AP_APXINWKB
2. Form Name: APXINWKB
3. Debug Mode: Off
4. Seq = 1
5. Description = Disable Recovery Rate
6. level = Function
7. Enabled = Yes

Condition Region:-
8. Trigger Event: WHEN-NEW-RECORD-INSTANCE
9. Trigger Object: D_SUM_FOLDER
10. Condition: nil
11. Processing Mode: Both
12: Level = Site

Actions Region:
13. Seq = 1
14. Type = Property
15. Description: Disable Price
16. Language: All
17. Enabled: Yes
18. Object Type: Item
19. Target oBject: D_SUM_FOLDER.TAX_RECOVERY_RATE
20. Property Name: ENABLED
21. VALUE: FALSE

Then [save] and [Apply Now].

But once I'm in the distribution Screen and go into Calculate Tax or After TAB, an error message prompt and shows the below message:

"FRM-41316: Canot set Insert Allowed property of disabled item LINES.UNIT_PRICE"

Kindly advise on the my forms personalization setup.

REgards
Murali

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #423588 is a reply to message #423576]

Fri, 25 September 2009 07:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

First "enable" the item, then "allow insert" into it. It is not possible to allow inserting if an item is disabled (i.e. user can not navigate to it).

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #423917 is a reply to message #423576]

Tue, 29 September 2009 04:26

Chinnu_7707
Messages: 5
Registered: January 2008
Location: Bangalore

Junior Member

Hi littlefot,
your solution will make recovery rate editable, but here i need it shold be visible but not updatable.

Regards
Murali

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #423918 is a reply to message #423576]

Tue, 29 September 2009 04:34

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

You might be better off asking this question in the Oracle Apps forum - I assume it is oracle apps?

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #423970 is a reply to message #423918]

Tue, 29 September 2009 10:05

Chinnu_7707
Messages: 5
Registered: January 2008
Location: Bangalore

Junior Member

Hi Cookiemonster, yes true this is with regard to oracle apps...thax for guiding me

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #423981 is a reply to message #423917]

Tue, 29 September 2009 14:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Chinnu_7707 wrote on Tue, 29 September 2009 11:26

Hi littlefot,
your solution will make recovery rate editable, but here i need it shold be visible but not updatable.

I misread the question, sorry. I thought that you want to make it editable.

OK then, how about making that item a "display" item (that can be done by setting its "Item type" property).

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #424071 is a reply to message #423981]

Wed, 30 September 2009 03:15

Chinnu_7707
Messages: 5
Registered: January 2008
Location: Bangalore

Junior Member

Hi Littlfoot

I think you have not understand my requirement.

In invoice distributions screen when i enter a tax code, recovery rate field will be automatically picked up from database which is editable. here is my requirement.

Recovery rate field should be able to insert from database when i press tab but not editable/updatable. once i get the value into filed should be grayed out.

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #424248 is a reply to message #424071]

Thu, 01 October 2009 01:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I see ... Well, I'm not familiar with Oracle Apps. but, if there's any similarity with Forms, then you could, perhaps, check what "Update Only if NULL" item property does. If I correctly understood what you've said, this property should be set to "Yes".

Report message to a moderator

Re: how to make non editable Recovery Rate filed in Invoice Distributions? [message #428637 is a reply to message #423576]

Thu, 29 October 2009 04:29

SSGKK
Messages: 19
Registered: March 2009

Junior Member

Try this
Condition Region:-
1. Trigger Event: WHEN-NEW-ITEM-INSTANCE
2. Trigger Object: D_SUM_FOLDER.TAX_RECOVERY_RATE
3. Condition: nil
4. Processing Mode: Both
5: Level = Site

Actions Region:
1. Seq = 1
2. Type = Property
3. Description: Disable Insert
4. Language: All
5. Enabled: Yes
6. Object Type: Item
7. Target oBject: D_SUM_FOLDER.TAX_RECOVERY_RATE
8. Property Name: INSERT_ALLOWED(ITEM-INSTANCE)
9. VALUE: FALSE
10. Seq = 2
11. Type = Property
12. Description: Disable Update
13. Language: All
14. Enabled: Yes
15. Object Type: Item
16. Target oBject: D_SUM_FOLDER.TAX_RECOVERY_RATE
17. Property Name: UPDATE_ALLOWED(ITEM-INSTANCE)
18. VALUE: FALSE

Cheers
SSGKK

Report message to a moderator

Previous Topic:	Payable s & Recievable oracle training materials
Next Topic:	Form Personalisation in AP invoice Distribution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 10:30:01 CDT 2025