OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » AP Invoice DFF should be updatable

Home » Applications » Oracle Fusion Apps & E-Business Suite » AP Invoice DFF should be updatable (Oracle EBS R12)

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

AP Invoice DFF should be updatable [message #467640]

Mon, 26 July 2010 06:23

kaush217
Messages: 6
Registered: July 2010
Location: Mumbai

Junior Member

At AP Invoice workbench, we have created a DFF for entering credit memo information.

The issue is that if a invoice is partly paid, the invoice get freezed and we cannot make any changes to the invoice, even the DFF information and fields gets freezed.

How can we make atleast this DFF field updatable even after making the payments. Can we achieve thru personalisation or customisation or thru some normal process??

Please help

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467679 is a reply to message #467640]

Mon, 26 July 2010 11:39

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

The status of the invoice will not allow any field to be updated. There is no normal process that will allow it. You can however try the customization. I didn't test it, but I would try to set a customization with a trigger on WHEN-NEW-ITEM-INSTANCE for the DFF.

Regards,

Arian

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467692 is a reply to message #467679]

Mon, 26 July 2010 13:43

kaush217
Messages: 6
Registered: July 2010
Location: Mumbai

Junior Member

Thanks for your reply.

Can you help me with the steps on how we can achieve this.

Regards.

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467696 is a reply to message #467640]

Mon, 26 July 2010 14:18

Alien
Messages: 292
Registered: June 1999

Senior Member

I'll have to do some set-up on my test system. I can test it tomorrow at the earliest.

Regards,

Arian

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467765 is a reply to message #467696]

Tue, 27 July 2010 04:45

kaush217
Messages: 6
Registered: July 2010
Location: Mumbai

Junior Member

I will wait for your update.

Thanks in advance.

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467854 is a reply to message #467765]

Tue, 27 July 2010 14:04

Alien
Messages: 292
Registered: June 1999

Senior Member

Ok.

I couldn't get the invoices to be frozen. Moreover, I couldn't get all flexfields to be enabled/disabled.
Which DFF are you using?

In my testsystem, I enabled / disabled a flexfield:
Condition: WHEN-NEW-BLOCK-INSTANCE
Trigger object BAT_SUM_FOLDER

Action:
Type: Property
Target object: BAT_SUM_FOLDER.DESC_FLEX
Property name: Enabled (or) Updatable
Value: False (or) True

In your case, you will need to see which flexfield you want updatable, and what the matching object is. Most of them are '<block>.desc_flex'. Then you can set updatable to TRUE. You might have to update 'Enterable' too.

Regards,

Arian

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467892 is a reply to message #467640]

Wed, 28 July 2010 02:26

kaush217
Messages: 6
Registered: July 2010
Location: Mumbai

Junior Member

Dear Arian,

Thanks for your update.

I have attached some screenshot of the exact requirement for your reference.

Regards.

Attachment: DFF_1.JPG
(Size: 48.04KB, Downloaded 1112 times)

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #467893 is a reply to message #467892]

Wed, 28 July 2010 02:26

kaush217
Messages: 6
Registered: July 2010
Location: Mumbai

Junior Member

Another screeshot for the DFF created in sys admin

Attachment: DFF_2.JPG
(Size: 45.81KB, Downloaded 1090 times)

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #468331 is a reply to message #467640]

Thu, 29 July 2010 13:36

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

I can't get that particular flexfield updated. Most others work well, but of course not this one.
Is it an option for you to put the code in the custom.pll?

Regards,

Arian

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #468806 is a reply to message #468331]

Mon, 02 August 2010 04:24

kaush217
Messages: 6
Registered: July 2010
Location: Mumbai

Junior Member

We are doing this in R12, so i think we cannot use custom dll.

Anyother alternative that you can suggest??

Regards

Report message to a moderator

Re: AP Invoice DFF should be updatable [message #468971 is a reply to message #468806]

Mon, 02 August 2010 13:35

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

In R12 custom.pll is still available. It will be your easiest option, since you can call a fnd_descr_flex.update_definition package, to re-enable the flexfield.

Other options include: A custom form, called from a menu in the Invoice workbench;
Enabling the whole form for update, and disabling the fields that should not be updateable.

Regards,

Arian

Report message to a moderator

Previous Topic:	submit concurrent request from oracle report 10g
Next Topic:	Workflow : HR / iRecruitment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 04:29:34 CST 2025