How to split a phone no to country code,std code,Land Line

with ph as
(select '091-044-234678' phone from dual),
 ph1 as
(select phone,substr(phone,instr(phone,'-',1)+1) as phone2 from ph),
 ph2 as
(select phone,phone2,substr(phone2,instr(phone2,'-',1)+1) as phone3 from ph1)
select * from ph2
select substr(phone,0,instr(phone,'-',1)-1) phone,
substr(phone2,0,instr(phone2,'-',1)-1)phone2,phone3
 from ph2

How to give a link in Standard page to call custom OAF with custom parameters

I am personalizing opportunity page in sales module by adding a link to it. When the link id pressed, it should take to an custom OAF Page,

 i can do that by calling function or OA.jsp. I also need to pass the parameter of the existing opportunity page. the value which should be passed is in OAOPPDETAILVO1.LeadId
[VONAME.FieldName]

How to pass it.

Solution:

Go to the page you want to give link and add an item to it.


You will be seeing a screen like above. In the screen enter the VO name where the field value resides.
Then Leave the view attribute blank if you want to give speccific text. Give the specific text in Text.

in Destination URL give  the below
OA.jsp?page=/oracle/apps/msc/common/showoppdet/webui/oppDetPG&retainAM=N&addBreadCrumb=Y&oppId={@LeadId}

In the above the page oppDetPG is the custom page i have created. LeadId is column in OpportunityDetailsVO1

 

 

 

Error - Unable to start service Intent

While running Android Project, I am getting the below error
 
WARN/ActivityManager(60): Unable to start service Intent { cmp=com.android.internetenable/.ToggleService (has extras) }: not found
 Source as in AndroidManifest.xml

 

<receiver android:name=".IntEnableActivity" android:label="My App Widget">

<intent-filter> 

<action android:name="android.appwidget.action.APPWIDGET_UPDATE" />

<action android:name="android.net.conn.CONNECTIVITY_CHANGE" />
</intent-filter>
<meta-data
android:name="android.appwidget.provider"
android:resource="@xml/my_widget_layout"
/>
<service android:name=".ToggleService" />
</receiver>

Solution:
  The error was wrongly misplacing service inside receiver tag

Error: FRM-47023: No Such Parameter named G_QUERY_FIND Exists Oracle Quoting

Error: FRM-47023: No Such Parameter named G_QUERY_FIND exists in form QOTCMAPD

In Oracle Quoting While i am creqting a quote, when i am selecting Approvals i am getting the above Error:

Solution: Check the Quote Name. Sometimes if quote name is long, this error occurs

How to Download attachments from table using OAMessageDownloadBean

In OA Framework JDeveloper add a message Download Button 

Please Specify 

Data Type: BLOB

View Instance : DocumentsVO [Corresponding VO name]

View Attribute: FileName [File Name Column in the VO]

File View Attribute: FileData [Blob column containing the data]

Add the below lines in code to specify MIME Type
// OA Table
OATableBean tableBean =(OATableBean) webBean.findChildRecursive("AllDocumentsTable");
// message Download 
    OAMessageDownloadBean downloadBean = (OAMessageDownloadBean)tableBean.findChildRecursive("downloadFile");
    OADataBoundValueViewObject contentBoundValue = new OADataBoundValueViewObject(downloadBean,"FileContentType");
    downloadBean.setAttributeValue(FILE_CONTENT_TYPE, contentBoundValue);

Please note that there should be a primary column in the query. If there is no primary column all the rows will download a same file.