Wednesday, 24 August 2016
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
Monday, 22 August 2016
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
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:
•
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”.
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.
•
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.
•
Click
on “Action Type” option under Setup (Payables Invoice Approval) .We can use the
Existing “Action Type”.
•
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
Sunday, 21 August 2016
Oracle General Ledger User Transaction Manual
https://drive.google.com/open?id=0BxXH0KHEXdmidXB4cGhDVU96aDg
Subscribe to:
Comments (Atom)