• Oracle Applications RSS Feed

    by
    bobbyiiit
    Published on 08-14-2010 02:03 PM  Number of Views: 112 

    Receipt API in Oracle Receivables 


    Autolock box provides a functionality to create receipts using interface method. Recent versions of oracle applications, especially 11.5 onwards, Receipt API is getting used as they are flexible to the user’s need, and customization across all kinds of interfaces, loading.

    Here are the ...
    Read More Read More
    by
    bobbyiiit
    Published on 08-14-2010 02:03 PM

    Order Management tables and details 


    This is available in metalink and many internet sites. Since I felt it handy reference, I have reproduced the contents.

    Order Management Tables.

    Entered
    oe_order_headers_all 1 record created in header table
    oe_order_lines_all Lines for particular records ...
    Read More Read More
    by
    saalmank
    Published on 07-20-2010 05:01 PM  Number of Views: 311 

    Query to Select Prepayment Invoice Status in Oracle Payables 


    The following is a Query to Select Prepayment Invoice Status in Oracle Payables.

    Code sql:
    SELECT   pv.VENDOR_NAME,
           ai.invoice_num,
           NVL (
              DECODE (
                 SIGN (SUM (amount - NVL (prepay_amount_remaining, amount))),
    ...
    Read More Read More
    by
    Kirti
    Published on 03-11-2010 06:50 PM  Number of Views: 1754 

    Oracle Forms Personalization Tutorial 


    Introduction

    This is a Video which demonstrates Oracle Forms Personalization.

    Background

    Oracle Forms Personalization is a way to change the look and feel of default oracle forms without touching the forms code or the fmb files. We can change labels, make ...
    Read More Read More 4 Comments
    by
    murthyreddy
    Published on 01-28-2010 10:16 AM  Number of Views: 1413 

    Shell Script Usage in Oracle Applications 


    Hi All,

    Following are the various purposes we can go for Shell Scripts in Oracle Apps.

    1) If you would like to move the Files from One Unix Server to the Other Unix server, we can opt Shell Scripts.we can transfer all files at a time, we can Zip those files and we can encrypt ...
    Read More Read More 2 Comments
    by
    bobbyiiit
    Published on 01-18-2010 01:10 PM  Number of Views: 2983 

    Purchase order flow in Oracle Applications 


    Hi,

    The following flow is the Oracle Apps PO flow. Any Business should/will follow the following steps while dealing with PO.

    --------------------------------------------------------------------------

    Step 1: Requisition

    When the ...
    Read More Read More 9 Comments
    by
    malli_18arjun
    Published on 01-05-2010 11:44 AM  Number of Views: 1129 

    Workflow Tables and queries 


    Code sql:
    SELECT * FROM wf_user_role_assignments
SELECT * FROM wf_user_roles
SELECT * FROM wf_roles
SELECT * FROM wf_items
SELECT * FROM wf_item_attributes
SELECT * FROM wf_item_attribute_values
SELECT * FROM wf_item_attributes_tl
SELECT * FROM wf_activities
    ...
    Read More Read More 2 Comments
    by
    Sadik
    Published on 11-20-2009 09:10 AM  Number of Views: 945 

    Download Oracle Tutor Docs on the New Metalink 


    To download the Oracle tutor documents from the New Oracle Metalink renamed as Oracle Support, follow the steps given below.
    1. Login to Oracle Support with your Oracle SSO User Id and Password
    2. Once the flash interface loads, Click on Pathes and Updates
    3. There will be a Box named Patch Search,
    ...
    Read More Read More
    by
    shrikantgarud
    Published on 10-12-2009 12:59 PM  Number of Views: 1488 

    Modules In Oracle Application 


    * ABM - Activity Based Management
    * AD - Applications DBA
    * AHL - Oracle Advanced Service Online
    * AK - Oracle Common Modules-AK
    * ALR - Oracle Alert
    * AMF - Oracle Fulfillment Services
    * AMS - Oracle Marketing
    * AP - Oracle Payables
    * AR - Oracle
    ...
    Read More Read More 3 Comments
    by
    shrikantgarud
    Published on 10-12-2009 12:57 PM  Number of Views: 304 

    API's ( What order must I call APIs to create default taxation for U) 


    After creating the person and valid address, tax records are defaulted when the
    UPDATE_US_EMP_ASG API is run, updating the p_tax_unit; followed by the
    UPDATE_EMP_ASG_CRITERIA.
    The tax unit corresponds to the GRE. You can find the tax unit using the following query:
    Code sql:
     
    ...
    Read More Read More