Oracle EBS Application

  1.        Create Invoices           2 .        Go to Payments Manager  Navigation           Create Template or Submit a new request                Submit a Payment Process Request Enter Payment Attributes .   Submit then status show – Invoice Pending Review Click on the Start Action to review the selected invoices Select the invoices for payment then submit Status after review invoices calculating Special Amounts Status changed to Pending Proposed Payment Review then Formatting After Formatting – Formatted- Ready For Printing      Submit for Printing       Confirmed Payments

  1). Login as System Administrator user and then switch responsibility to User Management. 2). Click in Roles & Role Inheritance 3). Do the following search: – Type: Role and Responsibilities – Category: Miscellaneous – Application: Cash Management Choose the Cash Management responsibility where you want to create and maintain bank accounts. 4). Click on the Update icon 5). Click in Security Wizard button 6). Run the Wizard for CE UMX Security wizard.       7). Click on Add Legal entities and add the legal entity you will give to the Selected role access to all bank accounts within this legal entity choose grants that you want to assign to this role on the bank accounts of this legal entity (Use, Maintenance, Bank Account Transfers)         8). Click in the Apply button and then click in the save button.

 PO Tables in oracle R12 PO_HEADERS_ALL PO_LINES_ALL PO_DISTRIBUTIONS_ALL PO_LINE_LOCATIONS_ALL PO_REQUISITION_HEADERS_ALL PO_REQUISITION_LINES_ALL PO_REQ_DISTRIBUTIONS_ALL PO_VENDORS PO_VENDOR_SITES_ALL    PO_VENDOR_CONTACTS PO_RELEASES_ALL RCV_SHIPMENT_HEADERS RCV_SHIPMENT_LINES RCV_TRANSACTIONS

 RMA Process You can return items (back from the customer) into inventory through an RMA. For example, you can back an item that was returned by the customer to you for repair or replacement. Enter the reference type as “Sales Order” in Returns tab Save the details. Once the Order is Booked, the Line status change to Awaiting Return. Now take Receipt against above RMA System will generate the Receipt Number Now go to the order & check the status. It is Closed now.  Switch to AR Super User Responsibility and run Autoinvoice Master Program for RMA Credit Memo.

 Min-Max Planning You can use min-max planning to maintain inventory levels for all your items or selected items. With min-max planning, you specify minimum and maximum inventory levels for your items. When the inventory level for an item drops below the minimum, Oracle Inventory suggests a new requisition or job to bring the balance back up to the maximum. MIN-MAX planning can be done on the Sub-inventory level or Organisation level. Create an Item with attributes as Inventory Panning Method as Min-Max Run Min-Max Planning Navigation à Inventory Super User à Planning à MIN-MAX Planning   Output of MIN-MAX planning report Run Requisition Import

 Back 2 Back Order Process ·          This order type applies when a customer orders a product that you do not stock or manufacture. ·          In turn customer places the order, you place the order with the supplier and after the shipment from the supplier, you distribute the product to the customer.   Below is the flow chart for the B2B process flow: B2B Setups Item Creation with Below Attribute for B2B 1. General Planning à Item must be Buy  2. Order Management à Default SO Source Type - Internal Back-to-Back Process 1. Enter Sales order & Book 2. Progress Order – Create Supply Order- Eligible 3. Requisition Import 4. Auto-create PO 5. Receipt Launch Pick Release/ Shipping