Skip to Content
0
Former Member
Apr 25, 2014 at 08:33 AM

How to call Oracle Functions in SMP 2.3

30 Views

Hi Experts,

I am developing Login functionality in SMP.2.3 using Oracle EBS Backend.

here is my table

From this table i have to login my application(i.e., Hybrid Application).

The password is encrypted here by using Oracle Validate_login() function we have to login the application. It will return Y/N only.

if it is 'Y' login is sucess, if 'N' login failed.

In SMP2.3

I created a MBO with Oracle Validate_login() function when i clicked on preview it shows below screen

Here i gave two personalization keys for user and password arguments.

Next i deployed the MBO.

Created a xbw file

in Type i selected Onlinerequest, Slected that Validate login funciton MBO, and the object query is findall.

But in parameter mappings and personalization key mapping i didnt find any keys.

Here i was strucked. how to give the parameter mappings that validate the login funciton.

So if anybody have solution please guide me.

any help will be appreciated.

Thanks & Regards,

Sravanya.K

Attachments

db.png (170.6 kB)
db function.png (14.5 kB)
mbo.png (206.4 kB)
mbo1.png (175.5 kB)
xbw.png (220.2 kB)
mbo3.png (211.8 kB)