Vaibhav Suhane's Oracle ERP Financials Tutorial: Oracle Process Manufacturing_SLA_Setup

Vaibhav Suhane's Oracle ERP Financials Tutorial: Oracle Process Manufacturing_SLA_Setup: https://drive.google.com/open?id=0BxXH0KHEXdmiLU12LUh2M1FQb0E

Oracle Process Manufacturing_SLA_Setup

https://drive.google.com/open?id=0BxXH0KHEXdmiLU12LUh2M1FQb0E

Oracle Process Manufacturing Period Close Process

How To Close Period Actual cost.

Step1:

Run Preliminary Inventory Close Period:

Run the GMF Period Close Process for Process Organizations program with Final Close= No. It’s then a preliminary close period, i.e. the period is closed to transactions, but may still be reopened.

OPM Financials > Reports > Standard > Run > GMF Period Close Process for Process Org.

Step-2.

Run Actual Cost Process:

The period in the cost calendar must be in either Open or Frozen status to run the Actual Cost Process. If the period has the status Closed it can’t be selected anymore.Error(s) from this process can be checked in Action Menu > View Error Messages.

 OPM Financials > Actual Cost > Actual Cost Process

Step-3.

Run Preliminary Cost Update Process:

Launch the Cost Update process. At this stage, it is still recommended to avoid the Final Update option. This to allow to be able to review and change component costs if necessary, and also to run another cost update.

OPM Financials > Cost Update

Step-4.

Run OPM Accounting Preprocessor:

The OPM Accounting Preprocessor creates the events in SLA tables.

OPM Financials > Reports > Standard > Run > OPM Accounting Pre-Processor 

 

Step-5.

Run SLA Create Accounting Process in Draft mode:

Run the Create Accounting program in Draft Mode. The Draft Mode allows accounting distributions to be amended in SLA (if required).

OPM Financials > Reports > Standard > Run > Create Accounting 

Step-6.

Review Journal Entries:

As soon as all accounting entries are correct, this step can be skipped.

OPM Financials > Cost Update Menu: Action > View Error Message

Run Final Inventory Close Process:

Step-7.

Run the GMF Period Close Process for Process Organizations program with Final Close= Yes. The period will then be definitively closed to any transaction and it will beimpossible to reopen it.

OPM Financials > Reports > Standard > Run > GMF Period Close Process for Process Organizations

Step-8.

Run Final Cost Update Process:

Launch the Cost Update process. Specify that the update is final (by ticking the Final Update check box); this locks the raw material costs for the specified period. The period in the cost calendar will be at the status Frozen. You can then export these costs to the proper General Ledger accounts.

OPM Financials > Cost Update

Step-9.

Run OPM Accounting Preprocessor

OPM Accounting Preprocessor creates events in SLA tables.

OPM Financials > Reports > Standard > Run > OPM Accounting Pre-Processor 

 

Step-10.

Create Accounting and Export to GL

Run the Create Accounting program in Final Mode. When choosing the Final Mode,there is also the option to directly Post to General Ledger.With the 'Post in General Ledger' option= Yes, the Create Accounting process will transfer to General Ledger the only Journals created during that particular run.Thus, if 'Post in General Ledger' option = No, then the concurrent request 'Transfer to GL' needs to be ran to transfer the SLA journals to General Ledger in previous Create Accounting runs.

OPM Financials > Reports > Standard > Run > Create Accounting 

Accounts Receivable Discount Line SLA Setup

https://drive.google.com/open?id=0BxXH0KHEXdmibFF3bi1SRzRjbHM

Payables Invoice Approval AME Setup User Manual

Introduction

---

Payable Invoice Approval is a workflow process that enables you to automate the approval process. It helps in customizing and setting approval methodology based on Approver, Sequence of approval, and Criteria for approval.

AME is a framework of well-defined approval rules constructed using the following 5 component for a given:

•    Transaction Type

•    Attributes

•    Conditions

•    Actions

•    Approver Groups

•    Rules

Process Activity

---

Log in into SYSADMIN User:

 •    Select “User Management” Responsibility and select “Users” function. Give the user name and click on “Go”.

•    Click on “Update” symbol.  Click on “Assign Role” option and assign “Approvals Management Administrator”, “Approvals Management Business Analyst”, “AME Application Administrator” Responsibilities.

•    Click on Functional Administrator Responsibility. 

•    Click on “Create Grant” option.

•    Give the Name, Description, give the Specific User Name, and select the “Object” as “AME Transaction Types” click on “Next”.

•    Click on “Next” button and give “Set” as “AME Calling Applications”  and click on “Next” and “Finish” it.

•    Now Log in with User ID.

•    Select “Approvals Management Business Analyst” Responsibility.

•    Select “Business Analyst Dashboard” function.

•    Select the “Transaction Type” as “Payables Invoice Approval”.

 Define Attributes

---

FLOWS: Define Attribute-> Define Conditions-> Action Types-> Approver Groups

•    Click on “Setup” option and search with “Supplier Invoice Amount”.

•    Click on “Update” symbol.

•    Give the SQL script in “Value” field as per the requirement. By default the Value field would be there.

•    Now “Validate” it.

•    Search with “Supplier Invoice Distribution Cost Center” Attribute Name.

Click on “Update” symbol.

•    Give the SQL script in “Value” field as per the requirement. By default the Value field would be there.

•    Now Validate it.

•    Search with “Supplier Invoice Type Lookup Code” Attribute Name.

•    Click on “Update” symbol.

•    Give the SQL script in “Value” field as per the requirement. By default the Value field would be there.

•    Now Validate it.

 Define Conditions

---

•    Select “Condition” option under the Setup to define Conditions for the Approval.

•    Click on “Create” Option for defining Condition.  Select the “Condition Type” as “Ordinary” and “Attribute” as “SUPPLIER_INVOICE_AMOUNT”

•    Select the “Currency” as “NGN” and enter the Condition for “Supplier_Invoice_Amount” as “Is greater than or equal to” (-9999999999999) and “and less than or equal to” (999999999999999).

NOTE:  We can also define Conditions for “Supplier Invoice Distribution cost center value” Attribute if needed.

Action Type

---

•    Click on “Action Type” option under Setup (Payables Invoice Approval) .We can use the Existing “Action Type”.

Define Approver Group

---

•    Click on “Approver Group” option to define Approval Hierarchy inside the Setup (Payable Invoice Approval).

•    Click on “Create” option.

  

Define Rules

---

•    Define “Rules” for Invoice Approval. Click on “Rules” option under “Invoice Approval”.

•    Click on “Create” button.

•    Enter the Rule Name as “Invoice approval For AP”. Click on “Next”.

•    Click on “Add condition” option to add the defined Conditions for the approval.

•    Click on “Next” button. Give the “Action” for the Action Type “approval-group chain of authority”.

•    Click on “Next” button.

•    Click on “Finish” button to complete it. 

Oracle Property Manager

Introduction Oracle Property Manager :->

Oracle Property Manager is part of the Oracle Real Estate Management solution. You can use Oracle Property Manager to manage your properties. Oracle Property Manager provides you with tools to organize the information you use to manage major real estate tasks.

Oracle Property Manager includes the following scenarios to organize the information you use to manage major real estate tasks:

•  Lease Management
• Space Management
•  Workflow Automation
•  Integration
•  Reporting
•  Inquiry

Lease Management

Lease management is at the center of the real estate management function. With Oracle you can control and oversee a variety of lease management tasks such as:

•  Abstracting basic lease information from lease documents.
•  Modifying and amending leases.
•  Calculating lease amounts.
•  Creating invoice schedules.
•  Exporting invoices to Oracle Payables and Oracle Receivables.

Property Portfolio Management

You can use Oracle Property Manager to identify, define, and manage owned and leased property, keep records of physical features and facilities, and maintain comprehensive records of property-related data such as:

• Geographical location
•  Tenure
•  Condition of property
•  Parties involved
•  Type

Space Management

Property Manager makes it easy to allocate space in leased and owned locations. You can specify detail for the following spaces:

• Regions and office parks
• Buildings
• Floors
• Offices

ASSIGNMENTS

Properties can be assigned to either employees or customers at any of the levels described above. With each of these assignments cost centers or GL codes can be associated for revenue or costing purposes. The facility to record Project/Task/Organization data has also been provided. The system provides statistical information on the assignments and total occupancy at the building, floor and office levels. Query screens are provided to enquire on the assignment data at each of the levels.

Workflow Automation

During the life of the lease, certain events often require action by your Company in a timely manner. With Property Manager you can identify those specific events and schedule the appropriate employee action.

Event Notification

Property Manager includes a Milestone feature, with which you can create milestones for key lease events, such as:

• Lease and option expiration dates
•  Insurance payment and renewal requirements
•  Payment expirations

Integration Oracle Applications

Oracle Property Manager is integrated with other Oracle applications, Including:

• Oracle General Ledger
•  Oracle Payables
•  Oracle Receivables
•  Oracle Human Resources

Standard Reporting

Property Manager provides a set of inquiry windows and standard reports. You can produce standard reports to review:

•  Lease provisions
•  Rent schedules
•  Milestone analysis
•  Cash flow
•  Space allocation and utilization

Online Inquiry

Online inquiry screens provide you with instant access to critical information:

•  Lease provisions
• Lease amendments and edits
•  Service provider information
•  Transaction history
•  Payment and billing information
•  Location configurations and usage
•  Rentable, usable, and vacant area
•  Optimal and maximum capacity
•  Employee space assignments

Oracle General Ledger User Transaction Manual

https://drive.google.com/open?id=0BxXH0KHEXdmidXB4cGhDVU96aDg

Accounting Methods Builder (AMB) Overview

Accounting Methods Builder (AMB) Overview:

The Financial Accounting Hub (FAH) is based on Subledger Accounting concept. It works on Transactional basis. To setup Financial Accounting Hub for a specific custom Application the Accounting Methods Builder (AMB) must be setup.

The AMB enables you to create and modify subledger journal line setups and application accounting definitions. These definitions define the journal entries that enable an organization to meet specific fiscal, regulatory, and analytical requirements. These definitions are then grouped into subledger accounting methods and assigned collectively to a ledger.

Oracle Applications development provides startup application accounting definitions and at least one subledger accounting method for all products using Oracle Subledger Accounting. If users do not have any special accounting requirements, these start up definitions may meet their needs and the only required setup step is to assign subledger accounting methods to the ledger.

If users have specific accounting requirements that are not met by the start-up definitions, they can copy and modify the seeded definitions or create new definitions.

The Components for Building Accounting Definitions figure below shows the components in the Accounting Methods Builder process for building accounting definitions. 

Define Journal Line Types**

Define Journal Entry Descriptions

Define Mapping Sets

Define Account Derivation Rules**

Define Supporting References

Define Journal Line Definitions**

Define Application accounting Definitions**

Define Subledger Accounting Methods**

Financial Accounting Hub Process

The Data Fetching Process includes three major processes. These three major processes are both custom and standard programs that would be Auto Scheduled for each Custom Source. These are:

1. Data Upload to Financial Accounting Hub Program

• Event Creation Program
• Subledger Accounting Program
•  

The first two programs would be different for all the Sources which would be used in the same data fetching process. The Data Upload program will fetch the balanced data through Data Base Link and keep it in the staging environment from where system will validate the fetched data and place it in the Custom Transaction Tables.

Validation process includes data validation in which system check whether fetched data is balanced or not, the period for which system is fetching the data is in opened status or not in General Ledger, the Currency is enable, uploaded in value set and mapped in Financial Accounting Hub and in Oracle General Ledger or not for which system is fetching the data and so on.

Once validation process completes successfully system completes first program successfully i.e. Data Upload to Financial Accounting Hub Program.

The second program i.e. Event Creation Program which uses Standard API to create Event and generate Event ID for all fetched line. Once it is completed successfully system will allow importing fetched balanced data into Oracle General Ledger through Financial Accounting Hub for the particular Source that would be achieved with the help of Subledger Accounting Program.

The “Subledger Accounting Program” creates Journal Entries for each fetched lines first as per the defined FAH setup and then importing program transfers all the created Journal Entries into Oracle General Ledger automatically.

The “Subledger Accounting Program” calls four more major Programs while running. These Programs are:

·                  Create Accounting

·                  Accounting Program

·                  Import Journal

·                  Subledger Accounting Balances Update

All these programs run consequently. The “Create Accounting” program creates the Accounting for each fetched line as per the defined Application Accounting Definition in the Financial Accounting Hub Setup through “Accounting Program”. Once Accountings are created for all the fetched line system imports the Journal Entries with the help of “Import Journal” program and then updates the accounts balances through “Subledger Accounting Balances Update program”.

The Financial Accounting Hub (FAH) is based on Subledger Accounting concept. It works on Transactional basis. For each fetched line the GL Account must be either debited or credited. If one side is debited for one GL Account system will automatically take the other side as credited for other GL Account that would be applicable for fetched Transactional Data (Transaction basis).

If system is not fetching Transactional basis balanced data(Line level account is not available for corresponding Header Level Account) in this case system will automatically balance each line by placing other line(whether debited or credited) having imaginary Account Code Combination for Line level Account because Oracle FAH works on the basis of Transaction.

Oracle General Ledger Introduction

Oracle General Ledger is a comprehensive financial management solution that dramatically enhances financial controls, data collection, information access, and financial reporting throughout the organization. Oracle General Ledger provides tremendous flexibility for managing and streamlining the accounting processes with an extremely versatile chart of accounts, accounting calendar and is the central repository of accounting information, receiving transactions from both Oracle and non-Oracle sub-ledgers. Non-Oracle sub-ledgers i.e. Legacy systems can also be integrated with Oracle General Ledger with the help of Financial Accounting Hub and the data can be fetched and imported into Oracle General Ledger from the defined Custom Sources.

There are numerous functions available within the Oracle General Ledger to meet the business needs of different types of organizations.

The main purposes of Oracle General Ledger (GL) module is:

• to integrate and maintain all of the Organization’s financial information including that of other Oracle modules
• to administer all organizations legal reporting to outside entities
• to inquire, report  and distribute ad hoc reports on organization’s financial information
• to provide a complete audit trail.