Saturday, March 12, 2016

Enterprise resource planning (ERP), Oracle

  • Oracle E-business Suite 
  • Oracle Financial 
  • Oracle Supplychain (SCM)


Enterprise Resource Planning (ERP)



An Enterprise Resource Planning (ERP) system is an integrated computer-based application used to manage internal and external resources, including tangible assets, financial resources, materials, and human resources. Its purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders. Built on a centralized database and normally utilizing a common computing platform, ERP systems consolidate all business operations into a uniform and enterprise-wide system environment.







Main Features of our ERP include:


  • Financials
  • Supply chain management (SCM)  
  • Manufacturing
  • Warehouse Management 
  • Distribution
  • Customer Relationship Management (CRM)
  • Decision Support





Oracle Financials:




Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with:





Oracle Assets:

Ensures that an organization's property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.

Oracle General Ledger:

Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.

Oracle Payables:


 Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payments.

Oracle Cash Management:

Lets you perform bank reconciliation and cash forecasting.

Oracle Receivables:

 Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.





Oracle Supply Chain Management (SCM):





Supply chain management (SCM) is the oversight of materials, information, and finances as they move in a process from supplier to manufacturer to wholesaler to retailer to consumer. Supply chain management involves coordinating and integrating these flows both within and among companies. It is said that the ultimate goal of any effective supply chain management system is to reduce inventory (with the assumption that products are available when needed).



 


Oracle Inventory:

Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.

Oracle Order Management:

Provides organizations with a sophisticated order entry system for managing customer commitments.

Oracle Purchasing:

 Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.

Oracle Sourcing:

 Online negotiation with suppliers and online interaction with supplier tracking receipt




____________________

Chart of Account (COA)





A chart of accounts (COA) is a created list of the accounts used by a business entity to define each class of items for which money or the equivalent is spent or received. It is used to organize the finances of the entity and to segregate expenditures, revenue, assets and liabilities in order to give interested parties a better understanding of the financial health of the entity







Chart of Account Components:


1) Assets
2) Liabilities
3) Owners' Equity
4) Revenues
5) Expenses



The structure of the chart of accounts is important because it helps organize the accounts and identify their location...




The structure of the chart of accounts is important because it helps organize the accounts and identify their location...
Asset Accounts:
Cash, Bank Accounts, Accounts Receivable (Debtors), Prepaid Expenses, Inventory (Stock on Hand), Land, Buildings, Vehicles & Equipment, Investments & Stocks, Accumulated Depreciation and Other Assets
Liability Accounts:
Accounts Payable (Creditors), Credit Cards, Tax Payable, Employment Expenses Payable, Bank Loans,
Stockholders' Equity Accounts:
Common Stock (Share Capital), Retained Earnings (Revenue Reserves), Drawings
Revenue Accounts:
Sales Revenue, Sales Returns & Allowances, Sales Discounts, Interest Income,
Expense Accounts:
Advertising Expense, Bank Fees, Client Expense, Depreciation Expense, Payroll Expense, Payroll Tax Expense, Rent Expense, Income Tax Expense, Office Expense, Utilities Expense


Rules for Debit (DR) and Credit (CR):







Oracle Fixed Asset (FA)



Oracle Fixed Assets (FA) module is one of the Oracle Financials modules and is very flexible package for managing all the fixed asset management for any organization.
Oracle Assets can help enterprises lower administrative costs by streamlining data management.




Transactional Flow from AP > FA>GL







Modules Activities:

Additions:
Depreciation:
Retirement:
Prepaid Services:
Tax Book Maintenance:
Capitalized Leases vs. Operating Leases:
Period-End Process:



For more information please visit http://www.oracle.com/

Tuesday, March 8, 2016

Oracle Accounts Payables and Cash Management Clearing Issue.

Oracle E-Business Suite > Oracle Financial > Oracle Payables & Cash Management 


Issue/ Error : The clearing/reconciliation GL date cannot be earlier than the unclearing/unreconciliation GL date of this payment.





Solution :

This is an intended functionality where system validates whether the clearing/ reconciliation 

GL date is earlier or later than the unclearing/ unreconciliation GL date.

User unreconcile the transaction for example on Mar 7 , 2016 and trying to reconcile the 

same transactions then system will stop the user.

User need to clear the transaction after the date when unreconcile the payment.


   _________________________________________________________

Saturday, March 5, 2016

Oracle Interview Question - Oracle GL

Oracle E-Business Suite > Oracle Financial > Oracle Interview Questions


Oracle Financials Interview Questions – Answers Included




Qns: What is Flex field? What are different types of Flex field?
Ans: Flex field is used to capture information of your Organisations.

Qns: Difference between KFF and DFF.
KFF
Unique identifier
Stored in segment Column
DFF
Is used to capture additional information
Stored in attribute Column

Qns: How many KFF are in GL. AP , AR.
Ans:
Module KFF
GL Accounting FF
AP No KFF
AR Sales tax Location FF
Territory Flexfield.

Qns: What is symbol of DFF in the Forms?
Ans: Square Bracket [ ].

Qns: What is structure of KFF in the Accounting Flexfields.
Ans: Company
Cost center
Account
Product
Future use.

Qns: How many segments are in AFF.
Ans: max 30 segments and min two.

Qns: What are flexfield Qualifiers.
Ans: Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:
a) Balancing Segment Qualifier.
b) Cost Center segment Qualifier.
c) Natural Account Segment Qualifier.
d) Intercompany Segment Qualifier.

Qns: What is Dynamic Insertions?
Ans: u can create Code Combinations at run time.

Qns: In which table Code Cominations id is stored.
Ans: GL_CODE_COMBINATIONS.

Qns: In which table flex values are stored.
Ans: 1. fnd_ flex_Values
2. fnd_ flex_Values_tl

Qns: What is set of Books and in which table set of book is stored.
Ans : Set of Books is a Financial Reporting entity which Consist of three C.
a) Chart Of Accounts
b) Currency
c) Calendar.
Set of Books is stored in GL_SETS_OF_BOOKS

Qns: In which table Currency and Period Type Name are stored.
Currency – FND_CURRENCIES
Period – GL_PERIOD_STATUSES

Qns: In which table Segment Values are stored and concatenated values are stored.
Ans: 1. GL_CODE_COMBINATIONS
2. GL_CODE_COMBINATIONS_KFV.

Qns: What are different types of Currency.
Ans: Functional Currency
Foreign currency.

Qns: What are different types of Calendars .
Ans: Different types of Calendars are listed below
a) Fiscal
b) Accounting

Qns: How will you attach set of Books to the Responsibility?
Ans: through Profile. GL SETS OF Books Name.

Qns: What is Profile and what are different types of Profiles.
Ans: Profile: Profile is the changeable option that affects the way your application runs. There are two types of profile.
1. System defined
2. User defined

Qns: What are different Profiles Level available in oracle apps.
Ans: Below are the Profiles Level available in oracle apps
1. Site(Lowest level)
2. Application
3. Responsibility
4. User.

Qns: Write Name of some Profile options.
Ans:
1. GL Sets of Books Name
2. GL sets of Books id
3. MO:Operating unit (multi org).
4. HR:User type.

Qns: What is cycle of GL.?
Ans: In simple and layman words-
1. Open the period
2. Create Journal Enteries
3. Post the Journals.

Qns: In Which tables Journal entries created.
Ans: Important tables are-
1. Batch: GL_JE_BATCHES
2. Header: GL_JE_HEADERS
3. Lines : GL_JE_LINES

Qns: After Posting data goes in which tables.
Ans: GL_BALANCES.( Column Period_net_cr, period_net_dr).

Qns: What are Important tables in GL.
Ans:
1. GL_JE_BATCHES
2. GL_JE_HEADERS
3. GL_JE_LINES
4. GL_BALANCES
5. GL_SETS_OF_BOOKS
6. GL_CODE_COMBINATIONS
7. GL_PERIOD_STATUES
8. GL_INTERFACE

Qns: In which table Supplier information’s is stored.
Ans: Supplier information can be found in following tables
1. PO_VENDORS
2. PO_VENDOR_SITES_ALL
3. PO_VENDOR_CONTACTS

Qns: What is difference org_id and Organization_id.

Ans: Org_id is for operating unit and organization_id is for inventory organization.




Oracle IRECRIUTMENTS INTERVIEW QUESTIONS

Oracle E-Business Suite > Oracle HRMS > Oracle Interview Questions



1. How to restrict iRecruitment external visitors to access only responsibilities on the external server?

Answer- Set the Server Trust Level for the server to External
- Set the Trust Level of the iRecruitment external responsibilities to External too.

2. Is SSHR a dependency for iRecruitment?

Answer

iRecruitment has no dependence on SSHR (and vice versa).


4. Does iRecruitment support "Candidate Qualifying Questionnaires" where the candidate must answer vacancy-specific questions correctly prior to submitting an application?

Answer

iRecruitment currently does not support this function. For now this can be achieved by having a set of simple questions usingflexfield to get those responses and a user hook to validate them as part of the apply process. .


6. Can we change the default currency on job vacancy details?
Answer

The default currency in iRecruitment is always the default currency of the business group.

7. Do we track vacancy history?

Answer

iRecruitment does not track changes to the vacancy. If changes to a field are to be traced use the Audit capability in APPs.

8. Is there a functionality to capture Time and Date stamps of when Applicant first applied and when documents first uploaded available?

Answer

Currently this functionality is not available. The WHO columns like creation_date, created_by, last_update_date and so on,
which can be used to determine exactly when any record was created are never exposed in the self service tech stack unlike
forms.

10. How do we see the current status of a vacancy submitted for approval?

Answer

The status field allows you to search for vacancies with just one of the many statuses, e.g. Approved. However, a
vacancy is not actually created until it is approved if approvals are turned on.

11. How to repopulate the seeded address types in iRecruitment?

Answer

Re-run the patch that delivers in force apply mode OR the ldt file residing at $PER_TOP/patch/115/import/US.

12. What is the order/hierarchy in which default job posting information comes through in the vacancy?

Answer

If default postings are created at multiple levels then all of the fields will be filled out from the position. If there are
any blank then it will look at the job to see if any of the blanks were specified on the job. If there are any further
blanks, then it will look at organization, and then finally business group.

The order would be as follows:
1. Position
2. Job
3. Organization
4. Business Group

13. How to send postings to external websites (such as Monster/Stepstone etc)?

Answer

Refer to the implementation guide.

14. Why should I re-login to view candiate created via Magnaware in iRecruitment?

Answer

The way that HR security works is that security is cached for a session under some circumstances.This is to improve
performance. That means that under some circumstances a new user will not be visible until re-logging in, and the cache is
refreshed.

15. How do I download an application from from iRecruitment?

Answer

While creating the vacancy include an html link to the application form document in the job posting. The user looking
at the vacancy can just click on the link to download the document.