How to add Specifying Dates for Calendar Periods Oracle Assets
By Jag - November 25, 2014
You can started as several calendars as you would like. every book you started needs a depreciation calendar and a prorate calendar. The depreciation calendar determines the amount of accounting periods in an exceedingly twelvemonth, and also the prorate calendar determines the amount of prorate periods in your twelvemonth. you'll use one calendar for multiple depreciation books, and as each the depreciation and prorate calendar for a book.
Your company books will share an equivalent calendar. A tax book will have a distinct calendar than its associated company book. The calendar for a tax book should use an equivalent year name because the calendar for the associated tax book.The depreciation program uses the prorate calendar to work out the prorate amount that is employed to settle on the rate. The depreciation program uses the depreciation calendar and divides depreciation flag to work out what fraction of the annual depreciation expense to require every amount. for instance, if you have got a quarterly depreciation calendar, Oracle Assets calculates quarter of the annual depreciation anytime you run depreciation.
READ: Overview of Oracle Asset Management | Oracle Fixed Asset | R12
READ: Asset Tracking for Depreciable Items
You must at the start discovered all calendar amounts from the amount adore the oldest date placed in commission to this period. you want to discovered a minimum of one amount before this amount. At the tip of every year, Oracle Assets mechanically sets up the periods for consecutive year.
Attention: If you employ this depreciation calendar in a very depreciation book from that you produce journal entries for your leger, you want to create the amount names a twin of the periods you have got discovered in your leger.
You can outline your calendar but you wish. for instance, to outline a 4-4-5 calendar, discovered your financial years, depreciation calendar, and prorate calendar with completely different begin and finish dates, and fill within the uneven periods.
To divide annual depreciation proportionately in step with the amount of days in every amount, enter By Days within the Divide Depreciation field within the Book Controls window.
Specifying Dates for Calendar Periods Oracle Assets
N: - Setup-> Asset System-> Calendars
1. Open the plus Calendars window.
2. Enter the name of your Calendar.Suggestion: The name you enter seems in List of Values windows which permit no quite fifteen areas. you\'ll need to limit your name to fifteen characters.
3. select financial or Calendar to append either the financial or civil year to induce the accounting amount name. If you are doing not need the financial or civil year mechanically appended, select None. For example, if your year runs from Gregorian calendar month one to might thirty one, and also the current date is July fifteen, 1995, you\'re in calendar 1995 and financial 1996. If you specify financial , your amount name is JUL-96. If you specify CALENDAR, your amount name is JUL-95.
4. Enter the year Name you wish to use for this calendar.
5. Enter the quantity of periods within the year for this calendar. Note: you can\'t enter quite 365 periods per annum.
6. Enter the Name of this era. If your periods embody the year, like JAN-1995 and you\'re victimization the hyphen (-) because the suffix delimiter, you need to use either a 2 or four-digit year suffix. Oracle Assets
automatically adds a four-digit year to the tip of the amount name if you are doing not enter a year. Otherwise, you\'ll be able to enter a two-digit year suffix. If you employ this depreciation calendar in an exceedingly depreciation book from that you produce journal entries for your ledger, you want to build the amount names a twin of the periods you have got found out in your ledger.
7. Enter the beginning and finish dates of this era.
8. Save your work.
When you wish to make one payment, instead of a whole payment batch, you either record a manual payment you generated outside of liabilities, otherwise you will produce a fast payment (single pc generated payment).
You'll be able to record zero-amount payments if the checking account you decide on permits themIndividual Payment (Single Payment)
Business Group Information | Creation of Organization Structure
By Jag - November 18, 2014
Use the Organization window to create:
If you employ the Configuration work bench to piece your enterprise structure, then you simply ought to produce the extra internal and external organizations you need. for instance, you'll established further organizations to represent the inner divisions or departments, and external organizations for coverage or third party payments
N: Setup > Organizations > Organizations
- Business groups
- External organizations (for example, tax offices, insurance carriers, disability organizations, benefit carriers, or recruitment agencies)
- Internal organizations (for example, departments, sections or cost centers) GREs/Legal Entities
If you employ the Configuration work bench to piece your enterprise structure, then you simply ought to produce the extra internal and external organizations you need. for instance, you'll established further organizations to represent the inner divisions or departments, and external organizations for coverage or third party payments
Business Group Information
N: Setup > Organizations > Organizations
Rolling Back Depreciation Step by Step Guide | Fixed Assets
By Jag - November 18, 2014
Depreciation rollback restores assets to their state before running depreciation. as an example, you\'ll have outstanding changes or transactions that you just got to method for a amount.
However, you\'ve got already run depreciation for that amount. If the shut amount check box wasn\'t checked once you ran depreciation, depreciation is mechanically rolled back once you method transactions on these assetsFinancial changes and alternative transactions are often created to 1 or a lot of pluss through the asset work table or mass transactions. Oracle Assets can mechanically rollback depreciation on the chosen assets and permit the transactions to be processed usually. The assets that depreciation was rolled back area unit mechanically enclosed within the next depreciation run.
Depreciation is rolled back mechanically by Oracle Assets provided the subsequent conditions area unit met:
- Depreciation has been processed in that period
- The period is not Closed
N:- Rollback Depreciation
How to Define Cross Validation Rules in Oracle | 11 Steps with images
By Jag - November 18, 2014
Flex field checks cross-validation rules whereas making an attempt to form a replacement combination of Flex field values (for example, a replacement Accounting Flex field combination).
Your cross-validation rules haven't any impact on Flex field mixtures that exist already. If you wish to disable associate degree existing combination, you need to disable that combination specifically victimisation the acceptable window. as an example, you'll be able to disable associate degree existing Accounting Flex field combination using the outline Accounting Flex field combinations window.Suggestion: we tend to suggest that you just outline several rules that every have few rule components instead of many rules that every have several rule components. The a lot of rules you give, the a lot of specific you'll be able to build your error message text.
STEPS
N: Setup > Financials > Flexfield > Key > Segments Query Application as
General Ledger and Flexfield Title as Accounting Flexfield
Query Structure as India Accounting Flex
Introduce Base creation for all the Sales Order for which it is missing
By Jag - November 03, 2014
You can utilizing the accompanying bundle to make the IB (Install base) for the deals Order It has missed.
Typically, we empower the Install base choice in the "Expert Item" structure for the Items for which we need to track. On the off chance that
Script to find Scheduled synchronous activities and requesting sets
By Jag - November 03, 2014
How to Script discover Scheduled simultaneous projects and solicitation sets
SELECT
A.request_id,
B.user_name,
C.user_concurrent_program_name,
C.argument_text
FROM
Fnd_concurrent_requests A,
Fnd_user B,
Fnd_conc_req_summary_v C
WHERE
B.user_id = A.requested_by
What's more A.request_id = C.request_id
What's more A.requested_start_date > SYSDATE
What's more A.hold_flag = "N"
What's more A.status_code IN ('Q','i')
What's more B.user_name LIKE "%"
What's more A.description LIKE "%"
Request BY
A.request_id
The underneath are the steps included in the Drop Ship Cycle:
Before you make a request, you need to perform a few setups so as to drop ship, which are recorded in the underneath said article "Drop Ship Setups":
Drop Ship Setups
1. Make Sale Order
2. Book Sales Order
3. Check Status
4. Advance Sales Order
5. Check Status
6. Discharge Purchase Order
7. Import Requisition/ Purchase Order
8. Interface between deals request and buy request
9. Get the material against buy request
10. Check Order status.
Make Sale Order
Route: Order Management Super User >> Order Organizer
Click on ‘New Order’
Enter Order Header Information
Click on 'Line Items' tab
Click the "Delivery" tab and enter Item Number , Quantity and Receiving Organization
Click 'Book Order' catch.
In the event that request is busy effectively then an affirmation message will be shown as demonstrated in the beneath picture.
Click on "Activities" Button under 'Line Items' tab
Select 'Extra Line Information' from the List of qualities and click OK
Select 'Drop Ship' tab.
At this stage we don't have any buy requests made identified with this drop boat request.
Shut the 'Extra Line Information' structure.
Make a note that the line status is "Busy" at this stage.
How about we see the work process status.
Click on Tools >> work process status
Current movement will be " Purchase Release Eligible' with a status of 'Informed'.
Shut the work process status page.
Do a reversal to 'Line Items' and select the line. Right click on it and select 'Advancement Order' alternative as appeared.
Select 'Buy Release – Eligible' choice from List of Eligible Activities.
Click OK.
The 'Line Status' progressions from "Busy" to 'Anticipating Receipt'.
Click on Actions catch
Select 'Extra Line Information'.
Make a note that regardless we don't have 'Buy Order' made for this drop boat request.
Shut the request structure.
Route: Order Management Super User >> Purchase Release
A Concurrent solicitation submit screen will pop up.
Click on Parameters and enter the deals request number that we made above. By doing this simultaneous solicitation will simply handle this specific request as opposed to discharging all pending drop boat request appeals.
Click Submit
Close all open structures.
Route: Purchasing Super User >> Reports >> Run
Select 'Demand Import' program and click on parameters content box.
Enter parameters as takes after
Import Source: ORDER ENTRY
Import Batch ID: Leave it clear
Aggregate By: Item+
Last Requisition Number: Leave it clear
Different Distributions: No
Launch Approval after Reqimport: Yes
Click OK.
Hold up until two simultaneous appeals 'Demand Import' and 'Make Releases' are finished.
Presently do a reversal Order Management Super client obligation
Click on Order Organizer and enter the deals request number.
Click find to open the deals request.
Select Line Items >> Actions >> Additional Information.
At this stage a buy request is made identified with this deals request.
Buy request is in "Sanction" status in light of the fact that we started the endorsement transform by setting the parameter 'Start Approval Process after Reqimport' to yes in the above simultaneous appeal.
On the off chance that you have EDI/ e-business door setup to drop the buy request data to supplier, it ought to trigger now.
Presently Supplier has the buy request data.
Supplier transports the parts to client and will send us back the affirmation.
Once the affirmation is gotten we have to make a receipt.
Route: Inventory >> Transactions >> Receiving >> Receipts.
Select the Receiving Organization that is chosen on transportation tab of line things structure.
Click the buy request number which is found on the extra line data structure or the deals request that is made.
Click find.
The Receipt structure ought to open with the thing data as appeared.
Check stamp the Left checkbox and if the thing is Lot or Serial controlled then click on " Lot – Serial' catch.
Enter the parcel number. For my situation the thing being utilized is part controlled.
Click done.
Spare and close the structure.
About-face to Order Management and check the line status on the request structure.
Presently the line is sent. To close the line run the 'work process foundation process' simultaneous project.
Once the work process foundation methodology finished the line status ought to change from "transported" to 'sh
Find out how to define Accounting Calendar.Step by step Guide with Screen shot
1) Open the Period Types window.General Ledger : Setup > Financials > Calendars > Types
2) Enter the following information
Period Type | Periods Per year | Year Type | Description |
FASS_CAL | 13 | Calendar | 13 Periods Calendar with 1 Adjusting Periods. |
How to Create Item in Master Organization | Oracle Inventory
By Jag - November 01, 2014
Making Items in Item ace are one of the key steps in Oracle Inventory, this is additionally the pith of whole Oracle Apps ERP.
How to Using Forms Based Applications | Oracle General Ledger
By Jag - October 27, 2014
Create Programmatically Flex value for a particular Value set
By Jag - October 26, 2014
Create FND Flex values for a Flex Value Set API Name.Oracle Apps Technical
DECLARE
x_str_value VARCHAR2 (2000);
lv_message VARCHAR2 (2000);
lv_user_id NUMBER := &p_user_id;
lv_resp_id NUMBER := &p_resp_id;
lv_resp_appl_id NUMBER := &p_resp_appl_id;
lv_flex_vs_name VARCHAR2 (60) := '&p_flex_value_set_name';
lv_flex_value VARCHAR2 (60) := '&p_flex_value';
lv_flex_value_desc VARCHAR2 (60) := '&p_flex_value_desc';
BEGIN
--Initialize required if this block is run from within Oracle database
fnd_global.apps_initialize (user_id => lv_user_id,
resp_id => lv_resp_id,
Oracle Time and Labor Tables Query | Oracle OTL Tech Guide
By Jag - October 26, 2014
Special information Typr in oracle HRMS | Upload Data
Table Definition:
CREATE TABLE DEV_SIT
(
LINE_ID NUMBER,
EMPLOYEE_NUM VARCHAR2(240 BYTE),
SIT_NAME VARCHAR2(240 BYTE),
EFFECTIVE_DATE DATE,
DATE_FROM DATE,
DATE_TO DATE,
ATTRIBUTE_CATEGORY VARCHAR2(240 BYTE),
ATTRIBUTE1 VARCHAR2(240 BYTE),
ATTRIBUTE2 VARCHAR2(240 BYTE),
SEGMENT1 VARCHAR2(240 BYTE),
Closing Accounting Periods | Integration with General Ledger
By Jag - October 24, 2014
General Ledger User Guide | Best Practices for all Topics | Oracle ERP R12
By Jag - October 23, 2014
General Ledger User Guide | Best Practices for all Topics | Oracle ERP R12 Step by Step Screen Shot Tutorial
- Auto Invoice Import : Oracle Apps R12
- API - GL Code Combination Creation
- Accounting Flexfield | Account Payables
- Accounting For Oracle Receivables
- Accounts Receivable Auto invoice Setup for R12
- BASIC TAX SETUPS IN E-BUSINESS TAX-R12 – EB-Tax setup
- Back to Back Order Process in Oracle Apps
- Batch payment process in R12 for Electronic payments:Oracle Apps Functional
Integration with General Ledger | Month End Process | Step by Step ScreenShot
By Jag - October 21, 2014
Overview of Oracle Purchasing | Oracle Purchasing | Oracle Apps R12
By Jag - October 21, 2014
Oracle Purchasing is a comprehensive procurement solution designed to:
- Help purchasing professionals reduce administration costs
- Process requisitions, purchase orders, requests for quotation, and receipts quickly and efficiently.
- Enable you to focus on:
- Value Analysis
- Development of strategic supplier relationships
- Management of the procurement process
Oracle Purchasing satisfies the following business needs:
Run NOV AP Invoice Activity Report | Account Payable | Oracle R12
By Jag - October 19, 2014
Run NOV AP Invoice Activity Report | Account Payable | Oracle R12| Step by Step Screen Shot
Run NOV AP Invoice Activity Report
EBS AP Invoicing, AP Payments, AP Supervisor, AP-PO Inquiry, Buyer, Purchasing
Manage
N > View > Requests
Submit Requests
Refer to the document Submit a Request for navigating to the Submit Request form.
Run the NOV AP Invoice Activity Report
Type NOV AP Invoice Activity in the Name field.
Create Assets Responsibility | Oracle Fixed Asset | Step by Step
By Jag - October 19, 2014
Creating Assets Responsibility | Oracle Fixed Asset | Step by Step Screen Shot
Create a super user to use as a
logon name during setup and assign the super user the required setup
responsibilities.
1.
Switch to System Administrator Responsibility
Switch Responsibility: - System Administrator
Responsibilities
Security-> Responsibility-> Define
|
What is payment terms and How it works | Step by Step Screenshot
By Jag - October 18, 2014
What is payment terms Oracle apps r2 and How it works | Exmple Step by Step Screenshot
Payables Manager –> Setup –> Invoice –> Payment Terms
Payments Terms are assigned to an Invoice to automatically create scheduled payment when Payables Invoice Validation is submitted for the Invoice
You can define payment terms to create multiple scheduled payment lines and multiple levels of discounts. You can create an unlimited number of payment terms.
Payment terms have one or more payment terms lines, each of which creates one scheduled payment. Each payment terms line and each corresponding scheduled payment has a due date or a discount date based on one of the following:
- a specific day of a month, such as the 15th of the month
- a specific date, for example, March 15, 2002
- a number of days added to your terms date, such as 14 days after the terms date
- a special calendar that specifies a due date for the period that includes the invoice terms date. Only due dates can be based on a special calendar. Discount dates cannot be based on a special calendar.
Define Payment Terms
Overview of Oracle Asset Management | Oracle Fixed Asset | R12
By Jag - October 18, 2014
Overview of Oracle Asset Management | Oracle Fixed Asset
Oracle Assets automates asset management and simplifies accounting tasks. Using a unified source of asset data (with data from your Oracle applications as well as external feeder systems), Oracle Assets gives you visibility into your assets worldwide. Standard management tasks-such as asset transfers, disposals, reclassifications, financial adjustments, and tax legacy data conversion-can be streamlined with automated business flows.
Standard accounting, operational, and registry reports are available to ease reconciliation and analysis.
Open Period of Secondary Ledger | General Ledger | Oracle Apps R12
By Jag - October 17, 2014
1.Open Period of Primary Ledger
2.Open Period of Secondary Ledger
We cannot post in Primary Ledger if the same period is not opened in the secondary ledger.
Login as GL Secondary Ledger Super User or switch to GL Secondary Ledger Super User
Responsibility.
Open the form Open/Close
General Ledger: Setup > Open/Close
Click
Find Periods |
Open Period of Primary Ledger | General Ledger | Oracle Apps R12
By Jag - October 17, 2014
Open Period of Primary Ledger | Step By Step ScreenShot
1.Open Period of Primary Ledger
2.Open Period of Secondary Ledger
Login as GL Primary Ledger Super User or switch to GL Primary Ledger Super User
responsibility.
Open the form Open/Close
General Ledger: Setup > Open/Close
Search the period need to be opened. Here we have defined AUG-07 as our first period
FInd Periods
Click on Find |