To share some of knowledge, work and how-to, trick, tips in Oracle. Mainly focus with Oracle Financials, Oracle Technology, Oracle Business Intelligence. Also to cover Project Management, IT Governance, Quality Practices and all.

Solution for location issue…..
If you have a newly installed Vision instance and you are trying to create a location, you might end up getting this error. Which means you can’t create a location and your get the error Create Location gives error: FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-29273 You might be wondering how do i proceed??? The solution is simple. Look at the profile: IRC: Geocode Host and make sure that there is no value for that. Sometimes there is an url as the value at the site level and that causes the problem. Remove it and save your work. You should be good to
for any queries related HRMS Training post me to maahmed09@gmail.com

Purchase Request is a precise document generated by an internal or external organization to notify the purchasing department of items it needs to order, their quantity, and the time frame that will be given in the future

A requisition is used in business as an internal document used to notify stores or the purchasing department of items that are needed or need to be ordered. It sets out the quantity and the time frame. It may also contain the authorization to proceed with the purchase if the required items are not available in stock.

A purchase requisition is not a purchase order and therefore should never be used to purchase goods or services or be used as an authorization to pay an invoice from a supplier or service provider.

Requisitions in Oracle

Purchase Requisitions

Use the Requisitions window to create requisitions. You must choose the requisition type (internal or purchase). You can also provide a description, unlimited notes, and defaults for requisition lines. For each requisition line, you choose the item you want to order along with the quantity and delivery location. You can get sourced pricing from catalog quotations or open blanket purchase agreements. You can also choose a price from a list of historical purchase order prices. In the Distributions window, you can charge the item to the appropriate accounts, or you can let the Account Generator create the accounts for you. Once you complete the requisition, you send it through the approval proces

Internal Requisitions

Unlike purchase requisitions, which are supplied from purchase orders, internal requisitions are supplied from internal sales orders. Internal requisitions are not picked up when you AutoCreate RFQs or purchase orders, nor can they be assigned to a buyer in the Assign Requisitions windo

Oracle Tables

PO_REQUISITION_HEADERS_ALL (SEGMENT1 column in this table represents the requisition number)

This table stores Header information of a Purchase Requisition.

Important columns of this table:

REQUISITION_HEADER_ID: It is a unique system generated Requisition identifier

PREPARER_ID: It is a unique identifier of the employee who prepared the requisition

This table stores information about the accounting distributions of a requisition line. Each requisition line must have at least one accounting distribution. Each row includes the Accounting Flexfield ID and Requisition line quantity.

Giving Presentations for Work, Training or any other purpose is very common now days. It involve creating powerpoint slides, notes and delivering it. Here i am trying to put some points on how to make your first presentation as better and learning experience.

2. Research your topic : Do some learning on Topic and brush up your knowledge. Read user guide or whitepaper or discuss with friends or senior to brush it up. User guide and Oracle support always good tools

4. Note : for Each slide or topic, write down what you think of speaking. Writing will help to get more points and help in practicing.

DELIVER

1. Voice : Try to be natural . Try to make it as conversation or like you are explaining some new game to your friends. Or you are telling movie review :) . Keep voice consistent with pace and tone.

2. Body Language : Stay relax, feel relax. Make good eye contacts. if you are nervous then look at people you feel comfortable. Use your hands , arms and gesture. Take pauses if needed. don’t hurry.

3. Practice : Practice , Practice and Practice ( 3 times at least ). User full size mirror to do practice. Record your voice in mobile phone. Even you can record your video and see it again and correct your words, language or body gestures and again practice.

4. Memorized your introduction and first 2 minute at least , this will create good start and good impression :)

4. Smile and confident : Always keep a genuine comfort smile and feel yourself confident. Giving presention is regular activity as IT professional and slowly slowly you will master it.

The requirement from client to change the old leave accrual plan to a new plan.
For grades G1 and G2, leave per year is 24 days and they are increasing it to 28 days. we can simply change it in the formula and the plans and elements are all saved like “Accrual Plan 24″. This has to be changed to “Accrual Plan 28″. so we created a new accrual plan its working correctly

The issue what we are facing is when we end date the accrual plan 24 and attaching the accrual plan 28, the leave balance is resetting to 0. we need to add the older leave balance with the new one.
how it can be done?

With the current PTO
functionality, there is no mechanism to transfer accruals from one plan to
another. So if an employee leaves Plan A in the middle of the year and joins
Plan B, they lose all the year’s accruals for plan A. To correct
the accrual balance of Plan B, an adjustment element must be
created and added to the NCR (Net Calculation Rules) on the Accrual Plan. Manual process:

Every Financial implementation expect change in standard AR Invoice template layout. Now with BPA ( Bill Presentment Architecture ) , we can avoid any customization along with quite good handy feature…

have you seen a new button available for completed transactions in the Transactions Workbench. The button opens a web-based window that shows the transaction details. this icon in the Transactions Workbench is for a Bill Presentment Architecture (BPA). The setup and wording of the window can be customized through the Bill Presentment Architecture module.

BPA is a module that allows you to retrieve billing data from multiple data sources for presentment on a bill. This means that the physically presented bill is no longer limited to information contained within Oracle Receivables. BPA provides template-based configuration of online and printed bills, giving you the ability to select the content of the bill, choose the layout design, display parent billing lines and drilldown details, and then set up the assignment of these billing templates by defining rules based on criteria you specify. By separating bill presentment from transaction accounting, Oracle BPA allows for more understandable and comprehensive bills, increasing the likelihood and timeliness of bill payment.

BPA provides the architecture to retrieve billing data from multiple sources, including transaction flexfields and other data not interfaced and stored in Oracle Receivables. Because bill presentment is not limited to transaction accounting information, you can present bills that are more comprehensive and meaningful to your customers.

With BPA, you first indicate the data sources that you want to collect billing data from. BPA provides a framework for collecting billing data stored in:

Oracle Receivables

Oracle applications seeded in BPA, such as Oracle Order Management and Oracle Service Contracts

Other Oracle applications

Legacy systems and other non-Oracle applications

You then design billing templates for each transaction class, choosing the layout and content to determine how you want billing data to appear in an online or printed bill, and assign the templates to customers or customer categories. You can print bills individually or in batches from your billing templates created within BPA or uploaded from external sources.

Customizing the bills that your customers see helps them reconcile bills with purchase requests and facilitates timely bill payment.

Your customers can view summarized billing information and drill down using hyperlinks to detailed billing information and other related details necessary to understand and pay the bill.

Get your Email Subscribed for Latest Articles in your INBOX
Once you submit your email for subscription, you will get an email in your inbox to confirm your subscription, you need to activate your subscription by clicking activation url in that email...here you go, get all updates/ articles in mail.