Interview questions on OAF

1. What is the use of spel?
Ans :‐ We pass the dynamically value one page to another page and set the properties
dynamically.

2. Are you extend AM?
Ans:‐ yes , Root AM not suggestable to extends When it has contains LOV items Because Root
AM handles the sessions.

3. Types of VOs?
Ans:‐ 1. Simple VO
2. Entity based VO

4. What are the types of search pages?
Ans:‐ 1. Manual Search,
2. Automatic Search,→auto customization
3. Result Base Search→ResultBased


5. How insert the data?
Ans:‐ VO.Excequte Query();
Row row=vo.create row();
VO.Insert row(row);


6. How to Create the SUBMITT BUTTON in SeadedPage?
Ans:‐ By using Coextension write below code in
OASubmitButtonBean oasb = (OASubmitButtonBean) pageContext.getWebBeanFactory()
.createWebBean(pageContext, "BUTTON_SUBMIT");
OAAdvancedTableBean oatb =(OAAdvancedTableBean) webBean
.findChildRecursive("WOResultsTab");
oasb.setID("SubmitPrintButton");
oasb.setUINodeName("SubmitPrintButton");
oasb.setEvent("SubmitPrintButton");
oasb.setText("Click Here");
oatb.setFooter(oasb);
And set the id name ,node ,prompt by coding


7. How do you bounce the server?
Ans:‐ Inst Top
11i→we bounce APACHE Server
R12→we Bounce Both APACHE And OC4J Server
To bounce these server we need to run below shell scripts
11i
Stop server:‐sh $COMMON_TOP/admin/scripts/adapcctl.sh stop
Start server:‐sh $COMMON_TOP/admin/scripts/adapcctl.sh start
R12
Stop server:‐sh $INST_TOP/admin/scripts/adoacorectl.sh stop
Start server:‐ sh $INST_TOP/admin/scripts/adoacorectl.sh start



8. How do you debug for Custom Pages and Standard pages?
Ans :‐ Custom Pages
1. System.out.println("Message"+item);
         standard pages
1.OApageContext.Write Diagnostics
2 .Debug ‐‐‐‐‐Debug xml files only.


9. What are the Different procedures to pass the value one page to another page?
Ans:‐ Hash Map,
Destination URI→Page Path , Retain AM—>true ,ADD_BREAD_CRUMBS→Yes
AND (Pass the Attribute id(like Item _id and Header_id))


10. What is the diff B/W Table & Advance Table?
Ans:‐ Table Advanced Table
1.It contains row And Columns 1.Same as Table and
2. Rowspan
3. Column Span
4. column Grouping


11. Validation purpose which BC4J you will use for different scenarios why?
Ans :‐ EO and Coextensions based on Requirement.


12. What is the substitution? Where it is use?
Ans:‐ substitution will replace the old VO,EO and AM with the new(or)Extended VO,EO and
AM


13. What are the profile options did you use?
Ans:‐ FND Diagnostics→About the page we are use,
FND personalize self service definition,
FND personalize Region link Enabled,
FND personalize Document Root Path

14. In PageContext.Setforward URL(Retain AM→True
→False
And
ADD_BREAD_CRUMBS→yes
→No) what it shows?
Ans:‐ In PageContext.Setforward URL(Retain AM→True→Transfer the data Another page,
→False→Doesn’t Transfer the data another
page
And
ADD_BREAD_CRUMBS→yes→maintain the same URL total Project
→No→Doesn’t maintain the same URL total Project.


15. How to Disable the Button Seeded Page?
Ans:‐ Extended The CO and ofter
OAsubmittButtonBean mitt =( OAsubmittButtonBean)
WebBean.FindChaildRecursive(Cancel_button);→intialize the Button Bean
Mitt.SetDisable(True);


16.What is the diff B/W Viewlinks and Entity Associations?
Ans:‐ View links Entity Associations
1. Fetch the master details Data 1.Perform The DML operations

17. What are the diff B/W Fire Action ,Fire Partial Action AND Partial Page Rendering(PPR)?
Ans:‐ Fire Action Fire Partial Action Partial Page Rendering
1. Total page Refresh 1.Total page Refresh 1.perticular item Refresh
2. Cursor will be moved first position 2. Cursor at same position 2.It is used in dependent
poplist


18. What is dbc? What is the use?
Ans:‐ dbc means Database connection descriptior file and All the data base connection
information Available in this file .
Like HOST NAME:‐DB_HOST
PORT NUM:‐DB_PORT
SID:‐DB_NAME


19. HOW do you configure JDeveloper in local system?
Ans:‐ Go to Apps→About the page→Technology components→ OAFrame Work:‐12.1.1
Ofter→ Java System profile →Get dbc file path→ ofter download the Jdeveloper use Meta
link


20. What are the versions use in 11i and R12?
Ans:‐ 11i→ JDeveloper 9i,
R12→→ JDeveloper 10g→10.1.3.3.o


21. What is an entity object?
Ans:‐ Entity object is created based on a database table, it is responsible for
insertion/updation/validation of the table data. They are stored in the
oracle.apps.<prod>.<application>.schema.server package directory


22.What is an Application Module(AM)?
Ans:‐ Application module holds the related objects pertaining to an application ie. View
objects, Entity Objects etc. The application module helps in getting the required database
connection, maintains the page session or transaction context


23.What is the object passed to every page request?
Ans:‐ OAPageContext object is passed to every request, using this object the controller
initializes the application module object and will call the required methods.


24. How to call the Concurrent Program from OAF?
Ans:‐we need to know Concurrent Program(CP) CP name ,CP Parameters ,Application Name
We have submit Request method to call particular CP for that we need to add above
parameters.CP Parameters will be captured by Vector Class.
Vector is Collection when we want process more than one value


25. Diff B/W Call able statement and prepare statement?
Ans:‐ Callable statement prepare statement
Packages sql queries


26. How to move the personalization’s in one instance to another instance?
Ans:‐ Two methods are there 1.front end method
2.Back end method.
1. Front end method: ‐ Go to Functional Administrator→ Personalization’s→
Import/Export→ Personalization Repository/Exported personalization’s→
Select the Personalization file→Click on Export File system
We need to import Personalization into the instance
Import/Export→ Personalization Repository/Exported personalization’s→
Select the Personalization file→Click on import File system.
2. Back end method:‐
We need to find out the personalization path by using
Begin
Jdr_utils.list_customization(‘pagepath’);
End;
Run jradxml export script
Run JRADxml import script


27. How to call the one OAF page to another OAF page?
Ans:‐ 1.Pagecontext.Setforward URL(),
2. Pagecontext.Forward immediately (),
3. Pagecontext.send Redirect()
4.Destination URI:pagepath&reatinAM=Y&addBreadCrumb=Y&variablename={@Header
Id}


28. How to Create the Region in the Standard page?
Ans:‐we need to create a shared region in dummy workspace.
Eg: Region Style :Table
Create Table Region using wizard.
Go to Standard Page→add new item Style:‐ Stack Layout→extends:‐Region Path
Move all Class Files to
Run Import Script
For functionality of the Region we need to extend the CO.


29. How do you create the dependent pop list in standard page?
Ans:‐ In Process Request()
//Please attach PPR only to those UIX beans which support it //otherwise it may not work
OAMessageChoiceBean mcb=(OAMessageChoiceBean)webBean.findChildRecursive("");
FireAction firePartialAction = new FirePartialAction("empPositionChange");
mcb.setAttributeValue(PRIMARY_CLIENT_ACTION_ATTR,firePartialAction);
In Process Form Request
Write Dependent poplist code as in Custom Page


30. Extension Steps for VO?
Ans:‐ Download the page, AM, VO and CO.
Create the folder structure as per the page definition and create a dummy workspace and
with extending the VO, and add the required logic in the View Object, Attach it to the
Application Module and subsitute the VO with extended VO and run the XMLImporter script.


31. Extension Steps for EO?
Ans:‐ Process of extension is same and Extension is a combination of Substitution and
Personalization. If you have extended the BC4j component you have do the personalization


32. Extension Steps for CO?
Ans:‐ Process is same


33. Extension Steps for AM?
Ans:‐ Process is same


34. How to Enable the kff and dff?
Ans:‐


35. How to create the dependent LOV in page?
Ans:‐ eg:‐In Master LOV →Create Lov Map
LOV Map1
LOVRegion item:‐takes it table region attached to lov
Return Item:‐MasteLov ID name
Criteria Item: MasteLov ID name
LOV Map2
LOVRegion item:‐takes foreign key column from table region attached to lov
Return Item:‐Link
Criteria Item:none
Create an Item for Linking two LOV’S
Item style:form value
Item id:link
In Detail LOV →Create Lov Map
LOV Map1
LOVRegion item:‐takes it table region attached to lov
Return Item:‐DetailLOV ID name
Criteria Item: link

36. How to call the D2K form to OAF page?
Ans:‐String Destination = ”form : application_short_name :responsibility_key
:data_group_name :form_function_name”
pageConetext.forwardImmidiatlyTo Form(Destination)


37. How to Create the POP Ups without Java script?
Ans:‐ String page ="/sample/oracle/apps/po/hello/webui/SamplePG";
String URL = APPS_HTML_DIRECTORY + OAWebBeanConstants.APPLICATION_JSP + "?" +
OAWebBeanConstants . JRAD_PAGE_URL_CONSTANT + "=" +Page +"&retainAM=Y";
OAButtonBean Button = (OAButtonBean)webBean.findChildRecursive("button on click u
want to open window");
OABoundValueEmbedURL sample = new OABoundValueEmbedURL(Button , "
openWindow(self, '", URL, "' , 'longTipWin', {width:"1000",
height:"500",top:250,left:250,resizable:0}, true); return false;");
Button.setAttributeValue(oracle.cabo.ui.UIConstants.ON_CLICK_ATTR, sample );


38. What are the API’s uses in OAF?
Ans:‐ Fnd_User_Pkg.Disable user,
Fnd_User_Pkg.Enable user etc…..


39.What are the diff B/W inline LOV & External LOV?
Ans:‐Inline LOV will be used only single page.
External Lov can be used anywhere in the project.
LOV Item→extnds:‐path of external Lov Item.


40. PPR follows GET or POST flow?
Ans:‐POST flow


41. What are the methods in controller?
Ans:‐ Process data ,process form request, process request


42. How to add the columns in EO in seeded page?
Ans:‐ Extended the EO and Ofter the synchronize the EO


43. How to add the columns in EO in Custom page?
Ans:‐Delete all the data from the table and alter the table by adding new columns.
And then Synchronize with Database on EO


44. What is MVC Architecture?
Ans:‐ Architecture means set of rules and services called architecture
MVC:‐ model view controller
Model:‐ All the data base transaction called model.
Like→Tables,Synonyms,PL/SQL procedures,functions….etc
View:‐Display the OAF output called view and also called USER INTERFACE.
Controller:‐ The output When you Want Display called Controller


45. What is process form data?
Ans:‐ If the exception are thrown During the process request and process form request it will
skip those methods & process form data will execute.


46. What is BC4J?
Ans:‐ BC4J is the directive structure the of the apps. Where all the objects will be reside.


47. What are the MDS tables?
Ans:‐ JDR_PATHES,
JDR_COMPONENTS,
JDR_ATTRIBUTES


48. How many types of AM’s which those are used?
Ans:‐ Two types of AM’s 1.Root AM
2. Nested AM
Root AM:‐ Attaching the AM to the Root region is called Root AM.
Nested AM:‐ Attaching the AM to the Nested regions called Nested AM.


49. What is the different B/W Vorowimpl and Voimpl?
Ans:‐ Vorowimpl:‐ Refer the single row
Voimpl :‐ Collection of records


50. I have 5 pages are there how to know I am in which page?
Ans :‐ By using train concept.
Steps→ create 3 pages
2.create the External(shared)Region style as TRAIN → create link for each page →in
each link give page path
3.create the External(shared)Region style as PageButtonbar→ under navigation Bar
create link for each page →in each link give page path and Text for each page
4.In each page create the location in the page region and set the properties:‐
1.extends→Browse project file→press search button→Press ok
2.Allow inter action →True
5.In page create the new region style as Page button bar→extends→ Browse project
file→press search button→press k


51. Where does the two categories of files in OAF be placed in the server?
Ans:‐ All the xml files of the page/region will be placed in the respective TOP’s mds directory.
All the class files irrespective of TOP will be placed under $JAVA_TOP which can be
$COMMON_TOP/java


52. In 11i to R12 migrate which BC4J causes problems?
Ans:‐ AM


53.When is the processRequest method called?
Ans:‐ PR method is called when the page is getting rendered onto the screen


54.When is processFormRequest method called?
Ans:‐ PFR method is called when we perform some action on the screen like click of submit
button or click on lov


55. When you get null pointer exception?
Ans:‐Suppose you want to get any value from page to refer any value that value is
representing as null then null pointer exception should pop up.


56. How to register the page in apps?
Ans:‐ Told in the sessions as like form we have to do


57. After doing the personalization/Extension in seeded Page rename the page and how to
add the Respective responsibility?
Ans: Told in the sessions as like form we have to do


58 .Steps for creation of the page?
Ans:‐ 1.Create the tables from as for the client requirement
2.Create the New work space after that create the project Name:‐ name
Default Project Name:‐oracle.apps.po.requision.webui
3.After that create the page name:xxxPG
4.Crate the Applicationmodule AM
Packagenaeme:‐ XXXXXXX.oracle.apps.po.emaxcusterebate.server
Name:‐xxxxAM
5.After that give Attach the Am to the region and give the WINDOW TITLE:‐
TITLE

How to find the number of occurences in a particular string.


SELECT length('simhachalam')-LENgth(REPLACE('simhachalam', 'm', '')) FROM dual;

Output: 2


SELECT length('simhachalam')-LENgth(REPLACE('simhachalam', 'a', '')) FROM dual;

Output:3

Difference between 11i and R12 in oracle apps

11i	R12
1. If you want to change the OU then you need to change the responsibility in MOAC.	1. Without changing the responsibility you can change the OU.
2. Report server exists.	2. The Reports server is obsolete in Release 12. All reports are now run through the Concurrent Processing server manager via the rwrun executable, which spawns an in-process server.
3. 11i only forms basis application.	3. R12 is now forms and HTML pages.
4. 11i is particularly in set of books	4. R12 using in ledgers
5. In 11i, the Bank Accounts are defined at the Operating Unit level.	5. In R 12, Bank Accounts are defined at Legal Entity Level which can be accessed by multiple Operating Units.
6. In R11, there are only 6 validation types: – Dependent, Independent, None, Pair, Special and Table.	6. In R12, there are 2 additional validation types called ‘Translatable Independent’ and ‘Translatable Dependent’.
7. Set of Books 3Cs-Chart of Accounts, Functional Currency, Accounting Calendar.	7. Ledgers 4Cs – Chart of Accounts, Ledger Currency, Accounting Calendar, Accounting Method(Conventions).
8. Individual Product (AP, AR, etc.) accounting. i.e. Global Accounting Engine.	8. Sub Ledger Accounting Method (SLAM)
9. Operating Unit	9. Multi-Org Access Control (MOAC)
10. Multiple setups for accounting in GL	10. Accounting Setup Manager (ASM)
11. In personalization level set_lov_property is not available	11. In Oracle Apps R12 we can change the LOV.
12. Reporting Set of books	12. Reporting Currency
13. Operating Units assigned to set of books	13. Operating Units assigned to primary Ledger in an Accounting setup.
14. Reports/Forms 6i	14. Reports/Forms 10g
15.Inventory in 11i	15.In R12 ,Inventory have two types process manufacturing and discrete manufacturing
16. In 11i Only relation between customers at TCA.	16. In R12, Relationship between suppliers, customers, bank details at TCA.
17.No MOAC	17. MOAC(Multi Org Access Control)
18. Database Version in 11i (11.5.9 & 11.5.10) was 9i	18. Where as in Release 12 its 10g.
19. Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6)	19. but in Applications R12 it is built on Fusion Middle ware (10g Web Server and 10g Forms & Reports)
20. Intercompany Accounts	20. Intercompany Balancing.

Important Interview Question for Sql* Loader

This is one of the interview question which I faced regarding the sql*loader concept.

If  you are loading the data into table using sql*loader, Discarded records should not cross more than 10 while loading. How?


We are having an option in the sql*loader DISCARDMAX

It holds the integer value and if you pass DISCARDMAX=10, it will stop loading the data into table if the discarded records exceeds more than 10.

Migrate Item Master with Item Category details

Item with Item Category Interface
This script will help to migrate Item Master with Item Category details
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

CREATE OR REPLACE PROCEDURE XXX_Item_Master_Org_Api AS

l_err_flag varchar2(3);
l_err_msg varchar2(2500);
l_count number (2);
l_category_set_id number (20);
l_category_id number (20);
l_org_id number (4);
l_template_name varchar2(250);
l_uom varchar2(20);
l_item_type varchar2(20);
l_organization_id number (10);

--CURSOR TO FETCH THE DATA FROM STAGING TABLE
cursor c1 is
select *
from xxx_item_master_stg
where nvl(verify_flag,'N') = 'N' ;

begin

for c_rec in c1 loop

begin
--- initialize the variables
l_err_flag :='Y';
l_err_msg := null;

---*********** MASTER ORGANIZATION VALIDATION
begin
select organization_id
into l_organization_id
from org_organization_definitions
where upper(organization_name) = upper(trim('XXX ITEM MASTER'));
exception
when others then
l_err_flag := 'Y';
l_err_msg := 'INVALID ORGANIZATION' ;
end ;

---*********** ITEM TYPE VALIDATION
begin
select lookup_code
into l_item_type
from fnd_lookup_values
where lookup_type = 'ITEM_TYPE'
and upper(meaning) = trim(upper(c_rec.item_type));
exception
when others then
l_err_flag := 'N';
l_err_msg := l_err_msg || 'INVALID ITEM TYPE' ;
end ;

---*************** ITEM CODE VALIDATION

begin
l_count := 0;
select count(*)
into l_count
from mtl_system_items_b
where upper(trim(segment1)) = upper(trim(c_rec.item_code))
and organization_id = l_organization_id;
if l_count > 0 then
l_err_flag := 'N';
l_err_msg :=l_err_msg || 'ITEM ALREADY EXISTING' ;
end if;

----*********** VALIDATE THE DESCRIPTION
if trim(c_rec.description) is null then
l_err_flag := 'N';
l_err_msg := l_err_msg || 'INVALID DESCRIPTION';
end if;
end;


--- ITEM TEMPLATE VALIDATION

begin
select template_name
into l_template_name
from mtl_item_templates
where upper(trim(template_name)) = upper(trim(c_rec.template_name));
exception
when others then
l_err_flag := 'N';
l_err_msg := l_err_msg||'INVALID TEMPLATE NAME';
end ;
end;

--- PRIMARY UOM VALIDATION
begin
select unit_of_measure
into l_uom
from mtl_units_of_measure
where upper(trim(uom_code)) = upper(trim(c_rec.uom)); ---eg litre, numbers
exception
when others then
l_err_flag := 'N';
l_err_msg := l_err_msg||'INVALID UOM';
end;

--- ITEM CATEGORY VALIDATION
begin
select category_id
into l_category_id
from mtl_categories_v
where segment1 =trim(c_rec.cat_segment1)
and segment2 = trim(c_rec.cat_segment2) ;
exception
when others then
l_err_flag := 'N';
l_err_msg :=l_err_msg||'INVALID CATEGORY';
end;

---************** ITEM CATEGORY SET VALIDATION
begin
select category_set_id
into l_category_set_id
from mtl_category_sets_tl
where category_set_name = trim(c_rec.cat_set_name);
exception
when others then
l_err_flag := 'N';
l_err_msg :=l_err_msg||'INVALID CATEGORY SET';
end;


--- ITEM CATEGORY COMBINATION VALIDATION
begin
l_count := 0;
select count(*)
into l_count
from mtl_category_set_valid_cats_v
where category_set_id = l_category_set_id
and category_id = l_category_id ;
if l_count = 0 then
l_err_flag := 'N';
l_err_msg :=l_err_msg || 'INVALID CATEGORY COMBINATION' ;
end if;
exception
when others then
l_err_flag := 'N';
l_err_msg :=l_err_msg||'INVALID CATEGORY COMBINATION';
end;



---- IF ALL VALIDATIONS ARE CORRECT, THEN INSERT DATA INTO INTERFACE TABLE
---- THEN BY USING IMPORT ITEM CONCURRENT PGM, IMPORT ITEMS FROM INTERFACE TABLE INTO BASE TABLE

if l_err_flag='Y' then
begin

insert into mtl_system_items_interface
(
item_type
,process_flag
,segment1
,description
,primary_unit_of_measure
,set_process_id
,template_name
,organization_id
,transaction_type
)
values
(
l_item_type
,1
,c_rec.item_code
,c_rec.description
,l_uom
,3
,l_template_name
,l_organization_id
,'CREATE'
);


insert into mtl_item_categories_interface
(
item_number
,category_set_id
,category_id
,process_flag
,organization_id
,set_process_id
,transaction_type
)
values
(
c_rec.item_code
,l_category_set_id
,l_category_id
,1
,l_organization_id
,3
,'CREATE'
);

update xxx_item_master_stg
set verify_flag = 'Y',
err_msg = null
where item_code = c_rec.item_code ;
commit;
exception
when others then
l_err_msg := sqlerrm;
update xxx_item_master_stg
set verify_flag = 'N'
,err_msg = l_err_msg
where item_code = c_rec.item_code ;
end;

commit;

else

update xxx_item_master_stg
set verify_flag = 'N'
,err_msg = l_err_msg
where item_code = c_rec.item_code ;

end if;
commit;
end loop;

commit;

exception
when others then
dbms_output.put_line(sqlerrm);

end xxx_item_master_org_api;
/

Payables base tables in R12 oracle apps

Oracle Apps Payable Table Structure:

Supplier Tables
AP_SUPPLIERS This table replaces the old PO_VENDORS table.
It stores information about your supplier level attributes.
AP_SUPPLIER_SITES_ALL It stores information about your supplier site level attributes.
IBY_EXTERNAL_PAYEES_ALL stores Payee(supplier) information.
HZ_PARTIES Party data for the suppliers.
HZ_PARTY_SITES Party site data for the supplier sites.B4


Supplier Interface tables
ap_suppliers_int Supplier Interface. Execute Supplier Open Interface Import Program
ap_supplier_sites_int Supplier site interface. Execute "Supplier Sites Open Interface Import" Program


Invoice
AP_INVOICES_ALL It contains records for invoices you enter
AP_INVOICE_LINES_ALL It contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_DISTRIBUTIONS_ALL It holds the distribution information that is manually entered or system-generated


Invoice Interface
AP_INVOICES_INTERFACE Invoice Header Information. Run Payables Open Interface Import concurrent program
AP_INVOICE_LINES_INTERFACE Invoice Lines and Distributions Information


Payments:
AP_CHECKS_ALL Check Header Information
AP_INVOICE_PAYMENTS_ALL Details of Invoice paid by a Check/Payment
AP_PAYMENT_HISTORY_ALL
AP_INV_SELECTION_CRITERIA_ALL
AP_SELECTED_INVOICES_ALL
AP_PAYMENT_DISTRIBUTIONS_ALL
CE_PAYMENT_DOCUMENTS AP_CHECK_STOCKS_ALL
IBY_PAY_SERVICE_REQUESTS   Payment Process Request information  (11i Terminology is  Payment Batch)
IBY_PAY_INSTRUCTIONS_ALL Payment Instruction information
IBY_DOC_PAYABLES_ALL Invoice information stored by IBY for generating payment
IBY_PAYMENTS_ALL Payment Information


Accounting
XLA_EVENTS replaces AP_ACOCUNTING_EVENTS_ALL
XLA_AE_HEADERS replaces AP_AE_HEADERS_ALL
XLA_AE_LINES replaces AP_AE_LINES_ALL


Bank Accounts
CE_BANK_ACCOUNTS AP_BANK_ACCOUNTS_ALL
CE_BANK_ACCT_USES_ALL   replaces AP_BANK_ACCOUNT_USES_ALL


Credit Card Transactions Table
AP_EXPENSE_FEED_LINES Use the Credit Card Transaction Interface Table to load transaction datafrom your credit card issuers into your Payables system. When younsubmit the Credit Card Transaction Validation and Exception Report, for records where the CREATE_DISTRIBUTION_FLAG is Y, Payables
uses the data in the AP_EXPENSE_FEED_LINES table to create distributions with proper accounts in the AP_EXPENSE_FEED_DISTS
table

Identify a special character in your string

How to identify special character in your string.


  SELECT *
FROM   dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('chalam'),'asdfghjklqwertyuiopzxcvbnm1234567890',''),' ',''))>0


If it display null value there is no special character in your string

If it display X value there is special character in your string