Oracle Apps 4u
  • Home
  • About Us
  • Services
    • Consulting
    • Training
    • On Job Support
    • Sample Projects
  • Courses
    • Oracle Apps Technical
    • Oracle DBA
    • Oracle Apps SCM – PO & OM
  • Downloads
  • Interview
    • Interview Questions
    • Assessment Quiz
    • Resume Services
  • Tools
  • Blog
  • Contact

Oracle Apps Purchase Requisition – technical

Posted on April 17, 2014 by admin Posted in Blog

Responsibility: Purchasing, Vision Operations (USA) -> Requisitions -> Requisitions

Key Tables:

•       po_requisition_headers
•       po_requisition_lines
•       po_req_distributions

Main DFFs:
•       Requisition Headers
•       Requisition Lines
•       Requisition Distributions
•       Requisition Project Information
po_requisition_headers_all: stores information about requisition headers
Few Main Columns:
•       Requisition_header_id : Unique system generated Id for requisition headers
•       Segment1: Stores the requisition #
•       Type_lookup_code: purchase/internal based on the type of requisition
•       Authorization_status: approved/incomplete etc. based on the status of requisition
•       wf_item_type = Stores the approval workflow corresponding to the requisition. For e.g. REQAPPRV
•       wf_item_key =  <workflow item key>
po_requisition_lines_all: stores information about requisition lines
Few Main Columns:
•       Requisition_line_id : Unique system generated Id for requisition lines
•       Requisition_header_id :  Foreign key from the po_requisition_teaders table
•       Line_num: Stores the requisition line #
•       Item_id: Store item id linking to inventory_item_id from mtl_system_items_b table
•       Line_location_id: purchase order shipment line identifier. Foreign key from po_line_locations table. This column will be null if PO is still not created for this Requisition.
•       Blanket_po_header_id: Stores suggested blanket  purchase agreement detail
•       Blanket_po_line_num: Stores suggested blanket  purchase agreement detail
po_req_distributions: stores information about the accounting distributions associated with each requisition line
Few Main Columns:
•       Distribution_id : Unique system generated Id for requisition distributions
•       Requisition_line_id : Foreign key from the po_requisition_lines table
•       Code_combination_id: Distribution charge account id
•       Accrual_account_id: Distribution accrual account id
•       Variance_account_id: Distribution variance account id
Requisitions related workflows:
•       Approval workflow:  PO Requisition Approval, Process: Main Requisition Approval
•       Account generator workflow: PO Requisition Account Generator, Process: Generate Default Account
« R12 Enhancements in Oracle Purchasing
Oracle Purchasing AME Tables and APIs »

Recent Posts

  • Oracle Quizz
  • How to invoke a calendar in a form
  • Oracle DBA Resume
  • JAVA Quizz
  • DBA Quizz

Categories

  • Blog
  • Quizz

Courses List

  • Oracle Apps Technical support
  • ORACLE DBA
  • Oracle SCM – PO & OM

About Us

Oracleapps4u.net is a global provider of oracle application consulting services. We are passionate about helping our clients to adapt and grow in a changing world of technology by focusing on innovation, quality, process, workforce development and re-usable solutions.

Services

Assurance Services BI & Performance Management Business Process Services Consulting Digital Enterprise Enterprise Solutions IT Infrastructure Services IT Services Platform Solutions Supply Chain Management

Events

Enterprise Security & Risk Management Enterprise Solutions iON Small and Medium Business IT Infrastructure Services IT Services Platform Solutions Supply Chain Management

Contact Us

Oracleapps4u.net
ASA Technologies,
Raheja Mindspace IT Park,
Hitech City, Hyderabad.

Phone No: +91-9885101475
Email: info@oracleapps4u.net

CyberChimps WordPress Themes

Copyright © 2015 Oracleapps4u.net