Wednesday, November 9, 2011

Did you knew changes in Oracle Purchasing with Release 12 ?

Changes to existing tables

PO_HEADERS_ALL
  1. Added columns (SUPPLIER_NOTIF_METHOD, FAX, EMAIL_ADDRESS) for capturing the Communication Details specified for a PO on the Create/Update Order page
  2. Added the STYLE_ID column for capturing the style of each document
  3. Added new columns: created_language cpa_reference last_updated_program
  4. Added column SUBMIT_DATE to record the date when purchase order is submitted for approval
PO_LINES_ALL
  1.   Added new columns: catalog_name supplier_part_auxid ip_category_id last_updated_program
  2. Addition of the following Columns :
  • RETAINAGE_RATE(Rate to withhold retainage from progress payments) 
  • MAX_RETAINAGE_AMOUNT (The maximum amount that can be held as retainage against a contract)
  • PROGRESS_PAYMENT_RATE(% of work completed which is eligible to be paid, when using financing)
  • RECOUPMENT_RATE (This % is applied to the invoice amount to determine the total amount of previously paid financing payments that can be applied towards this invoice to determine the current amount due)

Please enter your email address to subscribe

You won't repent doing this!
Email: