Home » Applications » Oracle Fusion Apps & E-Business Suite » how to make non editable Recovery Rate filed in Invoice Distributions? (11.5.10.2)
how to make non editable Recovery Rate filed in Invoice Distributions? [message #423576] Fri, 25 September 2009 06:39 Go to next message
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

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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
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 Go to previous messageGo to next message
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.

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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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".
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 Go to previous message
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
Previous Topic: Payable s & Recievable oracle training materials
Next Topic: Form Personalisation in AP invoice Distribution
Goto Forum:
  


Current Time: Fri Dec 09 06:14:28 CST 2016

Total time taken to generate the page: 0.09326 seconds