Styles Of Sree

Bangkok Pattaya Thailand

2011-12-08T00:10:00.001+05:30

View Full Album

2011-11-04T00:08:00.001+05:30

Beginner's Guide : Administering Oracle Application – Part – I

Beginner's Guide : Administering Concurrent Program – Part – II

Beginner's Guide : Understanding Concurrent Managers – Part – III

2011-11-03T23:51:00.000+05:30

Starting Planning Manager

2011-11-03T23:41:00.000+05:30

Planning Manager

The Planning Manager periodically performs many tasks, such as forecast consumption and master production schedule consumption, that require processing rows in an interface table.

Program Requirements

The Planning Manager has been designed to:

Process the work itself, if there are only a few rows to process, rather than incurring the overhead of launching a new concurrent program.

Divide the work across one or more Planning Manager Worker processes if there are many rows to process.

Launch more Planning Manager Workers when there are more rows to process, and fewer workers when there are fewer rows to process.

Avoid delaying the processing of one task due to another task. For example, relief of the master production schedule should not be delayed because the Planning Manager is busy processing rows for forecast consumption.

Allow the user to configure the Planning Manager.

Configuration of Planning Manager

You can configure the Planning Manager to control how it divides the rows to be processed, and across how many processes those rows are divided. You can define the following profile options:

MRP:Planning Manager Batch Size

MRP: Planning Manager Workers

See: Profile Options.

Program Logic

The Planning Manager and Planning Manager Workers perform the following tasks:

consume the master production schedule when work orders or purchase orders are created

consume the master demand schedule when sales orders have shipped

consume the forecast when sales orders are entered

load forecasts from outside systems when rows are inserted into the interface table from an outside system

load master schedules from outside systems when rows are inserted into the interface table from an outside system

The Planning Manager and the Planning Manager Workers perform the following logic for each task performed:

The above diagram illustrates the Planning Manager Worker Process logic. Below is a detailed explanation of the logic.

1. Update rows in the interface table where the status indicates that they are waiting to be processed. Update at most X rows, where X is the value of the profile option MRP:Planning Manager Batch Size.

2. Check to see if any rows were updated in Step 1. If not, there are no rows waiting to be processed.

3. Were the number of rows updated in Step 1 equal to the batch size? If not, all the remaining rows in the interface table can be processed by this process. If the number of rows updated equals the batch size, there could be more rows to process. Go to Step 4 to try to launch a Snapshot Worker.

4. The number of rows updated never exceeds the batch size, because we have limited the update in Step 1 to be less than or equal to the batch size number of rows.

5. It is possible that occasionally Oracle Master Scheduling/MRP launches a Snapshot Worker unnecessarily if the number of rows processed exactly matches the batch size. This is not a serious problem, however, as that extra worker simply wakes up, sees there is nothing to process, and exits.

6. Is the number of Planning Manager Workers running or pending less than the maximum number of workers? If yes, launch a Planning Manager Worker. Otherwise, do not launch a new Planning Manager Worker.

7. Process the rows that were updated in Step 1 according to the type of task being performed. If any errors occur during processing, update the status of the row to "Error". Otherwise, update the status of the row to "Processed".

8. Is this process the Planning Manager or a Planning Manager Worker? If this is the Planning Manager Worker, loop back to Step 1 and try to grab another set of rows to process. If this is the Planning Manager itself that is running, there should be no more rows to process. Do not grab more rows, as that may cause a delay in processing other tasks.

9. If this is the Planning Manager, move on to the next task to process. If there are no other tasks to process this cycle, resubmit the Planning Manager to wake up again after the interval of time set in the profile option. If this is a Planning Manager Worker, terminate the program.

Contents

Index

Navigation

Glossary

Library

IPhone 5... Still a dream..

2011-10-29T16:25:00.001+05:30

iPhone 5

Grand Palace - Bangkok,Thailand

2011-10-26T23:44:00.002+05:30

If there is one must-see sight that no visit to Bangkok would be complete without, it's the dazzling, spectacular Grand Palace, undoubtedly the city's most famous landmark. Built in 1782 - and for 150 years the home of the Thai King, the Royal court and the administrative seat of government - the Grand Palace of Bangkok is a grand old dame indeed, that continues to have visitors in awe with its beautiful architecture and intricate detail, all of which is a proud salute to the creativity and craftsmanship of Thai people. Within its walls were also the Thai war ministry, state departments, and even the mint. Today, the complex remains the spiritual heart of the Thai Kingdom.

Within the palace complex are several impressive buildings including Wat Phra Kaew (Temple of the Emerald Buddha), which contains the small, very famous and greatly revered Emerald Buddha that dates back to the 14th century. The robes on the Buddha are changed with the seasons by HM The King of Thailand, and forms an important ritual in the Buddhist calendar. Thai Kings stopped living in the palace around the turn of the twentieth century, but the palace complex is still used to mark all kinds of other ceremonial and auspicious happenings.

Watch a small video that I have taken from there...

Rolling Up Assembly Costs

2010-09-22T21:43:00.001+05:30

http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/cst/stdtas01.htm

If you have Oracle Bills of Material installed, you can perform either a full cost rollup or a single-level cost rollup.

A full cost rollup first performs a bill of material explosion for assemblies. The rollup process builds the cost of assemblies, starting with the lowest level, and works up the structure to top level assemblies. This method gives you the most current bill of material structure and component costs.

Suggestion: Verify the bill structure before performing a cost rollup to ensure that there are no loops in the bill. See: Checking for Bill Loops.

A single-level rollup only looks at the first level of the bill structure for each assembly in the rollup, and rolls the costs for the items at this level into the parent. This method does not reflect structure or cost changes that have occurred at a level below the first level of your assemblies.

Note: The cost rollup includes the material costs but not the routing costs of phantom assemblies in the cost of higher level assemblies.

Use a single level rollup to assign new standard costs to the top assembly, but not to the lower-level assemblies. A single level rollup allows you to generate costs on new assemblies without changing costs on existing subassemblies.

Part of the cost rollup process includes the option to print a report. If you choose to print a report, you can select either the Consolidated Bills of Material Cost Report or the Indented Bills of Material Cost Report. Both of these reports can also be submitted when reporting item costs.

To roll up assembly costs:

Assembly Cost Rollup window.

2. Enter or select a name of the request to submit:

Cost rollup - No Report:

Cost Rollup - Print Report:

Temporary Rollup - Print Report:

does not

Attention: To use either of the Cost Rollup options where costs are committed to the database, the Privilege to Maintain Cost security function must be included as part of the responsibility.

Note: By leaving the Privilege to View Cost security function as part of a user's responsibility, but excluding the Privilege to Maintain Cost function, you can allow the user to print reports but not change any stored costs. See: Cost Management Security Functions.

cost type for which to roll up assembly costs.

rollup option.

range of items to roll up: all items, a category, a range of items, a specific item, or zero cost items only.

If you select Zero Cost Items, the rollup includes zero cost items in the current and the default cost types that have their Based on Rollup attribute turned on.

Note: Inactive items are not rolled up unless you enter a Specific Item that is inactive.

6. If you chose to print a report:

Select a report type:

Consolidated:

Detail Indented:

Indicate whether to include Material Detail and Material Overhead Detail (material and material overhead sub-elements) on the report.

Indicate whether to include Routing Detail (resource, outside processing, and overhead sub-elements) on the report. By limiting the amount of sub-element detail, you reduce the size of the report.

Enter the maximum report number of levels to display on the report. For example, if your assembly had 20 levels and you enter 10 in this field, the costs for levels 1 to 10 would be detailed. The costs for levels 11 to 20 would be summarized as previous level costs. The default is the maximum bill of material levels value. See: Defining Bills of Material Parameters.

7. Enter the effective date and time to determine the structure of the bill of material to use in the cost rollup. You can use this to roll up historical and future bill structures using current rates and component costs. The default is the current date and time.

include unimplemented engineering change orders (ECOs) in the rollup. The default is off. See:

ECO Statuses

alternate bill name for the assembly to roll up the alternate bills for the selected range of items. For example, if you choose All items in the Range field and enter A-001 in this field, all items that have a bill associated with that alternate name are rolled up. The primary bill is

not

Primary and Alternate Bills of Material

alternate routing name for the assembly to roll up the alternate routings for the selected range of items. For example, if you choose All items in the Range field and enter A-001 in this field, all items using routings with that routing name are rolled up. The primary routing is

not

Primary and Alternate Routings

engineering bills in the cost rollup. If you turn this on, only assemblies with engineering bills are rolled up. The default is off.

12. Specify items to roll up:

If you selected to roll up a specific item in the Range field, enter the item.

If you selected to roll up a category in the Range field, enter either a category set or a specific category.

If you enter a category set, item costs are rolled up for items associated with this category set. The default is the category set defined for your costing functional area.

If you selected to roll up a range of items, enter From and To values to specify the range of items for which to roll up costs.

Bills and Cost Rollups

2010-09-22T21:42:00.001+05:30

Oracle Site

Bills and routings define the foundation for cost rollups, elemental distribution, and all related manufacturing costing functions.

Work in Process uses the bill of material to determine material requirements and control material transactions. In addition, the primary bill for an assembly determines the standard material and material overhead costs of that assembly.

Work in Process uses the routing to determine production schedules, specify shop floor and operation moves, and control resource, outside processing, and overhead cost transactions. In addition, the primary routing for the assembly determines the standard resource, outside processing, and resource overhead costs of that assembly.

When you submit a cost rollup, you may include or not include unimplemented engineering change orders. The cost rollup also considers the effective date.

Components and resources with effective dates on or before the rollup date are included in the rollup. The cost rollup does not include disabled components or resources.

Note: For phantom assemblies, the cost rollup includes the material costs but not the routing costs in the cost of higher level assemblies. Work in Process charges and values phantom assembly material costs but not phantom assembly routing costs.

Purchased assemblies show different elemental costs when you buy the assemblies rather than build ("make") them. When you purchase a "buy" assembly, the total cost consists of the material and material overhead cost elements only. When you build a make assembly, the total cost consists of the material, resource, overhead, and outside processing cost elements. Thus, the value of the material cost element may differ in buy vs. make situations. This affects job cost, period close distributions, and variances.

Yield

Referencing Common Bills and Routings

For example, suppose you have a material overhead and a bill for assembly A. Suppose further that you define assembly B using A as a common bill. However, you also define a material overhead rate for B. A cost rollup on A uses A's material overhead. A rollup on B uses B's material overhead.

Common routings are similar to common bills of material. The cost rollup costs common routings like standard routings.

You can define multiple alternates for a bill or routing. You can rollup alternate structures and update these costs into your Frozen cost type.

sree

2010-09-18T13:41:00.001+05:30

Oracle Applications: Significance of Profile Options

2010-09-02T11:52:00.002+05:30

Profile Options are additional rules that are critical for how the system works. They are updated by the System Administrator and are usually set at the site level
System Options for Oracle Receivables usually start with “AR:” or “Tax:” But, you need to watch out for “OE: Inventory Validation Organization” which you must define whether or not you are using Oracle Order Entry or Oracle Inventory. Select the applicable value.
For the Accounts Receivable values the following are the most critical:
AR: Allow Transaction Batching – If you enter small volumes of manual transactions, it is not necessary to use batches for transactions. If you enter high volumes, you should use batching for transactions. You should always use batching for receipts since you get immediate feedback of what you have done and any potential problems.
AR: Cash Allow Actions – As part of the cash application process, the applier has the option to create adjustments (write-offs) and chargebacks if you set this option to Yes. I recommend that you do that, you can always control the amounts they write-off using approval limits.
AR: Cash – Default Amount Applied – Always set so the default is the amount remaining on the receipt, not the amount remaining on the invoice. If you allow the receipt amount to default to the invoice balance, this allows you to apply more than you really have.
AR: Change Customer Name – In reality customers change their names and this is a valuable feature but, I recommend that you set it “Yes” only after to have been live for a few weeks. This is a good way to keep novice users from overlaying good names with invalid names, until the know what they are doing.
AR: Close Period – Run Collections Effectiveness – I recommend that you set this option to “No.” Most users do not use this report and it will just slow the close process.
AR: Update Due Date – Allow change to due date. In rare instances it is desirable to change the due date on an invoice (for example, you have negotiated this with the customer). By setting this profile option to “Yes,” you have the option of doing this. What this really does is to allow you to make your aging look better. Consider whether or not this is desirable in you business situation.
AR: Use Invoice Accounting For Credit Memo – In most cases, if you know the original invoice, it is desirable to offset the accounts that were used for the invoice when creating the related Credit Memo. This option allows you to do that.

Oracle Applications – Acoounts Receivables (AR) Tables Information.

2010-09-02T11:51:00.000+05:30

RA_CUSTOMER_TRX_ALL

This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables. Invoices, debit memos, credit memos, and commitments are all distinguished by their transaction types stored in RA_CUST_TRX_TYPES_ALL. If you entered a credit memo, PREVIOUS_CUSTOMER_TRX_ID stores the customer transaction identifier of the invoice you credited. In the case of on account credits, which are not related to any invoice at creation, PREVIOUS_CUSTOMER_TRX_ID is null. If you created an invoice against a commitment, Oracle Receivables stores the customer transaction identifier of the commitment in INITIAL_CUSTOMER_TRX_ID, otherwise it is null. COMPLETE_FLAG stores ’Y’ for Yes and ’N’ for No to indicate if your invoice is complete. When you complete an invoice, Oracle Receivables creates your payment schedules and updates any commitments against this invoice. Before an invoice can be completed, it must have at least one invoice line, revenue records must exist for each line and add up to the line amount, and a sales tax record must exist for each line. Required Columns:SOLD_TO_CUSTOMER_ID,SOLD_TO_SITE_USE_ID,BILL_TO_CUSTOMER_ID,BILL_TO_SITE_USE_ID,SHIP_TO_SITE_USE_ID,PRINTING_OPTION,PRINTING_PENDING,TERM_ID,REMIT_TO_ADDRESS_ID,PRIMARY_SALES_REP_ID, and INVOICE_CURRENCY_CODE are required even though they are null allowed. The primary key for this table is CUSTOMER_TRX_ID.

RA_CUSTOMER_TRX_LINES_ALL

This table stores information about invoice, debit memo, credit memo, and commitment lines. For example, an invoice can have one line for Product A and another line for Product B. You need one row for each line. Invoice, debit memo, credit memo, and commitment lines are distinguished by the transaction type of the corresponding RA_CUSTOMER_TRX_ALL record.Also, credit memos are required to have a value in PREVIOUS_CUSTOMER_TRX_LINE_ID, except on account credits which are not related to specific invoices/invoice lines at creation time, will not have values in this column. QUANTITY_ORDERED stores the amount of product ordered. QUANTITY_INVOICED stores the amount of product invoiced. For invoices entered through the window, QUANTITY_ORDERED and QUANTITY_INVOICED must be the same. For invoices imported through AutoInvoice, QUANTITY_ORDERED and QUANTITY_INVOICED can be different. If you enter a credit memo, QUANTITY_CREDITED stores the amount of product credited. UOM_CODE stores the unit of measure code as defined in MTL_UNITS_OF_MEASURE. UNIT_STANDARD_PRICE stores the list price per unit for this transaction line. UNIT_SELLING_PRICE stores the selling price per unit for this transaction line. For transactions imported through AutoInvoice, UNIT_STANDARD_PRICE and UNIT_SELLING_PRICE can be different. DESCRIPTION, TAXING_RULE, QUANTITY_ORDERED, UNIT_STANDARD_PRICE,UOM_CODE, and UNIT_SELLING_PRICE are required even though they are null allowed. LINE_TYPE differentiates between the different types of lines that are stored in this table. LINE points to regular invoice lines that normally refer to an item. TAX signifies that this is a tax line. The column LINK_TO_CUST_TRX_LINE_ID references another row in this table that is the invoice line associated with the row of type TAX. FREIGHT works the same way as TAX but there you can have at most one FREIGHT type l ine per invoice line of type LINE. You can also have one line of type FREIGHT that has a null LINK_TO_CUST_TRX_LINE_ID (and this is referred to as header level freight). CHARGES works just like the LINE type. A line_type of ’CB’ is created for a Chargeback line. For every row in this table that belongs to a complete transaction (where RA_CUSTOMER_TRX.COMPLETE_FLAG = Y), there must be at least one row in the table RA_CUST_TRX_LINE_GL_DIST (which stores accounting information), even for non–postable transactions. The primary key for this table is CUSTOMER_TRX_LINE_ID.

RA_CUST_TRX_LINE_GL_DIST_ALL

This table stores the accounting records for revenue, unearned revenue and unbilled receivables for each invoice or credit memo line. Each row includes the GL account and the amount of the accounting entry. The AMOUNT column in this table is required even though it is null allowed. You need one row for each accounting distribution. You must have at least one (but you can have multiple) accounting distributions for each invoice or credit memo line. Oracle Receivables uses this information to post the proper amounts to your general ledger. If your invoice or credit memo has a transaction type where Post to GL is set to No, Oracle Receivables assigns Null to GL_DATE. If your AutoAccounting is unable to complete your general ledger default accounts using the AutoAccounting rules you define, incomplete general ledger accounts are stored in CONCATENATED_SEGMENTS. If you are importing a transaction through AutoInvoice and the general ledger date of your transaction is in a closed accounting period, AutoInvoice uses the general ledger date of the first open accounting period and stores the original general ledger date in ORIGINAL_GL_DATE. ACCOUNT_CLASS defines which type of distribution row you are on. The ACCOUNT_CLASS REC represents the receivable account and is for the total amount of the invoice. There can be at most two REC rows. One that has a ACCOUNT_SET_FLAG set to Y and the other has ACCOUNT_SET_FLAG set to N. Use LATEST_REC_FLAG to join to the later of the two rows. ACCOUNT_SET_FLAG is Y if this row is part of an account set. An account set is a set of rows that represent a model distribution. Account sets are used for invoices with rules. The rows represent how the actual distribution rows should be created and what percentage of the actual distribution should be allocated to each account. For invoices with rules, the distributions are not created when the invoice is initially created. Instead, the invoices are created when the Revenue Recognition program is run. The primary key for this table is CUST_TRX_LINE_GL_DIST_ID.

AR_PAYMENT_SCHEDULES_ALL

This table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on account credit, or receipt. Oracle Receivables groups different transactions bythe column CLASS. These classes include invoice (INV), debit memos(DM), guarantees (GUAR), credit memos (CM), deposits (DEP),chargebacks (CB), and receipts (PMT). Transaction classes determine which columns in this table Oracle Receivables updates when a transaction occurs, and whether a transaction relates to either the RA_CUSTOMER_TRX_ALL table or the AR_CASH_RECEIPTS_ALLtable. AR_PAYMENT_SCHEDULES_ALL joins to the RA_CUSTOMER_TRX_ALL table for non–payment transaction entries such as the creation of credit memos, debit memos, invoices, chargebacks, or deposits. AR_PAYMENT_SCHEDULES_ALL uses the foreign key CUSTOMER_TRX_ID to join to the RA_CUSTOMER_TRX_ALL table for these transactions. AR_PAYMENT_SCHEDULES_ALL joins to the AR_CASH_RECEIPTS_ALL table for invoice–related payment transactions using the foreign key CASH_RECEIPT_ID. When a receiptis applied, Oracle Receivables updates AMOUNT_APPLIED, STATUS and AMOUNT_DUE_REMAINING. STATUS changes from ’OP’ to ’CL’for any transaction that has an AMOUNT_DUE_REMAINING value of 0(Zero). ACTUAL_DATE_CLOSED and GL_DATE_CLOSED are populated with the date of the latest transaction. For a receipt, the amount due remaining includes on account and unapplied amounts. Oracle Receivables stores debit items such as invoices, debit memos, chargebacks, deposits, and guarantees as positive numbers in the AMOUNT_DUE_REMAINING and AMOUNT_DUE_ORIGINAL columns. Credit items such as credit memos and receipts are stored as negative numbers. In Release 10, receipts can be confirmed or not confirmed as designated by the CONFIRMED_FLAG column. The sum of the AMOUNT_DUE_REMAINING column for a customer for all confirmed payment schedules reflects the current customer balance. If this amount is negative, then this column indicates the credit balance amount currently available for this customer. For invoices with split terms, one record is created in RA_CUSTOMER_TRX_ALL and one record is stored in AR_PAYMENT_SCHEDULES_ALL for each installment. In AR_PAYMENT_SCHEDULES_ALL, DUE_DATE and AMOUNT_DUE_REMAINING can differ for each installment of a split term invoice. Each installment is differentiated by the TERMS_SEQUENCE_NUMBER column. If you create a debit memo reversal when you reverse a receipt, Oracle Receivables creates a new payment schedule record for the debit memo and fills in REVERSED_CASH_RECEIPT_ID with the CASH_RECEIPT_ID of the receipt that was reversed. Oracle Receivables creates a new payment schedule record when you create a chargeback in the Receipts window. ASSOCIATED_CASH_RECEIPT_ID is the cash receipt of the payment you entered when you created the chargeback in this window. GL_DATE_CLOSED indicates the general ledger date on which your transaction was closed. This column identifies which transactions Oracle Receivables selects when it displays current and overdue debit items in the aging reports. The aging reports also utilize the current balances in AMOUNT_DUE_REMAINING to display outstanding amounts for current and overdue debit items. ACTUAL_DATE_CLOSED gives the date on which you applied a payment or credit to an open transaction that set AMOUNT_DUE_REMAINING to 0 for that transaction. Oracle Receivables uses ACTUAL_DATE_CLOSED to determine which transactions to include when you print statements. The primary key for this table is PAYMENT_SCHEDULE_ID, which identifies the transaction that created the row.

AR_RECEIVABLES_TRX_ALL
This table links accounting information with your Receivables Activities. Possible types of activities include Adjustment, Miscellaneous Cash, and Finance Charges. If your type is Miscellaneous Cash, you can associate either a distribution set or a standard accounting flexfield to your Receivables Activity. Oracle Receivables uses one row for each activity. You use your receivables activities to speed receipt entry and generate finance charges. The other types of activities that were valid in release 9 and no longer valid in Release 10 were converted (as part of the upgrade) such that the actual accounting flexfield CODE_COMBINATION_ID is stored in the table instead of the RECEIVABLES_TRX_ID. In Release 9, all of these references were in AR_BATCH_SOURCES; they are now in AR_RECEIPT_METHOD_ACCOUNTS_ALL. The primary key for this table is RECEIVABLES_TRX_ID.

AR_RECEIVABLE_APPLICATIONS_ALL
This table stores all accounting entries for your cash and credit memo applications. Each row includes the amount applied, status, and accounting flexfield information. Possible statuses of your applications include APP, UNAPP, ACC, and UNID. You use this information to determine the applications of your payments or credit memos. CONFIRMED_FLAG is a denormalization from AR_CASH_RECEIPTS_ALL.If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction it is applied against. There are two kinds of applications: CASH and CM (for credit memo applications). This is stored in the column APPLICATION_TYPE. CASH applications represent applications of a cash receipt. When a cash receipt is initially created, a row is created in this table that has a status of UNAPP for the amount of the cash receipt. Each subsequent application creates two rows – one with a status of APP for the amount being applied to the invoice and one with status UNAPP for the negative of the amount being applied. Ifyou reverse a cash application, a row with status APP with the inverse amount of the original application (i.e. the negative of the original application amount) is created. The corresponding UNAPP rows is alsocreated which will have a positive amount (the same amount as the application being reversed). For example: UNAPP 100 creation of a$100 cash receipt APP 60 application of $60 of this cash receipt UNAPP –60 this row takes away (debits) unapplied APP –60 reversal of the $60 application UNAPP 60 this rows puts back(credits) unapplied The sum of the AMOUNT_APPLIED column for CASH applications should always equal the amount of the cash receipt. CM applications, on the other hand, do not have rows of status UNAPP. They only use rows with a status of APP. CASH_RECEIPT_ID stores the cash receipt identifier of the receipt you entered. Oracle Receivables concurrently creates a record of this receipt in the AR_CASH_RECEIPTS_ALL table.This column is null for a credit memo application. CODE_COMBINATION_ID stores valid Accounting Flexfield segment value combinations that will be credited in the General Ledger when this application is posted. A negative value in AMOUNT_APPLIED becomes a debit. The STATUS of a receivable application determines which flexfield account Oracle Receivables uses. For example, if you enter a cash receipt of $500 as Unidentified, Oracle Receivables creates a record in theAR_RECEIVABLE_APPLICATIONS_ALL table with AMOUNT_APPLIED = 500 and STATUS = ’UNID’. Oracle Receivables uses the foreign key CODE_COMBINATION_ID to associate this payment with the Unidentified flexfield account. CUSTOMER_TRX_ID, CASH_RECEIPT_ID, and PAYMENT_SCHEDULE_ID identify the transaction that you are actually applying. APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID identify the invoice or credit memo that receives the application. For example, if you apply a receipt against an invoice, Oracle Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table. The CASH_RECEIPT_ID and the PAYMENT_SCHEDULE_ID of this record identify the receipt you are applying. APPLIED_PAYMENT_SCHEDULE_ID and APPLIED_CUSTOMER_TRX_ID for this record belong to the invoice that is receiving the application. If you apply a credit memo against the invoice, Oracle Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table that has theCUSTOMER_TRX_ID and the PAYMENT_SCHEDULE_ID of the credit memo you are applying. The APPLIED_PAYMENT_SCHEDULE_ID and the APPLIED_CUSTOMER_TRX_ID of this record belong to the invoice that is receiving the application. If you combine an on account credit and a receipt, Oracle Receivables creates a record in the AR_RECEIVABLE_APPLICATIONS_ALL table. The PAYMENT_SCHEDULE_ID and the CASH_RECEIPT_ID of this record identify the receipt. The APPLIED_PAYMENT_SCHEDULE_ID and the APPLIED_CUSTOMER_TRX_ID of this record identify the on account credit that you are combining with the receipt. The primary key for this table is RECEIVABLE_APPLICATION_ID, which uniquely identifies the transaction that created the row.

Installing Oracle 9i on Windows

2010-04-05T11:16:00.005+05:30

Click Here to Enter the Tutorial

.

Free Studio: One installation for 23 programs

2010-04-05T00:09:00.003+05:30

Free Studio is a single package which bundles all free software from DVDVideoSoft to work with DVD, video and audio files!

With this free software you can convert video and audio files between different formats and to iPod, PSP, iPhone, BlackBerry and other portable devices; burn and rip DVDs and audio CDs; upload and download videos and music to your computer, iPod, PSP, iPhone and BlackBerry; perform basic editing of audio and video files.

Free YouTube Download
Free YouTube to MP3 Converter
Free YouTube to iPod and PSP Converter
Free YouTube to iPhone Converter
Free YouTube Uploader

Free DVD Video Converter
Free Video to DVD Converter
Free Video to Flash Converter
Free 3GP Video converter
Free Video to iPod and PSP Converter
Free Video to iPhone Converter
Free Video to MP3 Converter
Free Video to JPG Converter
Free Audio Converter
Free Audio to Flash Converter

Free DVD Video Burner
Free Disc Burner
Free Audio CD Burner
Free DVD Decrypter
Free Audio CD to MP3 Converter

Free Video Dub
Free Audio Dub
Free Video Flip and Rotate

Click Here To Download (30MB Version: 4.3.6.80)

ORACLE SQL*Plus: An Introduction and Tutorial

2010-03-31T23:23:00.017+05:30

Contents

1. Introduction

2. Oracle Products: An Overview

2.1 Application Development Tools

2.2 Database Utilities

2.3 Connectivity Products

2.4 Core Database Engine

3. SQL*Plus Basics

3.1 Running SQL*Plus

3.2 SQL*Plus Commands

3.3 SQL*Plus Help Facilities

4. The SQL Language

4.1 SQL Statements

4.2 SQL Data Definition Language

4.2.1 Create, Modify and Drop Tables, Views, Indexes and Sequences

4.2.2 GRANT and REVOKE Statements

4.2.3 Synonyms

4.3 SQL Data Manipulation Language

4.3.1 Select, Insert, Update, Delete, Commit and Rollback Data

4.3.2 Displaying Table Metadata

4.3.3 Oracle Pseudo-Columns

4.3.4 Oracle SQL Functions

4.3.5 Examples of SQL DML Statements

Basic Select Statements

Selecting from 2 or More Tables

Recursive Queries and Table Aliases

Tree Queries

WHERE Clause Expressions

Examples of SQL Functions

5. Advanced SQL*Plus Commands

5.1 Editing The SQL Buffer

5.2 Formatting SQL*Plus Output

5.3 Saving SQL*Plus Output using the SPOOL Command

5.4 Prompting and Accepting user Input

5.5 Collecting Statistics On SQL Statements

5.6 Using the ALTER SESSION Statement for Date Formats

6. Stored Procedures and Triggers

6.1 Trigger Syntax

6.2 Trigger Example

6.3 Stored Procedure Example

7. Acknowledgements

The chennai one TCS office

2010-03-25T09:25:00.001+05:30

Captured by me at the time of Motorola sports meet.

Soft and hard reset Nokia 5800

2010-03-19T00:14:00.000+05:30

Soft Reset

The reset will restore all the phone’s settings to factory default and delete all user info. You need to use the dialer to enter this code.

*#7370#

Hard Reset

Hard reset only works if you had previously updated the phone to v20. Please make backup before applying this type of reset, since it will restore the phone’s settings as well as erasing all the data in the phone memory.

Switch off the phone.
Press GREEN + RED + CAMERA + ON simultaneously until you see the “Select Country” option.
Note:

The default password is 12345. You need to press and hold the key until the number appear.
Please do not confuse “revert to factory settings” with soft reset. “Revert to factory settings” can be achieved from Menu > Settings > Phone > Phone mgmt. > Factory settings or *#7870# code, and will only restore the phone to its factory setting without deleting data.

*Nokia WaveSecure Sync Issues: Calendar

2010-01-18T09:37:00.001+05:30

WaveSecure is very nice application that I have ever seen. As per the below screen shot the application is allowing sync for CONTACTS, SMS, CALENDAR, and CALL LOGS.

But after sync, I am able to see only CALENDAR is not syncing. DOnt know what happened. But I am sure the sync happened before when I installed it for the first time when I bought my 5800 tube before one year.

Below is the screen shot after sync happened.

*On top of Thiruvanmiyur R.Station way bridge in a Sunday Eve

2010-01-18T08:48:00.002+05:30

Myself and achuthan were going to chennai citi centre. I was crazy about new cars and heard tata indigo manza demo will be there in citi centre through facebook. So thought of going there. The car was very big and even the base model costs ~5 lakh. From there we went to marina beach which was modified last month. And around 8 we returned. Thus a sunday eve came to an end.

*Wikipedia Reader Widget for mobile phones

2010-01-14T21:12:00.001+05:30

Wikipedia Reader Widget is a Web Runtime application that allows reading Wikipedia pages in a format appropriate for small screens.

Installation

Get the widget from File:Wikipedia.wgz
Upload the Wikipedia.wgz file to your phone (e.g. by sending over Bluetooth)
Open the .wgz file by clicking or tapping, and proceed with installation
After installation, the application icon can be found in the "Applications" or "Installations" folder depending on phone model
For detailed installation instructions see How to get an app to the phone.

Source

If you are interested in viewing the Wikipedia Reader widget source code, the code is available in the installation package. Just change file extension to zip and unzip the file.

All code written specifically for this widget is in the public domain - no license is required for any use. However, a number of files in the package have their own license (e.g. WRTKit). Please refer to license text in source files for details.

Support

Supported phones
The Wikipedia Reader widget is in beta, but should work on:

All Series 60 3rd Edition FP2 and later phones
Samsung Series 60 3rd Edition FP1
Nokia Series 60 3rd Edition FP1 phones with latest firmware update

*A rare view of the President's palace and the Parliament building in New Delhi

2010-01-06T11:46:00.019+05:30

*A group from Vaishnava, a sect founded by a Hindu mystic. His followers are called Gosvami-maharajahs

2010-01-06T11:46:00.018+05:30

*An aerial view of Jama Masjid mosque in Delhi , built between 1650 and 1658

2010-01-06T11:46:00.017+05:30

*The Imperial Airways 'Hanno' Hadley Page passenger airplane carries the England to India air mail, stopping in Sharjah to refuel

2010-01-06T11:46:00.016+05:30

*See what the India was at 1835.......

2010-01-06T11:46:00.015+05:30

Just read what INDIA was as per LORD MACAULAY on his statement on 2nd February 1835, in the last snap. That would really shock us Old Photographs from Indian History

The daughter of an Indian maharajah seated on a panther she shot, sometime during 1920s.

2010-01-06T11:45:00.021+05:30

*ഇവിടം സ്വര്‍ഗമാണ്(It is heaven here)

2010-01-06T11:45:00.017+05:30

The Grand Trunk Road , built by Sher Shah Suri, was the main trade route from Calcutta to Kabul

2010-01-06T11:45:00.014+05:30

A British man gets a pedicure from an Indian servant

2010-01-06T11:45:00.013+05:30

WAR IN THE HIMALAYAS: 1962 INDO-SINO CONFLICT

2009-12-01T12:39:00.001+05:30

1. The Battle of Walong

Without a mention of the heroic resistance offered at Walong, by the Indian Army, no story of the 1962 Indo-Sino conflict will be complete. Read the events of the Battle of Walong by author L.N. Subramanian.

2. The Battle of Chushul

The Battle of Chushul was the decisive conflict in Aksai Chin when the Chinese Army were held in 1962, despite superior numbers.

3. The Battle of Namka Chu

The Battle of Namka Chu is a place where the decisions made by a pacifist Prime Minister, an arrogant Defence Minister and a politically connected General caused the rout of a proud Brigade with many of its men dying like animals in a cage.

4. Official 1962 War History

Times of India brings you the exclusive Official War History of the 1962 Indo-Sino Conflict, written & researched by the History Division, Ministry of Defence, Government of India.

5. Men of Steel on Icy Heights

The Battle of Rezang La must never be forgotten, as it was here where the Indian Army fought to to the Last Man, Last Round. Mohan Guruswamy gives us a brief overview of that heroic battle.

6. The Last Stand at Lagyala Gompa

An exclusive insight into a heroic battle that was never recorded in such detail before. A soldier's untold story now told.

7. Injustice to Ahir Martyrs of the 1962 War

Atul Yadav recounts the heroics of the 'Ahir' Jawans of the Indian Army during the Battle of Chushul.

8. The Himalayan War: A Historical Perspective

Webmasters Harshavardhan Vedak and Vikrant Chitre recount the forgotten saga of the tragic 1962 Indo-Sino War.

9. Remembering a War: The 1962 India-China conflict

Rediff.Com takes us back to 1962 and the Indo-Sino War with articles from a number of authors and journalists.

10. Pictorial Gallery: The Clash of the Asian Giants

A poignant pictorial gallery of the Indian Army's operations against China.

Pakistan’s Star Role On HBO Documentary

2009-11-29T06:09:00.000+05:30

Pakistan’s Star Role On HBO Documentary

Today we mark the one year anniversary of the darkest day in South Asia’s history. On November 26, 2008, ten misguided young men who were being controlled by a command center in Pakistan reached Mumbai in a small fishing boat. Before entering the shores of Mumbai these terrorists had already killed the captain and crew of the boat.

HBO today televised a documentary narrated by Fareed Zakaria, a Mumbai born American journalist. ‘Terror in Mumbai.’ an extremely informative documentary compresses three days of mayhem – three days when ten Pakistani young men who had mobile phones and machine guns killed 170 people and wounded 300 more, sending shockwaves of fear around the world. I was horrified watching this 360-degree view of the terrorist act, recounted in harrowing detail – especially because these young men came from a country, I call my own.

Phone calls intercepted and recorded between these men sent on ‘jihad’ and their commander in Pakistan were heart wrenching. And, so was statement of Kasab, the only gunman who survived. As this documentary depicted, these young Pakistan men received instructions over the telephone, leaving a trail of evidence that led Indian investigators to the Pakistan-based Lashkar-e-Taiba (LeT), a group fighting Indian rule in the disputed region of Kashmir. Pakistan’s military and ISI were also accused of backing the militants, a charge Islamabad has denied. New Delhi named 38 people in an 11,000-page charge sheet filed in a Mumbai court in February.

At some level I feel sorry for these lost souls- poverty stricken, uneducated young men who were fooled by conniving leaders of LeT and other fundamentalist organizations, However, I have no sympathies for their leaders- whomsoever they maybe. These characters have eroded the Pakistani society and have pushed us in a state of profound crisis.

I can’t forgive them because these morally corrupt LeT leaders have pushed us in a crisis that is complex, and multi-dimensional with facets that touch every aspect of our lives: our health and livelihood, the quality of our environment and our social relationships, our ideology, economy, and politics. It is a crisis of intellectual, moral, and spiritual dimensions; a crisis of a scale and urgency unprecedented in Pakistan’s 63 year history..

As a Pakistani, I stand today with my head down – embarrassed that my country has been hijacked by illiterate and irrational people – from self styled clergy to the army. These men will do anything they can to pursue their fantasy. Even if that means hoodwinking simple, young Pakistani men and murdering of innocent civilians on both sides of Indo-Pak border.

Undoubtedly, India is a belligerent regional hegemony and we must protect Pakistan’s sovereignty, independence and dignity. But these wayward leaders who exploit religion and patriotism have managed to drown the voices of reason and rationality. With Petro dollars supported tribal and Wahabi influence Pakistan’s social structures and behavior patterns have become so rigid that this country can no longer adapt to changing situations, it is unable to carry on the creative process of cultural evolution.

Read response to my earlier blogs and you will find an eerie uniformity of opinion. Even those who are tolerant, progressive, democratic are willing to condone terrorists in the name of Islam and nation. This uniformity and lack of self-reflection are clear signs that our society is in the process of disintegration.

As I watched this documentary I was reminded of acts of terrorism Pakistanis witness everyday- every Pakistani is a victim. Unless Pakistan’s progressive and democratic forces are willing to take on the retrogressive elements we will concede our right to opinion, education and way of life. Fundamentalists will prohibit freedom of expression and use all coercive apparatus to crush opposition. Education will be discouraged and whatever little is allowed, will be subverted by distortion of curricula. You can argue what is new- it has always been the case? It is the intensity that will change. We are not talking about FATA or NWFP or the tribal areas. This monster is already in cosmopolitan cities like Karachi and Lahore.

I was horrified to hear the Punjabi accent of those controlling these 10 terrorists. I was horrified when these young men were ordered to shoot hostages- I can’t express my anger and fear.

We, the Pakistani people should seek forgiveness from the families of those who lost loved ones in Mumbai. We should let the people of Mumbai know that we are just as much a victim. We should let them know that we don’t condone these acts of violence.

We, the Pakistani people should let our rulers know that they can’t indulge in adventurism like LeT anymore. We should let ISI and MI know that we will not pay their salary if they do not immediately cease all relations with all terrorist outfits.

Tsunami watch issued for five countries canceled

2009-08-11T04:26:00.000+05:30

Styles Of Sree

Bangkok Pattaya Thailand

Beginner's Guide : Administering Oracle Application – Part – I

Beginner's Guide : Administering Concurrent Program – Part – II

Beginner's Guide : Understanding Concurrent Managers – Part – III

Planning Manager

Program Requirements

Configuration of Planning Manager

Program Logic

IPhone 5... Still a dream..

Grand Palace - Bangkok,Thailand

Rolling Up Assembly Costs

To roll up assembly costs:

See Also

Bills and Cost Rollups

sree

Oracle Applications: Significance of Profile Options

Oracle Applications – Acoounts Receivables (AR) Tables Information.

Installing Oracle 9i on Windows

Free Studio: One installation for 23 programs

ORACLE SQL*Plus: An Introduction and Tutorial

The chennai one TCS office

Soft and hard reset Nokia 5800

*Nokia WaveSecure Sync Issues: Calendar

*On top of Thiruvanmiyur R.Station way bridge in a Sunday Eve

*Wikipedia Reader Widget for mobile phones

*A rare view of the President's palace and the Parliament building in New Delhi

*A group from Vaishnava, a sect founded by a Hindu mystic. His followers are called Gosvami-maharajahs

*An aerial view of Jama Masjid mosque in Delhi , built between 1650 and 1658

*The Imperial Airways 'Hanno' Hadley Page passenger airplane carries the England to India air mail, stopping in Sharjah to refuel

*See what the India was at 1835.......

The daughter of an Indian maharajah seated on a panther she shot, sometime during 1920s.

*ഇവിടം സ്വര്‍ഗമാണ്(It is heaven here)

The Grand Trunk Road , built by Sher Shah Suri, was the main trade route from Calcutta to Kabul

A British man gets a pedicure from an Indian servant

WAR IN THE HIMALAYAS: 1962 INDO-SINO CONFLICT

Pakistan’s Star Role On HBO Documentary

Pakistan’s Star Role On HBO Documentary

Tsunami watch issued for five countries canceled