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)

1 comment:

Please enter your email address to subscribe

You won't repent doing this!
Email: