Introduction This Post illustrates the steps required to Period and Daily Exchange Rates in Fusion Application. Script to Period and Daily Exchange Rates in Fusion SELECT gper.set_of_books_id ,gl_set_of_books.name || gper.period_name…
Read MoreDescription: Profile Option values control the behavior of Oracle Apps; in other words, they determine how Oracle Apps should run. The value for a profile option can be changed at…
Read MoreIntroduction This post is about to get an opening, purchasing, receive, sales, and closing quantity of items query. Script to get opening, purchasing, receive, sales and closing quantity of…
Read MoreDescription: The below steps describe who Apex used to call the Oracle JOB scheduler and Java users to create in oracle EBS with examples. l Create the HTML link on…
Read MoreIntroduction This Post is about to Sales Order details with India Localization tax in Oracle EBS R12. Script to Sales Order details with India Localization tax SELECT h.header_id header_id,…
Read MoreIntroduction This Post illustrates the steps required to Update and assign project Roles using PA_PROJECT_PARTIES_PUB in Oracle EBS. Script to Update and assign project Roles using PA_PROJECT_PARTIES_PUB DECLARE l_project_id_PREM …
Read Moreintroduction You have a lot of tables ending with different suffixes in the Oracle Apps database. Listed below are the different types of tables. ALL: Table ending with _ALL means it…
Read MoreDescription: Upgrading Oracle Application Express creates new database objects in a new schema and migrates the application metadata to the latest release. Problem:Login issue – unable to login to the…
Read MoreIntroduction This Post is about extract iProc Smart Forms query in Oracle EBS R12. SELECT DISTINCT STORE.NAME store_name, smartforms.template_name request_name, pas.commodity_id, pas.vendor_name supplier, (SELECT NAME FROM apps.hr_operating_units WHERE organization_id…
Read MoreIntroduction This Post illustrates the steps required to Export employee data with personal expenses in i-expense and the expense is not claimed in Oracle EBS R12. Script to Export employee…
Read More