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.

Chapters 2 and 7 of the Oracle Alert User Guide covers Transfers Process.

These are command you can use:

1. Command to download

FNDLOAD apps_user_name/apps_password 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct my_file.ldt ALR_ALERTS APPLICATION_SHORT_NAME=FND ALERT_NAME=Alert name to download

Usage

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct CMS.ldt ALR_ALERTS APPLICATION_SHORT_NAME=’AR’ ALERT_NAME= ‘CMSEXCEPTION’

2. Command to upload

FNDLOAD apps_user_name/apps_password 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct my_file.ldt

Usage

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct CMS.ldt

You can use some additional parameters such as

• ALR_DISTRIBUTION_LISTS APPLICATION_SHORT_NAME=AD where APPLICATION_SHORT_NAME represents the Application Alert owner
• ALR_LOOKUPS
• ALR_MESSAGE_SYSTEMS
• ALR_ORACLE_MAIL_ACCOUNTS
• ALR_PROFILE_OPTIONS
• ALR_PERIODIC_SETS APPLICATION_SHORT_NAME=ALR

Further Reading

• Its all about FNDLOAD
• Great FNDLOAD – Part -II
• FNDLOAD for AME’s

Few reader question..

1. What is the difference and theory behind Oracle terminal releases and terminal patchsets ?
2. What are Critical patch updates ?
3. What is the terminal release after 11.5.10 CU2? or Do you have 11.5.10 CU3/CU4?

Terminal release means that the version specified is the last point release of that product. For example, the “terminal release 11.5.10” for the 11i E-Business Suite would mean that there will not be any further releases of 11i after 11.5.10. Specifically, that would mean there will not be a release 11.5.11 for 11i.

The terminal patchsets means that would the last patchset provide on that particular release.

This is very simple as this example:
In 10g Release 2 the last patchset would be 10.2.0.4, upon further there won’t be any more patchset will be released under this version.
In 9.2 release the last patchset is 9.2.0.8, upon further there won’t be any more patchset will be released under this version.

In other word :Terminal meaning no more patchsets are going to be delivered, so you will be forced to either apply one-offs or upgrade.

Critical patch updates

Oracle provides critical patch updates (CPUs) to its customers to fix known bugs that are critical in nature also includes security fixes.

Critical Patch Updates are the primary means of releasing security fixes for Oracle products:(Adpoted-otn )

• A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes nonsecurity fixes that are required (because of interdependencies) by those security patches.
• Due to the threat posed by a successful attack, Oracle struongly recommends that fixes are applied as soon as possible.
• CPUs are released on the Tuesday closest to the 15th day of January, April, July and October each year

You can find information at Oracle Technology Network .

Q .What is the terminal release after 11.5.10 CU2? or do you have 11.5.10 CU3/CU4?

It’s just a matter of terminology.There was the original 11.5.10 install (or upgrade maintenance pack).Then came 11.5.10.1CU (3240000), 11.5.10.2CU (upg from 1CU 3460000) and 11.5.10.2CU (upg from pre-11.5.10 3480000).

Since there was change in stretegy that why here are the details for ATG Rollup patchsets

• CU3 = ATGRUP3 (4334965)
• CU4 = ATGRUP4 (4676589)
• CU5 = ATGRUP5 (5473858)
• CU6 = ATGRUP6 (5903765) :This is the latest

Oracle EBS 11i Technology support Matrix

Metalink Notes

• 738923.1 :Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Note (January 2009
• 315713.1 rior E-Business Suite Security Alerts
• 329689.1 :E-Business Suite (Oracle Applications) 11.5.1 through 11.5.6 Desupport Notice
• 363827.1 :Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10

Refrence Link :

• ATG Blog for support ,desuuport and certify infohttp://blogs.oracle.com/schan
• Oracle Lifetime Support Policy

For new Implementation, certain things never focused by implementation team i.e user desktop configuration which might be a big reason that is reported by end user once Business switch to new system. This is specially true, when your client belong to SME’s (Small and medium enterprise).

Lets me summarize few issue with File ->Export

1. User Unable to Export Data to TSV File
2. Export functionality does not prompt for saving the file.
3. Data export from Oracle form is missing some rows in the output file , specially from AP Invoice workbench , Gl account enquiry screen and AR Transaction workbench

Some of them are purely desktop issue, still you need to do such steps if such things being reported by remote users.

Do verify the following:

1. You should have the following Viewer Option entry: File Format Mime Type Description Allow Native Client Encoding
   ————– ——————————– ——————– ———————–
   Excel application/vnd.ms-excel Microsoft Excel Checked
2. Check out the table FND_MIME_TYPES_TL entry. A row contains an entry for FILE_FORMAT_CODE = “EXCEL” and MIME_TYPE =”application/vnd.ms-excel”

Next you need to verify these details:

1. What is the windows OS on your computer (XP, W2000, etc…)? Which service pack?
   i.e.: Microsoft Windows XP – Profesionnel – Version 2002 – Service Pack 2 check the comptability matrix.
2. Version of excel on user computer.
3. Version of Internet Explorer in user computer.
4. Deactivate any pop-up blockers in windows XP or in Internet explorer
5. You need to do a try to compare the two computers? (The computer where you have the issue and the computer where the export is working)
6. Try the following as part of quick check:
   In the Tools -> Internet options, set the following:
   • Open Internet Explorer and choose Tools–>Internet Options
     • Click on the Security Tab
     • Click the Custom Level button
     • Scroll down to the “Downloads” options
     • Enable the option “Automatic prompting for file downloads”
     • Enable the option “File Download”

Once you done, close browser, open browser than try to export again.

If still getting an error , you need to verify these details too.

• In Internet Explorer select the Tools menu – Internet Options – Security – Custom Level
• Adjust all the settings for ActiveX Controls and Downloads to be either ‘enable’ for the following zones :
  • - Internet
  • - Local Intranet
  • - Trusted Zones
• Try to add the site of instance to Trusted Zone and adjusted Security level to Low protection.
• Restart the browser and now test.

99% chances that you can able to resolve 1 and 2 , else not, ask Oracle with SR and wait for a day.

For 3,you need to check with Oracle, there might be chances the version of form is bit lower.

Similar Post

• ‘File ->Export’ Function is troubling
• Setting default to Excel for Exported file from “File ->Export “
• File -> Export : Enabling or disabling

User may request you for enabling or disabling menu for File -> Export in Oracle Forms.

Take a note, File ->Export works itself on the basis of User Cursor Control.

1. If Cursor control is at block where we can view multiple records at a time, the Export function is enabled.

2. If Cursor control is at block where we can view single record at a time, the Export function is disabled.

The reason for providing this functionality is that if there are many records in a block, then it might be difficult for the user to scroll down to view all the records in that block. So, the user can actually export them using the Export function.

Moreover there is no profile option which gives you control for this function.

Oracle Applications allows you to export data that you see on the form to a file – like excel – which can be then be used as a normal excel file. These are really useful when you want a quick dump of the data for reference or are trying to trouble-shoot some issue.

The File – Export option allows you to dump the data you see on the form (or data set you have queried).

The default is a file type called “tsv”, that means tab separated values and can be opened by default in Notepad in most cases, but can also be configured to open in Excel, which is a choice for most of user.

Problem : How Can you do a Setup File->Export as an XLS Type File default?

Here are the steps

1. Go to Explore(not IE) ->Tool -> Folder Options

Fig 1

2. Check out for TSV File format , if not exist , create a new type by Pressing NEW button.

Fig 2

3. Now you need to setup default to excel, go to change Button in fig 2, and point to Microsoft Excel

Fig 3

Hard Time this week for me ,struggling with Finance user from another entity to see unexpected things reported , Out of the box File -> export function was not working properly, some of them reported Browser crashing some of them reported data not exported 100% from form, some of them reported longer duration to export for nearly 500 records from Invoice Inquiry or Invoice Entry form.

There are few cases which user can experience

• File – Export does not bring up a Save As prompt
• File -Export may leads to Browser crashes
• File – Export takes long time to export into Excel
• File – Export not exporting 100% data from form
• File – Export creates zero byte file
• File -Export on selecting “Continue to End” causes system to hang

More less, these problems are encountered by some additional setup requirement in IE . Here are few troubleshooting points, if you are using IE 6 or 7.

1. Make sure your browser will have setup completed for these 2 categories:

You should follow these Steps:

• Go to IE Tools menu – Internet Options – Security – Custom Level
• Adjust all the settings for ActiveX Controls and Downloads to be either ‘enable’ or prompt for zones Internet, Local Intranet, and Trusted Zones
• Restart the browser and now test if the export process works

2. Make sure if users desktop are using a proxy server to access the web via MSIE. If you set “Bypass proxy server for local addresses” in Internet Options -> Connection -> LAN Settings check if the File > Export works without error.

3. Make sure you have set System Profile Options ‘Export: Mime type’ to ‘text/tab-separated-values’ or or ‘application/vnd.ms-excel’

4.Delete Browser Cache > Tools > Internet Options > zone=temporary internet files : delete files {checked offline content}

5. You should also delete C:program files/oracle/jinitiator<version>/jcache/*

6. Make sure you disable Pop-up Blocker

7. If you have still an issue , try this based out of note :338545.1

• Make sure you have checked step 1,2,3.
• Login to AP responsibility and try exporting from the data from Invoice workbench after search for invoice batch.
  Are you able to export?
• If not ,Go to (Tool Bar) Help -> Diagnostics -> Examine
  Set Block = ENVIRONMENT
  Set Field = FND_EXPORT_DEBUG
  Set Value = TRUE
• Export and observe the messages that are generated during the export process.
  What is the last pop up message ?
• Try to run the following piece of code in SQLPLUS*

declare
db_file number;
mime_type varchar2(255) :=’text/plain’ ;
out_string varchar2(32767) :=’Just some plain text that is stored’ ;
web_server_prefix varchar2(500);
url varchar2(500);
begin
fnd_global.apps_initialize(user_id => <put your user id>,resp_id => <put your resp id>,resp_appl_id => <put your appl id>);
DBMS_SESSION.SET_NLS(‘NLS_LANGUAGE’,'AMERICAN’);
db_file :=fnd_gfm.file_create(content_type =>mime_type,program_name=> ‘export’);
fnd_gfm.file_write_line(db_file,out_string);
db_file :=fnd_gfm.file_close(db_file);
url:=fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,db_file,TRUE);
dbms_output.put_line(url);
end;

If still not able to fix, ask Oracle for further resolution.

8.If you are not able to 100% export in excel do a quick check

Run this query immediatly after Export get completed
select count(*) from fnd_lobs where program_name=’export’;

If counts not matches then you need to recreate the index using script $FND_TOP/sql/aflobbld.sql. This is because the File/Export functionality of EBS uses system LOB columns to store temp data before it is outputed to a browser. If that temp data becomes large enough as the result of large export query set, then the max_extents limitation of the column is reached thereby causing the export to fail.

Most of my user experinces these issues with WIN2K or XP SP1 and SP2, but not with SP3.No clue for me with service pack.

Is there any linkage with window XP or 2000 .Net Framework installation and Service pack in client desktop for this feature? Do share some thoughts if anyone got such kind of issue in past.

Here is the quick note for Banking Details for Supplier in Release 12, which can be assigned at the following four levels:

1. Supplier
2. Site
3. Address
4. Address-Operating Unit

New accounts can be created using existing bank and branch details or new bank/branches can also be entered.

Banking Details page to define the bank accounts used for making payments to suppliers.

You can select the name and number of the bank account from the list of values that includes all active supplier type bank accounts or you can create a new bank account. For each supplier and supplier site that has bank account assignments, you must designate a primary bank account. The primary bank account is used by Payables as a default when you pay this supplier electronically.You may override the default if necessary.

You can also do setup for bank accounts for a supplier can also be setup from iSupplier portal

Using iSupplier Portal, suppliers can access their banking information and, if given the appropriate security privilege, make changes to the details. The buyer administrator can either approve the account or set the status to Verify. You can use the Verify status while you prenote the account or perform other activities for verifying an account with your bank.

You can find more details for supplier bank here.

Similar Post

• R12 Supplier Bank – Techno Functional Guide
• R12 : Bank & Trading Community Architecture(TCA)
• R12 : EBS Banking Model in demanding and Changing World
• Welcome to R12 Account Payable
• A bit on SEPA – IBAN & BIC