Ranganath's Oracle Apps

Application Implementation Methodology :- -------------------------------------------------- Application Implementation Methodology in short referred as AIM. AIM- Oracle’s Application Implementation Methodology is a proven approach to implement Oracle Applications. AIM defines an organization’s business needs at the beginning of the project and maintains their visibility through out the implementation AIM Phases-AIM project is conducted in phases. The phases provide quality and control checkpoints to coordinate project activities that have a common goal. The phases are 1)  Definition - During this phase, we plan the project ,review the organization’s business objectives ,understand the business processes and evaluate the feasibility of meeting those objectives under time, resources and budget constraints. The emphasis is on building an achievable work plan and introducing guidelines on how the organization will work to achieve the objectives.To achieve an early underst...

1)At what stage an order cannot be cancelled? If the order is Pick Confirmed, it cannot be cancelled. 2) What are the Process Constraints? Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems 3)What is a Pick Slip Report?  Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order. 4)When the order import program is run it validates and the errors occurred can be seen in? Order Management Responsibility >Orders, Returns : Import Orders> Corrections 5)How is move order generated? When the order is pick released 6)What are primary and secondary price lists? Price list contains information on items and its prices. The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order. What is...

1.CANCELLED PO ’S SELECT PHA . SEGMENT1 ,          PHA . CREATION_DATE ,          PLA . CANCEL_DATE ,          PLA . CANCEL_REASON ,          PLA . ITEM_DESCRIPTION ,          HRL . LOCATION_CODE ,          FU . USER_NAME ,          DECODE ( PHA . CANCEL_FLAG , 'Y' , ’CANCELLED’) STATUS FROM PO_HEADERS_ALL PHA , PO_LINES_ALL PLA , HR_LOCATIONS HRL , FND_USER FU          WHERE PHA . PO_HEADER_ID = PLA . PO_HEADER_ID          AND HRL . LOCATION_ID = PHA . SHIP_TO_LOCATION_ID          AND PHA . CREATED_BY = FU . USER_ID          AND PHA . CANCEL_FLAG = 'Y' 2.PENDING PO ’S SELECT    PHA...