Oracle Geeks

New and Changed Features in Oracle Financials of 12.1.3 Version of R12 I. 12.1.3 New Features of  Oracle Advanced Collections 1. Staged Dunning In addition to the Aged Dunning method that is based on a customer’s oldest aged invoice, Collections organizations may now use Staged Dunning method. The Staged Dunning method ensures the dunning notices set to a customer automatically incremented based on the collection score and pre-defined number of days between letters being sent. II. 12.1.3 New Features of Oracle Fixed Assets As defined by previous regulatory initiatives in Japan and the Japan Tax Reform of 2007, the impairment functionality in Oracle Assets has been extended to perform and account for asset impairments in compliance with Japanese accounting regulations. Impairment losses can now be derived and recorded for Japan-specific depreciation methods. The following impairment feature functionality is now available for Japan depreciation me...

Purchasing Basic Setups: Step 1 Set Up System Administrator (Required) Step 2 Set Up Key Flexfields (Required) Step 3 Set Up Calendars, Currencies, and Set of Books (Required) Step 4 Set Up Organizations (Required) Step 5 Set Up Units of Measure (Required) Step 6 Set Up Items            Define item attribute controls. (Required with defaults)            Define container type QuickCodes. (Required with defaults)            Define status. (Required with defaults)            Define item type QuickCodes. (Required with defaults) Step 7 Set Up Personnel (Required)            Define employee QuickCodes. (Required with defaults)            Define supplier and employee numbering...

Oracle APPS Important Tables  Oracle APPS Important Tables ONT- Order Management Table Name Description OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. OE_ORDER_LINES_ALL OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management. OE_ORDER_SOURCES Feeder System Names that create orders in Order Management tables. OE_ORDER_HOLDS_ALL This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases. OE_SALES_CREDITS This table stores information about sales credits. OE_TRANSACTION_TYPES_ALL This table stores information about the order and line transaction types WSH_DELIVERY_ASSIGNMENTS Delivery Assignments WSH_DELIVERY_DETAILS Delivery Details WSH_NEW_DELIVERIES Deliveries WSH_TRIPS Trips WSH_TRIP_STOPS Trip Stops PO - Purchasing Table Name Description PO_ACTION_HISTORY Document approval and control action history table PO_AGENTS...

Account Alias- Auto-Picking of Source from Transaction Type Personalization: Below personalization can be used to pick up auto Source for Account Alias as Transaction Type is selected by user. 1- Go to Inventory> Miscellaneous Transactions> Help>Diagnostics>Custom Code> Personalize:   2- Enter:      Sequence: 100 (relevant)      Description: Account Alias Source Picking      Trigger Event: WHEN-NEW-ITEM-INSTANCE      Trigger Object: MISC_TRX.TRANSACTION_SOURCE      Condition: :MISC_TRX.TRANSACTION_TYPE = 'ABC'      (Instead of 'ABC' e nter name of relevant Transaction Type) 3- Go to Actions:      Sequence: 10      Type: Property      Object Type: Item      Target Object: MISC_TRX.TRANSACTION_SOURCE       Property Nam...