, , , , ,

11i and R12-Changes

11i and R12

In 11i the field ‘bank_account_id’ acts as a relation key between the AP_CHECKS_ALL and AP_BANK_ACCOUNTS_ALL tables.

In 12 i the same field is no longer is used in ‘AP_CHECKS_ALL’ table.

In 12 i where ‘CE_BANK_ACCT_USE_ID’ is acts as a relation between ‘CE_BANK_ACCT_USES_ALL’ and ‘AP_CHECKS_ALL’

Highlights of release 12i

A single responsibility to access and transact on multiple organizations.
A single ledger to manage multiple currencies.
Ledger sets to manage accounting processes across ledger.
Centralized rules engines for tax, accounting and Intercomapny.
Centralized trading partners i.e Suppliers, Banks, First Party legal entities.
Simplified reporting via XML Publisher and DBI.
Netting across trading partners.

/by
, ,

1099 Overview

Form 1099 is a form promulgated by the Internal Revenue Service and is used in the United States Income Tax System to prepare and file information return to report various type of income other than wages, salaries and tips (for which form W2 is used instead).
Each payer must complete a 1099 for each covered transaction. Three copies are made one for he payer , one for the payee and one for the IRS.
US Tax law requires business to submit a Form 1099 for every contractor paid at least $600 for service during a year. This requirement usually does not apply to corporations receiving payments.
Many business and organizations must file thousands of 1099s per year. Thus payers who file 250 or more Form 1099 reports must file all of them electronically or magnetically with the IRS. The 250 or more requirement applies separately for each type of return and separately for each type of corrected return. Even though filers may submit 249 information returns on paer, the IRS encourages files to transmit returns electronically.
If the less than 250 or more requirement is met, and paper copies are filed, the IRS also requires the payer to submit a copy of form 1096. The 1096 is a summary of information forms being sent to the IRS. You need one 1096 for each type of information form you have issued.
Payees use the information provided on the 1099 forms to help them complete their own tax returns. In order to save paper, payers can give payees one single Combined Form 1099 that lists all of their 1099 transactions for the entire year. Taxpayers are usually not required to attach Form 1099s to their own Federal income tax returns unless the Form 1099 includes a report for Federal income tax withheld by the payer from the related payments.
several versions of Form 1099 are used, depending on the nature of the income transaction:
1099-A: acquisition or Abandonment of Secured Property
1099-B: Proceeds from Broker and Barter Exchange Transactions
1099-C: Cancellation of Debt
1099-CAP: Changes in Corporate Control and Capital Structure
1099-DIV: Dividends and Distributions
1099-G: Government Payments
1099-H: Health Insurance Advance Payments
1099-INT: Interest Income
1099-LTC: Long Term Care Benefits
1099-MISC: Miscellaneous Income
1099-OID: Original Issue Discount
1099-PATR: Taxable Distributions Received From Cooperatives
1099-Q: Payment from Qualified Education Programs
1099-R: Distributions from Pensions, Annuities, Retirement Plans, IRAs, or Insurance Contracts
1099-S: Proceeds from Real Estate Transactions
1099-SA: Distributions From an HSA, Archer MSA, or Medicare Advantage MSA
1042-S: Foreign Person’s U.S. Source Income
SSA-1099: Social Security Benefit Statement
SSA-1042S: Social Security Benefit Statement to Nonresident Aliens
RRB-1099: Payments by the Railroad Retirement Board
RRB-1099R: Pension and Annuity Income by the Railroad Retirement Board
RRB-1042S: Payments by the Railroad Retirement Board to Nonresident Aliens
W-2G: Certain Gambling Winnings
/by
, , , ,

Tracking Transactions using Install Base


The Oracle applications that use Oracle Installed Base are shown the picture.
Several Oracle Order Management, Purchasing, Inventory, Work in process transactions interact with Oracle Installed Base. Oracle Installed Base can track both shippable and non-shippable items.
Purcahse Order
In case of purchase orders when the receipt of materials is completed, system increases the Inventory on hand. If installed Base is used then the tracking of the material is also started with the receipt completion. Installed Base creates an item instances for each of the received items which are marked as ‘Tracked in Installed Base’.
Order Management
A sales order shipment generates an Inventory Issue material transaction in Oracle Inventory application. Because Oracle Installed Base also tracks the internal inventory for trackable items, the instance already exists in Oracle Installed Base. A shipment can result in a change in instance location and ownership, status, and so on, based on the associated Oracle Installed Base transaction subtype.
/by
, , , , ,

R12 Installed base Setups

 All All the functionalities of installed base module can be accessed with Installed Base User responsibility. And to access the’ Installed Base User’ responsibility’ the user must be assigned to CSI_NORMAL_USER role.
Follow the below setups to assign the required roles to Installed Base Users

1. Login to the instance with sysadmin user and select CRM HTML Administration responsibility
2. Navigate to Setup : Users : Registration: user Maintenance
3.  Query the user name, click on the hyperlink for the user
4.  Add the CSI_NORMAL_USER role. Update.
The responsibility “Install Base User” is obsolete in Release 12.  The new responsibility is called ‘Oracle Installed Base Agent User’
Notice that the Role assignment via CRM HTML administrator is for Oracle Installed Base User responsibility (ie. JTT page). Oracle Install Base Agent User responsibility is a new one in R12.

Profile Options
 The Important Profile Options which needs to be set at the site level are
Service: Inventory Validation Organization
CSI: Default Instance Status

/by
, , , , , ,

Major Features in Oracle Alerts

Event Alerts
Event alerts immediately notify you of activity in your database as it happens. You define what a database event is – an insert or an update to a table – and Oracle Alert informs you when it happens. You can modify our precoded alert conditions or simply create your own, and Oracle Alert will send messages or perform predefined actions in
an action set when important events occur.
Periodic Alerts
Periodic alerts periodically report key information according to a schedule you define.
You can modify our precoded alerts or simply create your own, and Oracle Alert will send messages or perform predefined actions from an action set according to the schedule you set.
You can define periodic alerts on any Oracle Financials, Oracle Manufacturing, Oracle Human Resources, or Oracle Public Sector Financials application as well as any custom Oracle application.
Periodic alerts can be set to run as often as you need during a 24-hour period, or they can be set to run once a month – the frequency is up to you. Used over time, periodic alerts can provide a regular and reliable measure of performance.
For example, you can define a periodic alert for Oracle Purchasing that sends a message to the Purchasing Manager listing the number of approved requisition lines that each purchasing agent placed on purchase orders. You can define this alert to run weekly, and provide performance measurement on a consistent and timely basis.

Easy Alert Definition
Oracle Alert can load the SQL statement for your alert definition from an operating system file, allowing you to automatically perform the functions you currently do by hand. Oracle Alert will also transfer your entire alert definition across databases. You can instantly leverage the work done in one area to all your systems.
Customizable Alert Frequency
With Oracle Alert, you can choose the frequency of each periodic alert. You may want to check some alerts every day, some only once a month, still others only when you explicitly request them. You have the flexibility to monitor critical exceptions as frequently as necessary, even multiple times during a 24-hour period. You can also check less significant exceptions on a more infrequent schedule; for example, once a month.
Customizable Alert Actions
You can define a variety of actions for Oracle Alert to perform based on the exceptions it finds in your database. Oracle Alert can send an electronic mail message, run a SQL script or an operating system script, or submit a concurrent request, or any combination of the above. You can create your own message, SQL script, or operating system script
actions in Oracle Alert, or have Oracle Alert send messages or perform scripts that reside in external files. Each action is fully customizable to the exceptions found in your database, so you have complete flexibility in your exception management.
Detail or Summary Actions
You can choose to have Oracle Alert perform actions based on a single exception or a combination of exceptions found in your database. You can define a detail action such that Oracle Alert performs that action for each individual exception found. You can also define a summary action such that Oracle Alert performs that action once for each
unique combination of exceptions found. You decide which exceptions you want Oracle Alert to consider as a unique combination. You can format a detail or summary message action to display the exception(s) in an easy-to-read message.
No Exception Actions
Oracle Alert can perform actions if it finds no exceptions in your database. You can define Oracle Alert to send electronic mail messages, run SQL scripts or operating system scripts, or submit concurrent requests, or any combination of the above.
Alert History
Oracle Alert can keep a record of the actions it takes and the exceptions it finds in your database, for as many days as you specify. When you ask Oracle Alert to reconstruct alert history you see a complete record of alert activity exactly as it was performed. You can even review all responses Oracle Alert received to your messages and the actions
they invoked. Oracle Alert also lets you decide which information you want to review.
You can narrow your review criteria so you see only the history you specifically want to examine, without sorting through all the history information available for an alert.
Duplicate Checking
Oracle Alert can search for exceptions that remain in your database over time, and can take certain actions based on the presence of those “duplicate exceptions.” You can track exceptions in your database for the length of time that you save history for your alerts.
Action Escalation
You can define a sequence of actions and have Oracle Alert perform the next action in that sequence each time it finds the same exception or exceptions in your database. For example, you can have Oracle Alert send messages of increasing severity if it finds the same exceptions over a period of time. Using action escalation, you can make sure that exceptions needing attention don’t languish unattended in your database.
Summary Threshold
Oracle Alert can automatically determine whether to perform a detail or a summary action based on the number of exceptions it finds in your database. If your alert locates few exceptions, it can simply perform detail actions-one for each exception. If your alert locates many exceptions, it can perform a summary action on all of those exceptions.
Oracle Alert automatically determines when it should perform a detail or a summary action.
Response Processing
Oracle Alert can take certain predefined actions based on a user’s response to an alert message. The response can cause Oracle Alert to send another alert message, run a SQL script or an operating system script, or submit a concurrent request, or any combination of the above. Because Oracle Alert performs response actions automatically, you can delegate routine user transactions to Oracle Alert and thereby increase your organization’s efficiency.
Self-Referencing Alerts
You can create an alert that checks for exceptions that are new in your database since the last time the alert was checked. The alert uses its own DATE_LAST_CHECKED value as the start time for checking for new exceptions.
Customizable Options and User Profile
You can specify exactly how you want your Oracle Alert user interface to look and behave. From choosing a printer to specifying the header text in your Oracle Alert messages.
Electronic Mail Integration
Oracle Alert allows you to send alert e-mail messages through your mail system using the Simple Mail Transfer Protocol (SMTP) for outbound messages and the Internet Message Access Protocol (IMAP) for inbound messages.
/by