Do you know there are 475,000 Oracle certified professionals across the globe. Few credentials in the business world carry the value of Oracleapps certification for Consultant. Take the advantage of getting certified. Out of five major set of certification , OCE is being provided in OracleApps Area.

What is OCE...

aka.Oracle Certified Expert

This is advanced certification that required proven project experience, business process knowledge, and a more detailed understanding of Oracle Application Implementation solutions. This is new type of specialization certification which recognize competency in specific technologies, architectures or domains.

Available Certification

These are the certification currently available in Oracle Application area Covering R12.

• Oracle E-Business Suite R12 Financials Certified Expert Consultant, Payables (OCE)
• Oracle E-Business Suite R12 Financials Certified Expert Consultant, Receivables (OCE)
• Oracle E-Business Suite R12 Supply Chain Certified Expert Consultant, Purchasing (OCE)
• Oracle E-Business Suite R12 Supply Chain Certified Expert Consultant, Order Management (OCE)
• Oracle E-Business Suite R12 Advanced Supply Chain Planning Certified Expert Consultant (OCE)
• Oracle E-Business Suite R12 System Administrator Certified Expert (OCE)

Where to start with

If you are planning for certification , check out the Mohan's Blog, this is good starting point. You can also check the Oracle web site for Certification details , pre-requisite , training requirement and and Fee structure.

Sometime you can't understand why user want specific things which really does not have good cause. The one such case is turning off Horizontal menu in one of the Oracle EBS forms.

If this is the case, there is no shortcut or profile option, rather you need to take technical help some who can open the form in Builder.

If you required to eliminate the forms default menu?

Here to go:

In the Form Builder, open the property palette for the Form. Highlight the form name. Right mouse click to open the property palette. There should be listed a menu - the default menu is default & smartbar. Just Delete this.compile and restore within the application top of form sub folder.

Anyone have better idea , to turn off horizontal menu ???

Most of developer always struggle when ever it come to migration of form personalization component, beacuse of limitation of full access in Production box. Therefore, It's better to use oracle seeded Migration tool FNDLOAD.

Once you created and done testing for personalizations in your development/test instance, you can move them to production instances.

As discussed in last post, Personalization is per Function not per form therefore this can extracted by the loader on a per-function basis.

You should take a note that upon uploading, all prior personalizations for that function are first deleted, and then the contents of the loader file are inserted. So be careful..)

FNDLOAD - A pain killer for migration

you can either Download for a specific form or specfic function of the form. In both the case same affrmcus.lct is used.

Download -specific form< /STRONG>

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES
form_name=<form name>< /FONT>

Download -for all personalizations< /FONT>

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>< /FONT>

• Function_name is a required parameter
• You cann't download lct file with out any supplied value.

Upload
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt>

Uasge

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct xxapperiod.lct FND_FORM_CUSTOM_RULES form_name=APXSUMPS

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct xxapperiod.lct

Because the architecture has built-in support for all languages, you don’t translate ldt files, but instead you enter multiple Actions for different languages.