Pages

29 June 2011

To Change The Colour Appearance Of Oracle Applications


We have to change the following system profiles in order to change the look & feel and color appearance of oracle apps         
  • Profile option: Java Look and Feel
  • Profile option: Java Color Scheme

28 June 2011

Inventory To GL Reconciliation Step

In R12, the GL transfer is a two-step process. The first step is from Costing to SLA. The second step is from SLA to GL. Costing team is only responsible for the first step. We can provide some guideline to check the inventory material distributions have been accounted in SLA.  To confirm the integrity between SLA and GL, we need to go to a Financials referrals

Concept Of "Price Variance Accounting" Entry On Matching Invoice to PO in AP


We can understand the Price variance concept by the following examples,
Create and approve PO qty=100 price=$5 for total of $500
Invoice is matched to PO qty =100 price = $1 total of  $100

Conditions To Change The Charge Account In Auto Created PO

The charge account cannot be modified under the following conditions:
- If the DESTINATION is INVENTORY or SHOP FLOOR; OR
- The distribution has been encumbered; OR
- PO is autocreated from an encumbered Requisition; OR
- If expense_accrual_code=RECEIPT and destination_type_code=EXPENSE and either

27 June 2011

Oracle EAM: To Link The Project With Work Order

The work orders created in eAM can be linked to Oracle Projects through the Project and Task
fields
To implement this functionality, please execute the following steps:

Oracle EAM: The Material Cost In Work Order Does Not Transfer To Projects

If Material cost in Work order not getting transfer in to the Project, Initially we need to check the Expenditure type and Cost element, lets follow the below steps to check before proceed further

How one can use Personalization to secure a personalized view ?

Using following steps we can make the personlized view in apps

1) Create a function in the application using “Application Developer/System Administrator responsibility”. Lets say the function name is – “View_Siva”
2) Create another function called “View_Peter”

Oracle PO: Create Release against Blanket PO

We have 3 basic choices for the requisitions created by this process:
1. Release against a blanket PO
2. Autocreate into POs
3. Release as standard PO (but you must have a quotation to use instead of a blanket -- pricing has to come from one or the other).                                                                                                                               


Oracle EAM: SLA Rule To Replace The Standard WIP Valuation Account For Resource Transaction

To replace the standard WIP valuation account in the debit leg of a resource transaction distribution with a custom account depending on the resource charged or depending on the department


Use SLA to define custom ADR to accomplish this and modify SLA/GL setups to use this modified SLA rule

Setup procedure is as follows:
Use Cost Management - SLA responsibility
Step 1: Setup custom Account Derivation Rule (ADR)
Step 2: Setup custom Journal Line Definition (JLD)
Step 3: Setup custom Application Accounting Definition (AAD)
Step 4: Setup custom Sub Ledger Accounting Method (SLAM)
Step 5: Associate custom Sub Ledger Accounting Method (SLAM) with Ledger


Iphone Powerpoint(ppt) Templates | Iphone Powerpoint Template | Apple Iphone Powerpoint Presentation

Oracle PO: Enable Default Expense Accounts Based Upon Category

To enable default expense accounts based upon category rules:

Assign a Default Expense Account to the Employee

Note:  This step is no longer required but can be used to default in part of the account string, while using the category rules to change only specific segments.

Oracle EAM: Work Order Scheduled On Calendar Off Days

In Oracle Enterprise Asset management module, we can make system to allow or avoid the work order scheduling for the week end using the below steps

Oracle PO: Steps to debug the Approval Workflow for Purchase Order or Purchase Requisition


Step 1
Review the action history of the document having a problem. This is done in the Purchasing Summary screens – either Requisitions Requisitions Summary or Purchase Orders Purchase Order Summary. If you attempt to view the action history and you receive the following error: