• Oracle Articles RSS Feed

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

    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 ...
    by Published on 08-14-2010 02:03 PM

    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 ...
    by Published on 07-20-2010 05:01 PM  Number of Views: 311 

    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))),
    ...
    by Published on 03-29-2010 11:12 AM  Number of Views: 862 

    Content Tracker Installation

    1. Goto Admin Server
    2. Click on Component Manager
    3. Click Browse for “Install New Component” and select ContentTracker.zip file.
    4. Click on Install. A list of items to be installed will be displayed.
    5. Click Continue.
    ...
    by Published on 03-11-2010 06:50 PM  Number of Views: 1754 

    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 ...
    by Published on 02-26-2010 04:47 AM  Number of Views: 915 

    WORKING AROUND MUTATING TABLE ERROR USING VIEW


    Code sql:
    SQL> CREATE TABLE STUD(RNO NUMBER(5), SNAME VARCHAR2(20), M1 NUMBER(4), M2   NUMBER(4),
                   M3 NUMBER(4), TOT NUMBER(7), AVGG NUMBER(5,2));
    Table created.

    I created a table stud ...
    by Published on 01-28-2010 10:16 AM  Number of Views: 1413 

    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 ...
    by Published on 01-18-2010 01:10 PM  Number of Views: 2983 

    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 ...
    by Published on 01-05-2010 11:44 AM  Number of Views: 1128 

    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
    ...
    by Published on 12-23-2009 12:28 AM  Number of Views: 726 

    Nested Tables and Varrays [ID 61745.1]

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

    Modified 28-MAY-2009 Type BULLETIN Status PUBLISHED


    Checked for relevance on 28-May-2009

    ...