Tuesday, 22 November 2016

EBS Payables Invoice Functionality Information and Package Versions in Each Stage



EBS Payables Invoice Functionality Information and Package Versions in Each Stage 
 1) Packages involved in Invoices Processing and latest available versions
 Invoice Header
 Invoice Lines
 Invoice Distributions
 Invoice Validation
 Tax Calculation
 Prepayment Application
 Invoices Matching
 Invoice Cancellation
 Mass Additions
 Withholding Tax Calculation (AWT lines)
 Invoices Import
 Invoices Accounting
 Suppliers
 2) Script to know the versions of packages installed on your instance
 
References

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
Invoices Entry form - APXINWKB


Purpose

The goal of this note is to identify the main packages involved in the invoice creation process, and the main invoices features and other processes.

NOTE:  Many of the patches listed below will require a password to access.  In that case, file a new Service Request with Oracle Support requesting the password.

Details


1) Packages involved in Invoices Processing and latest available versions


Invoice Header

   AP_INVOICES_PKG
   AP_INVOICES_UTILITY_PKG
   AP_UTILITIES_PKG		AP_INVOICES_PKG
**For OA release 12.0.X:
       apiinceb.pls 120.47.12000000.27 - Patch:20304417:R12.AP.A
**For OA release 12.1.X:
       apiinceb.pls 120.49.12010000.26 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apiinceb.pls 120.62.12020000.9 - Patch:21066680:R12.AP.C
AP_INVOICES_UTILITY_PKG
**For OA release 12.0.X:
       apinvutb.pls 120.44.12000000.52 - Patch:21907761:R12.AP.A
**For OA release 12.1.X:
       apinvutb.pls 120.56.12010000.40 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apinvutb.pls 120.79.12020000.16 - Patch:21907761:R12.AP.C
AP_UTILITIES_PKG
**For OA release 12.0.X:
       aputilsb.pls 120.29.12000000.31 - Patch:22620659:R12.AP.A
**For OA release 12.1.X:
       aputilsb.pls 120.30.12010000.32 - Patch:20950781:R12.AP.B
**For OA release 12.2.X:
       aputilsb.pls 120.51.12020000.16 - Patch:20950781:R12.AP.C

Invoice Lines

   AP_INVOICE_LINES_PKG
   AP_INVOICE_LINES_UTILITY_PKG		AP_INVOICE_LINES_PKG
**For OA release 12.0.X:
       apinlinb.pls 120.56.12000000.75 - Patch:22084404:R12.AP.A
**For OA release 12.1.X:
       apinlinb.pls 120.64.12010000.65 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apinlinb.pls 120.109.12020000.18 - Patch:20050545:R12.AP.C
AP_INVOICE_LINES_UTILITY_PKG
**For OA release 12.0.X:
       apilnutb.pls 120.28.12000000.23 - Patch:15935245:R12.AP.A
**For OA release 12.1.X:
       apilnutb.pls 120.31.12010000.19 - Patch:22647459:R12.AP.B
**For OA release 12.2.X:
       apilnutb.pls 120.48.12020000.5 - Patch:22647459:R12.AP.C

Invoice Distributions

   AP_INVOICE_DISTRIBUTIONS_PKG		AP_INVOICE_DISTRIBUTIONS_PKG
**For OA release 12.0.X:
       apiindib.pls 120.59.12000000.81 - Patch:20725445:R12.AP.A
**For OA release 12.1.X:
       apiindib.pls 120.68.12010000.75 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apiindib.pls 120.112.12020000.25 - Patch:21230381:R12.AP.C

Invoice Validation

   AP_APPROVAL_PKG
   AP_APPROVAL_MATCHED_PKG
   AP_HOLDS_PKG
   AP_FUNDS_CONTROL_PKG		AP_APPROVAL_PKG
**For OA release 12.0.X:
       apaprvlb.pls 120.94.12000000.169 - Patch:20725445:R12.AP.A
**For OA release 12.1.X:
       apaprvlb.pls 120.140.12010000.149 - Patch:20886955:R12.AP.B
**For OA release 12.2.X:
       apaprvlb.pls 120.231.12020000.46 - Patch:20886955:R12.AP.C
AP_APPROVAL_MATCHED_PKG
**For OA release 12.0.X:
       aprmtchb.pls 120.42.12000000.65 - Patch:22042663:R12.AP.A
**For OA release 12.1.X:
       aprmtchb.pls 120.43.12010000.55 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       aprmtchb.pls 120.84.12020000.20 - Patch:22590844:R12.AP.C

AP_HOLDS_PKG
**For OA release 12.0.X:
       apiholdb.pls 120.9.12000000.7 - Patch:12747896:R12.AP.A
**For OA release 12.1.X:
       apiholdb.pls 120.10.12010000.10 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apiholdb.pls 120.15.12020000.5 - Patch:21230381:R12.AP.C
AP_FUNDS_CONTROL_PKG
**For OA release 12.0.X:
       aprfundb.pls 120.40.12000000.27 - Patch:20463677:R12.AP.A
**For OA release 12.1.X:
       aprfundb.pls 120.44.12010000.22 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       aprfundb.pls 120.58.12020000.6 - Patch: 20463677:R12.AP.C

Tax Calculation

   AP_ETAX_PKG
   AP_ETAX_SERVICES_PKG
   AP_ETAX_UTILITY_PKG		AP_ETAX_PKG
**For OA release 12.0.X:
       apetaxpb.pls 120.15.12000000.3 - Patch:22857256:R12.AP.A
**For OA release 12.1.X:
       apetaxpb.pls 120.15.12010000.3 - Patch:22962891:R12.AP.B
**For OA release 12.2.X:
       apetaxpb.pls [No patch available yet]
AP_ETAX_SERVICES_PKG
**For OA release 12.0.X:
       apetxsrb.pls 120.81.12000000.183 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       apetxsrb.pls 120.115.12010000.136 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apetxsrb.pls 120.223.12020000.31 - Patch:21639005:R12.AP.C
AP_ETAX_UTILITY_PKG
**For OA release 12.0.X:
       apetxutb.pls 120.66.12000000.138 - Patch:20304417:R12.AP.A
**For OA release 12.1.X:
       apetxutb.pls 120.102.12010000.102 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apetxutb.pls 120.179.12020000.21 - Patch:21639005:R12.AP.C

Prepayment Application

   AP_PREPAY_PKG
   AP_PREPAY_UTILS_PKG		AP_PREPAY_PKG
**For OA release 12.0.X:
       aprepayb.pls 120.42.12000000.27 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       aprepayb.pls 120.42.12010000.29 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       aprepayb.pls 120.62.12020000.11 - Patch:12.2.5
AP_PREPAY_UTILS_PKG
**For OA release 12.0.X:
       apprutlb.pls 120.9.12000000.11 - Patch:12742360:R12.AP.A
**For OA release 12.1.X:
       apprutlb.pls 120.10.12010000.9 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apprutlb.pls 120.10.12020000.9 - [No patch available yet]

Invoices Matching

   AP_MATCHING_PKG
   AP_MATCHING_UTILS_PKG
   AP_PO_AMT_MATCH_PKG
   AP_RECT_MATCH_PKG
   AP_OTHR_CHRG_MATCH_PKG		AP_MATCHING_PKG
**For OA release 12.0.X:
       apmatchb.pls 120.54.12000000.49 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       apmatchb.pls 120.58.12010000.43 - Patch:14180115:R12.AP.B
**For OA release 12.2.X:
       apmatchb.pls 120.90.12020000.14 - Patch:22680962:R12.AP.C
AP_MATCHING_UTILS_PKG
**For OA release 12.0.X:
       apmtutlb.pls 120.33.12000000.30 - Patch:22620659:R12.AP.A
**For OA release 12.1.X:
       apmtutlb.pls 120.36.12010000.29 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apmtutlb.pls 120.49.12020000.10 - Patch:20704876:R12.AP.C
AP_PO_AMT_MATCH_PKG
**For OA release 12.0.X:
       apamtpob.pls 120.43.12000000.26 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       apamtpob.pls 120.44.12010000.24 - Patch:14180115:R12.AP.B
**For OA release 12.2.X:
       apamtpob.pls 120.58.12020000.11 - Patch:22680962:R12.AP.C
AP_RECT_MATCH_PKG
**For OA release 12.0.X:
       aprcvmtb.pls 120.59.12000000.38 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       aprcvmtb.pls 120.61.12010000.36 - Patch:14180115:R12.AP.B
**For OA release 12.2.X:
       aprcvmtb.pls 120.80.12020000.14 - Patch:22680962:R12.AP.C
AP_OTHR_CHRG_MATCH_PKG
**For OA release 12.0.X:
       apothmtb.pls 120.19.12000000.13 - Patch:17351668:R12.AP.A
**For OA release 12.1.X:
       apothmtb.pls 120.20.12010000.13 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apothmtb.pls 120.27.12020000.7 - Patch:12.2.5

Invoice Cancellation

   AP_CANCEL_PKG
   AP_INVOICE_CORRECTIONS_PKG		AP_CANCEL_PKG
**For OA release 12.0.X:
       apicancb.pls 120.28.12000000.38 - Patch:22084404:R12.AP.A
**For OA release 12.1.X:
       apicancb.pls 120.35.12010000.28 - Patch:22084404:R12.AP.B
**For OA release 12.2.X:
       apicancb.pls 120.58.12020000.8 - Patch:22084404:R12.AP.C

AP_INVOICE_CORRECTIONS_PKG
**For OA release 12.0.X:
       apinvcob.pls 120.16.12000000.13 - Patch:18191442:R12.AP.A
**For OA release 12.1.X:
       apinvcob.pls 120.18.12010000.12 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apinvcob.pls 120.24.12020000.6 - Patch: 19137662:R12.AP.C

Mass Additions

  AP_MASS_ADDITIONS_CREATE_PKG		AP_MASS_ADDITIONS_CREATE_PKG
**For OA release 12.0.X:
       apmassab.pls 120.19.12000000.59 - Patch:18524308:R12.AP.A
**For OA release 12.1.X:
       apmassab.pls 120.22.12010000.52 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apmassab.pls 120.57.12020000.16 - Patch:20823281:R12.AP.C

Withholding Tax Calculation (AWT lines)

   AP_WITHHOLDING_PKG		AP_WITHHOLDING_PKG
**For OA release 12.0.X:
       apdoawtb.pls 120.30.12000000.61 - Patch:18280932:R12.AP.A
**For OA release 12.1.X:
       apdoawtb.pls 120.36.12010000.76 - Patch:22647459:R12.AP.B
**For OA release 12.2.X:
       apdoawtb.pls 120.87.12020000.22 - Patch:22647459:R12.AP.C

Invoices Import

   AP_IMPORT_INVOICES_PKG
   AP_IMPORT_UTILITIES_PKG
   AP_IMPORT_VALIDATION_PKG		AP_IMPORT_INVOICES_PKG
**For OA release 12.0.X:
       apiimptb.pls 120.57.12000000.61 - Patch:22284972:R12.AP.A
**For OA release 12.1.X:
       apiimptb.pls 120.64.12010000.62 - Patch:22507584:R12.AP.B
**For OA release 12.2.X:
       apiimptb.pls 120.100.12020000.27 - Patch:22507584:R12.AP.C
AP_IMPORT_UTILITIES_PKG
**For OA release 12.0.X:
       apiimutb.pls 120.54.12000000.51 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       apiimutb.pls 120.67.12010000.40 - Patch:22160889:R12.AP.B
**For OA release 12.2.X:
       apiimutb.pls 120.100.12020000.9 - Patch:22160889:R12.AP.C

AP_IMPORT_VALIDATION_PKG
**For OA release 12.0.X:
       apiimvtb.pls 120.105.12000000.154 - Patch:22601205:R12.AP.A
**For OA release 12.1.X:
       apiimvtb.pls 120.121.12010000.147 - Patch:22601205:R12.AP.B
**For OA release 12.2.X:
       apiimvtb.pls 120.219.12020000.44 - Patch:22601205:R12.AP.C

Invoices Accounting

   AP_ACCOUNTING_EVENTS_PKG
   AP_ACCOUNTING_PAY_PKG		AP_ACCOUNTING_EVENTS_PKG
**For OA release 12.0.X:
       apeventb.pls 120.45.12000000.90 - Patch:22857256:R12.AP.A
**For OA release 12.1.X:
       apeventb.pls 120.54.12010000.73 - Patch:22818396:R12.AP.B
**For OA release 12.2.X:
       apeventb.pls 120.123.12020000.6 - Patch:22818396:R12.AP.C
AP_ACCOUNTING_PAY_PKG
**For OA release 12.0.X:
       apacpayb.pls 120.12.12000000.46 - Patch:22857256:R12.AP.A
**For OA release 12.1.X:
       apacpayb.pls 120.12.12010000.45 - Patch:22857256:R12.AP.B
**For OA release 12.2.X:
       apacpayb.pls 120.47.12020000.11 - Patch:22857256:R12.AP.C

Suppliers

   AP_VENDORS_PKG
   AP_VENDOR_PARTY_MERGE_PKG
   AP_VENDOR_PUB_PKG
   AP_EMPLOYEE_UPDATE_PKG
   AP_GET_SUPPLIER_BALANCE_PKG
   AP_PAY_SINGLE_INVOICE_PKG		AP_VENDORS_PKG
**For OA release 12.0.X:
       apvndhrb.pls 120.11.12000000.9 - Patch:22620659:R12.AP.A
**For OA release 12.1.X:
       apvndhrb.pls 120.15.12010000.7 - Patch:22604120:R12.AP.B
**For OA release 12.2.X:
       apvndhrb.pls 120.20.12020000.3 - Patch:22604120:R12.AP.C

AP_VENDOR_PARTY_MERGE_PKG
**For OA release 12.0.X:
       apvdmrgb.pls 120.9.12000000.25 - Patch:18302994:R12.AP.A
**For OA release 12.1.X:
       apvdmrgb.pls 120.12.12010000.15 - Patch:21261663:R12.AP.B
**For OA release 12.2.X:
       apvdmrgb.pls 120.22.12020000.4 - Patch:18286018:R12.AP.C

AP_VENDOR_PUB_PKG
**For OA release 12.0.X:
       appvndrb.pls 120.43.12000000.203 - Patch:21024171:R12.AP.A
**For OA release 12.1.X:
       appvndrb.pls 120.78.12010000.169 - Patch:22886121:R12.AP.B
**For OA release 12.2.X:
       appvndrb.pls 120.202.12020000.44 - Patch:22742182:R12.AP.C
AP_EMPLOYEE_UPDATE_PKG
**For OA release 12.0.X:
       aphrupdb.pls 120.7.12000000.13 - Patch:16497958:R12.AP.A
**For OA release 12.1.X:
       aphrupdb.pls 120.7.12010000.13 - Patch:21261663:R12.AP.B
**For OA release 12.2.X:
       aphrupdb.pls 120.16.12020000.3 - Patch:12.2.5
AP_GET_SUPPLIER_BALANCE_PKG
**For OA release 12.0.X:
       apxsoblb.pls 120.12.12000000.12 - Patch:15890895:R12.AP.A
**For OA release 12.1.X:
       apxsoblb.pls 120.14.12010000.10 - Patch:22384200:R12.AP.B
**For OA release 12.2.X:
       apxsoblb.pls 120.20.12020000.2 - Patch:12.2.5
AP_PAY_SINGLE_INVOICE_PKG
**For OA release 12.0.X:
       appayinb.pls 120.13.12000000.5 - Patch:20773950:R12.AP.A
**For OA release 12.1.X:
       appayinb.pls 120.14.12010000.6 - Patch:21841763:R12.AP.B
**For OA release 12.2.X:
       appayinb.pls 120.15.12020000.5 - Patch:21841763:R12.AP.C


2) Script to know the versions of packages installed on your instance

SELECT owner,
                name,
                text,
                SUBSTR( LTRIM(text),
                INSTR(lTRIM(text),' ',1,2 )+1,
                INSTR(lTRIM(text),' ',1,4)-INSTR(LTRIM(text),' ',1,2 )-1)
                filever
FROM all_source
WHERE line = 2
AND name = '&package_name';

For more refere the metalink id.
Posted by at No comments:
Labels: , , ,
Subscribe to: Posts (Atom)