Here we will explain in simple words what is the difference between BI and OBIEE OBIEE is a stand alone suite ...
Post
Oraask Latest Articles
Post
How to Convert Custom.PLL to PLD ,PLX and modifying it in notepad?
How to Convert Custom.PLL to PLD ,PLX and modifying it in notepad?
1 mins read
How to convert Custom.pll to text ? How to Convert Custom.PLL to PLD ,PLX
today we will share sample way to edit custom.pll in notepad so by this way i think it will be much faster than you edit in oracle form builder.
also this way will be helpful if you want to compare between two versions of CUSTOM.pll to make sure you didn’t touch any thing else except your modifications.
SCRIPTS FOR WINDOWS :
————————————-
1- first command to convert from CUSTOM.pll to CUSTOM.PLD :
Post
What Means & where to find Attachment in Oracle Application and it’s tables & API ?
What Means & where to find Attachment in Oracle Application and it’s tables & API ?
7 mins read
What and where to find Attachment in Oracle Application and it’s tables & API
What is attachment in oracle application?
The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions.
Where to find an attachment?
There is an attachment icon in the oracle application toolbar that indicates whether the Attachments feature is enabled in a form block. When the button is dimmed, the Attachment feature is not available. When the Attachment feature is enabled in a form block, the icon becomes a solid paper clip like this image below :
(more…)
Post
How to handle NaN result in summary column – xml publisher
How to handle NaN result in summary column – xml publisher
1 mins read
The most common cause of the issue is you have a null value in your XML ie <AMOUNT></AMOUNT> and sadly the XSLT engine does not know how to handle it.
So how to handle nulls? We now have a decent section in the user guide on handling nulls buts here’s a couple.Lets assume we have the following XML:
So how to handle nulls? We now have a decent section in the user guide on handling nulls buts here’s a couple.Lets assume we have the following XML:
Post
Table Registration with Application Interface (API)
Table Registration with Application Interface (API)
4 mins read
How to register table using API ?
We can register the Table using Application DBA Data Definitions (AD_DD)
Package from the Back End. You can also use the AD_DD API to delete the registrations
of tables and columns from Oracle Application Object Library tables. To alter a
registration you should first delete the registration, and then re register the table or
column. You should delete the column registration first, then the table registration,you should run the AD_DD procedures against the APPS schema. You must commit your changes for them to take effect.
Post
Query to get all Personalization applied to Forms in oracle ebs r12
Query to get all Personalization applied to Forms in oracle ebs r12
1 mins read
Simple Query to find form Personalization with Created By and Last Updated by whom:
Post
API to Create Person Extra Information Types EIT
API to Create Person Extra Information Types EIT
8 mins read
Today we will explain by example how to create person extra information in ORACLE EBS HRMS by using standard API (hr_person_extra_info_api.create_person_extra_info), but first, ...
Post
API to update EAM Asset Numbers
API to update EAM Asset Numbers
2 mins read
Today we'll demonstrate how to update EAM asset number using API EAM_AssetNumber_PUB.Update_Asset_Number : API to update EAM ...
Post
Understanding Date Tracking in Oracle HRMS – what does it mean? how it used in HRMS ?
Understanding Date Tracking in Oracle HRMS – what does it mean? how it used in HRMS ?
2 mins read
Understanding Date Tracking in Oracle HRMS :
Update Date Track Modes :
To maintain employee data effectively Oracle HCM is using a mechanism called date tracking.The main motive behind the date track mode is to maintain past,present and future data effectively.
Another definition for date tracking is :
Date tracking is a design / concept, which is used by Oracle E-Business, in order to support the storage of historical data, along with the current ones. It is a mechanism to store data based on dates.
Post
ORA-20001: FLEX-ID Does Not Exist Error when calling HR_Personal_Pay_Method_Api .Create_Personal_Pay_Method API
ORA-20001: FLEX-ID Does Not Exist Error when calling HR_Personal_Pay_Method_Api .Create_Personal_Pay_Method API
1 mins read
When Calling HR_Personal_Pay_Method_Api.Create_Personal_Pay_Method it errors with the following: ORA-20001: FLEX-ID Does Not Exist Cause : This is caused by ...