Extending and Customizing the Mobile PO Receipt form

A recent project required me to extend and customize the PO Receipt page in the MWA MSCA. The extension of the RcptGenPage and RcptGenFListener was a little more complicated than some of the examples you see out there. It requires a lot more customization and bringing over oracle seeded attributes and private methods. It also requires you to have patience and using the trace debugging method that MWA provides. In this article I hope to help you learn more about how I was able to get this extended and customize the page to allow for a new field and calling pl/sql functions/procedures from within the mobile application.

Source code is available here

The business requirement was pretty simple, but the task was quite daunting. I needed to display an “Item Weight” field after the population of the “Item Number” LOV was populated. The item weight field is required and pre-populated from the item master table (if it exists). The most difficult task for me to do was actually getting the standard functionality of the PO Receipt page implemented. It always seemed to call the original seeded Listener code instead of my listener. I couldn’t figure out why until I brought over every “Private” method that the original listener used. Once I was able to do this it would make a call to my listener first.

Up until now all the code has been “extended” from the oracle seeded receipt pages. Now the customized code processing of this customization starts at the Item text field. When the Item LOV is exited it calls a method fieldExited(). This determines if the INV.ITEM LOV field was the field that was exited. Since it was it called my page code to actually “display” it, then it calls my custom itemExitedX() method. Note, that this method is copied directly from the Oracle seeded code, but has been changed just be executed specifically for the PO RECEIPT page. If you want to implement it for different pages (ie. RMA) then you’ll need to copy it over and insert debug statements to find out its flow through the method call.

Within the itemExitedX() method it does some code handling to determine if the mOrigitemWeightValue variable has been populated. If it hasn’t then it executes another custom method setItemWeight(). This call actually uses a CallableSTatement to call a function I created to pass in the item and return the “unitWeight” stored in the item master table.

Now when the item weight field is modified and exited it always calls another custom method called updItemWeight(). This is called in the locationEntered() method because it is the field that is entered when the Item Weight field is exited.

This is about the gist of the customization I needed to do for the PO Receipt form. If you look through my code you may have done some things different and you may need to change the way things are done. If you know other ways (maybe more efficient ways) to do things please let me know. I always want to learn better ways to do things. We all know that the documentation out there isn’t all that great and doesn’t work for every customization we need to do.

If you need consulting help in MSCA/MWA extensions/OAF customizations or any other consulting needs please contact us. You can also visit us at www.luciditycg.com

Materials & Mfg  Receipts  PO

Set as favorite

Bookmark

Email This

Comments (14)

Subscribe to this comment's feed

...
written by Senthilkumar Shanmugam , February 28, 2009

Excellent work Kyle.

Thanks and Regards,
Senthil

report abuse

vote down

vote up

Votes: +1

Good one
written by Anil Passi-- , February 28, 2009

Hi kyle

This will help many people.
apps2fusion.com/forums had too many requests for this article, thanks for publishing the same.

Cheers,
Anil Passi

report abuse

vote down

vote up

Votes: +0

Thanks
written by tutu1121 , March 01, 2009

Thansk a ton

report abuse

vote down

vote up

Votes: +0

help
written by Moahmmed , February 03, 2011

am try to do same thing , but its not working
when i enter the Po Num , it give me ( No result is found ), and the LOV is empty , when i press on it , give me the same error

report abuse

vote down

vote up

Votes: +0

PO customization
written by shailendrasingh , February 04, 2011

hello Senthil,
i am cutomizing PO reciept form,in this i have to add two fields so i extend all three classes,
every thing is working fine but LPN field is not getting display on the page.

please give me soltion.

thanks
shailendra

report abuse

vote down

vote up

Votes: -1

...
written by Vincent Maseko (South Africa) , March 24, 2011

Hi Kyle,

This is a brilliant post!
Especially the source code - it is helping me a lot in my customization.

Ta,
Vincent

report abuse

vote down

vote up

Votes: +0

...
written by Kyle Thomas , March 24, 2011

You're very welcome Vincent! Glad you found it resourceful.

report abuse

vote down

vote up

Votes: +0

PO Receipt Customization
written by Gowri Shankar , April 07, 2011

Hi Kyle,
We are in R12.1.1. We are using the Mobile Application for receiving the LPNs. There is a requirment to have the following restrictions in Receiving

To restrict the multiple receipts of single LPN. (sometimes user are doing muliple LPN scanning while Receiving, we need to avoid this).
To restrict the assignment of more than one item in a LPN (while receiving).

I believe we need to extend the PO Receipt MWA form. Can you please guide me on this, as I am new to Mobile Application.
Thanks,
Gowri.

report abuse

vote down

vote up

Votes: +0

...
written by Kyle Thomas , April 07, 2011

Gowri,

I recommend you going through and doing a few of the samples: http://www.apps2fusion.com/app...-framework

This will guide you to learn how extending these forms work and what you need to do to set them up.

You can refer to my source code to give you some help as well. I no longer work with the mobile web apps so I won't be much help unless you're stuck with an issue that I faced.

Regards,
Kyle

report abuse

vote down

vote up

Votes: +0

Is there a way we can run Mobile PO receipt on Browser enabled mobile device?
written by mobidev , April 21, 2011

Would like to run Mobile PO receipt on Browser enabled mobile device.
Without installing patches or Java classes on mobile device, is there a way we can get GUI feature for Mobile PO receipt?

report abuse

vote down

vote up

Votes: +0

...
written by Kyle Thomas , April 22, 2011

Not to my knowledge. The only way I see that possible is recreating the application using ADF. This would allow you to develop an application that not only runs on a regular browser but has the capability to run on any mobile device as well.

You would not be able to "extend" these classes as this would be a complete rewrite of the application.

report abuse

vote down

vote up

Votes: +0

PO Customization
written by AmitSrivastava , May 09, 2011

Hi Senthil,

I wanted to add a new field in PO receipt mobile form. Please advise how to do this.

Regards,

Amit

report abuse

vote down

vote up

Votes: -1

Want to add Container Number field on ASN Receiving Mobile Form
written by Junaid Iftikhar , May 23, 2011

AS PER MY BUSINESS REQUIREMENT, I WANT CONTAINER NUMBER FIELD TO BE ADDED TO MOBILE RECEIVING FORM , AS I HAVE ONE ASN WITH MULTI-CONTAINERS INSIDE IT . SO I WILL RECEIVE BY CONTAINER AND ASSIGN LPN TO IT..

LOKING FORWARD FOR YOUR KIND RESPONSE,

report abuse

vote down

vote up

Votes: -1

not able to get LOV's
written by swapnaj , December 09, 2011

Hi kyle,
After extending the page,in the new page i am not getting the values for the old lov fields.(for example for existing field like Dock door,field are getting displayed but LOV is not getting displayed)

Can you please help on this.

report abuse

vote down

vote up

Votes: +0

Write comment

Name

Title

Comment