Tuesday 29 November 2016

Overview of Oracle Yard Management - Yard Management System

Yard Management System Will help in Sorting out the Warehouse, Distribution Centre into Various Storage Locations, Dock Doors and parking Spaces. 

Further Yard Management System Will Help to Streamline yard operation with real time data of yard equipments and their movement.


Oracle Yard Management, a software product within the E-Business Suite, provides many advantages to help a company maximize the inventory flow in the yard of your manufacturing facility, warehouse, or distribution center.

Using Oracle Yard Management, we can define the entities required for yard operations and capture the transactions happening within the yard in real-time. 

A yard, by default, is an extension of the warehouse, and therefore plays a pivotal role in inventory management. Oracle Yard Management provides visibility into inventory in the yard and the equipment checking into and out of the yard for both inbound and outbound operations. 
  
Benefits of Oracle Yard Management:

1.Oracle Yard Management provides real-time location and status information about trailers, parking slots, and dock doors.

2.Oracle Yard Management enables Warehouse supervisor to manage yard transactions like yard check-ins, check-outs, sealing and unsealing operations, and trailer movements in the yard.   

3.Manage and send alerts/notifications during yard warehouse operations for check-in and yard move events.

4.Schedule and maintain appointments for incoming and outgoing trailers. 

5.Supports shipping and receiving material from the warehouses through the yard. 

6.Ensures liability tracking by supporting cost and general ledger (GL) accounting for the trailer and its contents.

7.Visibility into Yard Inventory

   

Thursday 24 November 2016

SQL QUERY FOR EXTRACTING SERVICE BUSINESS PROCESS ORACLE R12

SELECT NAME            AS NAME,
  DESCRIPTION          AS DESCRIPTION,
  START_DATE_ACTIVE    AS START_DATE,
  END_DATE_ACTIVE      AS END_DATE,
  DEPOT_REPAIR_FLAG    AS DEPOT_REPAIR,
  FIELD_SERVICE_FLAG   AS FIELD_SERVICE,
  SERVICE_REQUEST_FLAG AS SERVICE_REQUEST
FROM CS_BUSINESS_PROCESSES;
 
SELECT CBP.NAME          AS NAME,
  CTT.NAME               AS SERVICE_ACTIVITY,
  CBPT.START_DATE_ACTIVE AS START_DATE,
  CBP.END_DATE_ACTIVE    AS END_DATE
FROM CS_BUS_PROCESS_TXNS CBPT,
  CS_TRANSACTION_TYPES CTT,
  CS_BUSINESS_PROCESSES CBP
WHERE CBP.BUSINESS_PROCESS_ID = CBPT.BUSINESS_PROCESS_ID
AND CBPT.TRANSACTION_TYPE_ID  = CTT.TRANSACTION_TYPE_ID

Tuesday 15 November 2016

Design and Implementation Approach for GST By Oracle India for India Localization



   Oracle Has Started development work for India GST and has been Phased as Follow.

Phase 1 :EBS GST Infrastructure : This has been Stated as Coding and Testing Phase by Oracle India which is Under Progress

Phase 2: EBS GST Model Law and Transistion Capabilities: These are the Enhancement Based on Daft Model Law GST India

Phase 3:Final GST Requirements. If Any Amendments made on Draft Model GST Law, the Final Requirements Will be Taken in this Phase.

Early Access of Update.

  Oracle Has planned for Rollout Updates on Phased Manner and Early Access for Limited Partners and Customers.

These Updates are Provide With a View to enable customer and Partners learn new software and prepare projects for Implementation.

The Early Access Software is Intended only for Testing Purpose in Dev Instances and Not for Production Environment.

For Further Details for Requirement to Early Access Please Refer My Oracle Support Doc ID 2176820.2