Sunday, 19 May 2019

Complete Order 2 Cash (O2C) Cycle in Oracle Apps R12

Complete Order 2 Cash (O2C) Cycle in Oracle Apps R12

Publisher KUNCHAM Software Solutions Pvt Ltd
Course Length : 1.5 hour
Course Price : $150
Course Language English


Description

Order to Cash Cycle
The Order to Cash Process flow starts with entering the order with a standard item into system. When you enter an order, the item are validated in oracle inventory, the price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved. Once all the required fields are entered on both the header and the lines, you can book the order. When you click on the Book Order button, the API OEXUBOKB.pls, checks if the order is eligible for booking. If eligible the order is booked and the order header status would change to booked. The next step is the pick release with which you move the items from the warehouse to the staging area. The next step is to ship confirm, to indicate that the items are loaded on to the carrier from the staging area. When you run Ship Confirm, the system decrements inventory and updates sales order line status. This information is then transferred through the Auto Invoice to Account Receivables for invoicing. Then you sent the invoice to your customer for the items shipped and then perform the cash management and bank reconciliations.
Following are the steps the process will go through from creating a Sales Order to Posting the details in GL.
  • Enter the Sales Order
  • Book the Sales Order
  • Launch Pick Release
  • Ship Confirm
  • Create Invoice
  • Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation)
  • Transfer to General Ledger
  • Journal Import
  • Posting
Involved Modules in Order to Cash
Order Management: Creating and shipping the Order
Inventory:  Onhand availability, Reservation
Receivables: For Receipt against invoice
General Ledger: Importing, entering and posting the journals.



Purchase Orders (PO) Creation in Oracle Apps R12

Purchase Orders (PO) Creation in Oracle Apps R12

Publisher KUNCHAM Software Solutions Pvt Ltd
Course Length : 2.5 hour
Course Price : $50
Course Language English


Description

Purchase Orders Types in Oracle R12
Oracle Purchasing supports four types of purchase orders:
Standard Purchase Orders:
You generally create standard purchase orders for one-time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions.
Blanket Purchase Agreements:
You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not yet know the detail of your delivery schedules. In this case you create and use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them.
Contract Purchase Agreements:
You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standard purchase orders referencing your contract.
Planned Purchase Order:
You create a planned purchase order when you want to establish a long term agreement with a single source supplier with a commitment to buy goods or services. Planned purchase orders include tentative delivery schedules and accounting distributions.



Learn Complete Oracle 11g Developer Training For Beginners

Learn Complete Oracle 11g Developer Training For Beginners

Publisher KUNCHAM Software Solutions Pvt Ltd
Course Length : 27.5 hour
Course Price : $90
Course Language English


Description

About SQL:
SQL is used to interact with Database Systems. As per ANSI (American National Standards Institute), SQL is the standard language for Relational Database Management Systems.
SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.



Sunday, 12 May 2019

The Ultimate Oracle SQL Course: Beginner to Advanced!

The Ultimate Oracle SQL Course: Beginner to Advanced!

Publisher Zone Cotex - Leo Z
Course Length : 3.5 hour
Course Price : $0
Course Language English


Description

Welcome to this course. In this course we will assume that you are a beginner and by the end of the course you will be advanced. You will learn everything that you need to know using this complete course. We will guide you step by step. This course contain hands on practical example that will allow you to use your skills in Real-World.

Join Us & Get the opportunity to become an expert!




The Complete Oracle SQL Course: Beginner to Advanced!

The Complete Oracle SQL Course: Beginner to Advanced!

Publisher Zone Cotex - Leo Z
Course Length : 3.5 hour
Course Price : $0
Course Language English


Description

Welcome to this course. In this course we will assume that you are a beginner and by the end of the course you will be advanced. You will learn everything that you need to know using this complete course. We will guide you step by step. This course contain hands on practical example that will allow you to use your skills in Real-World.

Join Us & Get the opportunity to become an expert!




The Complete Oracle SQL Course - Learn From Scratch

The Complete Oracle SQL Course - Learn From Scratch

Publisher Zone Cotex - Leo Z
Course Length : 3 hour
Course Price : $0
Course Language English


Description

Welcome to this course. In this course we will assume that you are a beginner and by the end of the course you will be advanced. You will learn everything that you need to know using this complete course. We will guide you step by step. This course contain hands on practical example that will allow you to use your skills in Real-World.

Join Us & Get the opportunity to become an expert!




The Complete Oracle SQL Masterclass: Beginner to Advanced!

The Complete Oracle SQL Masterclass: Beginner to Advanced!

Publisher Zone Cotex - Leo Z
Course Length : 3 hour
Course Price : $0
Course Language English


Description

Welcome to this course. In this course we will assume that you are a beginner and by the end of the course you will be advanced. You will learn everything that you need to know using this complete course. We will guide you step by step. This course contain hands on practical example that will allow you to use your skills in Real-World.

Join Us & Get the opportunity to become an expert!