Account’s Payables Suppliers Loader Process Details

Account’s Payables Suppliers Loader Process Details

 

 Supplier Conversion :
    -------------------
    Pre-Requisites:
    --------------
      a) Set-up Operating unitsm responsibilities, system profile options.
      b) Setup GL Account codes, ap distribution sets and bank accounts
      c) Setup Financial options and payable options
      d) Setup Supplier Classification , supplier types
      e) setup payment terms, paygroups, freight terms shipping methods
      f) setup tax codes and supplier numbering financial option

  Interface Tables:
  ----------------
      AP_SUPPLIERS_INT
      AP_SUPPLIER_SITES_INT
      AP_SUP_SITE_CONTACT_INT

  Base Tables :
  -----------
      PO_VENDORS \ AP_SUPPLIERS
      PO_VENDOR_SITES_ALL\AP_SUPPLIER_SITES_ALL
      PO_VENDOR_CONTACTS\AP_SUPPLIERS_CONTACTS

  Interface Programs:
  ------------------
       Supplier Open Interface Import
       Supplier Sites Open Interface Import
       Supplier Site Contacts Open Interface Import
 
  Parameters To Be Passesd During the program:
  -------------------------------------------
       Import Options        = All  (all, new, rejected)
       Batch_size            = 1000
       Print exceptions only = No
       Debug Switch          = No
       Trace Switch          = No

  Main Colums in AP_SUPPLIERS_INT:
  -------------------------------
          vendor_interface_id      

vendor_name      

segment1
          pay_group_lookup_code    

set_of_books_id\ledger_id  

organization_type_lookup_code
          vendor_type_lookup_code  

enabled_flag    

biil_to_location_id
          terms_id                

terms_name ,

num_1099,

type_1099

  Main Colums in AP_SUPPLIER_SITES_INT:
  ------------------------------------
          vendor_interface_id        

vendor_site_code  

vendor_site_id
          pay_group_lookup_code      

terms_name        

payment_method_lookup_code
          prepay_code_combination_id

default_pay_site_id

   Main Colums in AP_SUPPLIER_SITE_CONTACTS_INT:
  ---------------------------------------------
          vendor_site_id,

vendor_site_name

  Validation Tables :
  -----------------
          PO_VENDORS   \ AP_SUPPLIERS

FND_LOOKUP_CODES  

HR_LOCATIONS_ALL
          AP_TERMS_ALL AP_TAX_CODES_ALL  

                    GL_CODE_COMBINATIONS

Payables Open Interface Import - Functional Overview

Accounts Payable Interface Ex plane and meta link note = ALL AP_INVOICE_INTERFACE DETAILS WITH  SQL LOADER, PROCESS FLOW  AND INTERVIEW FAQ's

R12: Master Note: APXIIMPT - Payables Open Interface Import - Functional Overview

To Bottom

Modified:13-May-2013 Type:BULLETIN

Language:

APPLIES TO: Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1] Information in this document applies to any platform. Payables Open Interface Import program - APXIIMPT PURPOSE This document has been created to provide an approach to the Payables Open Interface Import Program through a functional view. In this note we can find details to understand what the Open Interface Import is and  how it runs. Details about the information required if a SR must be logged to solve an issue with this program have been also included. DETAILS Definition The Payables Open Interface Import Program (APXIIMPT) is used to create Payables invoices from invoice data entered in the following Payables Open Interface tables: AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE. These interface tables can be populated with invoice data coming from the following sources:    - Quick Invoices: Standard and Credit invoices can be entered in the Quick Invoices window.    - Invoices loaded from other accounting systems with a custom SQL*Loader program.    - Supplier invoices transferred through Oracle e-Commerce Gateway    - Credit Card transactions transferred using the Create Procurement Card Issuer Invoice program.    - Lease invoices transferred from Oracle Property Manager.    - Lease payments from Oracle Assets. Values for all NOT NULL columns in these tables must be populated to successfully save the invoice data in the interface tables. If a valid value is not populated in a Required field the record will be rejected. The NULL columns must remain as null or the import process will fail Parameters Parameters to submit the Payables Open Interface Import program:    1) Source -> one of the above sources can be selected to import the records from the interface tables    2) Group -> limits the import to invoices with a particular group_id, which must exactly match with the group_id in the interface tables.    3) Invoice Batch Name -> a batch name can be assigned only if the 'AP:Use Invoice Batch Controls' profile option has been enabled.    4) Hold Name -> to place a hold for all the imported invoices    5) Hold Reason -> hold reason description in case a hold is placed    6) GL Date -> to assign a GL date to invoices not assigned with it    7) Purge -> set it to Yes to delete from the Payables Open Interface tables all successfully imported invoice records. To do it later the Payables Open Interface Purge Program can be also used.    8) Summarize Report -> set it to Yes to summarize the audit portion of the Payables Open Interface Import report. If parameter is not set and there are a lot of imported records report could be very long. Additional Invoices Import Reports There are three additional reports associated to the Payables Open Interface Import program:    **Payables Open Interface Import Report -> child report of the Payables Open Interface Import Program        This report is used to review detailed information for each invoice imported during Payables Open Interface Import process. This report has two sections:           1) Payables Open Interface Audit Report -> displays the invoices successfully imported during import process           2) Payables Open Interface Rejections Report -> displays those invoices that Payables was not able to import.                It also lists the rejection reasons to be corrected.                This information is stored in the AP_INTERFACE_REJECTIONS table.   **Payables Open Interface Outbound Advice -> standalone report to be manually submitted by the user.       This program creates notification data about e-Commerce invoices processed during Payables Open Interface Import.   **Payables Open Interface Purge -> standalone report to be manually submitted by the user.       This report is used to purge records from the Payables Open Interface tables (AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE).       We strongly recommend to purge only invoices successfully imported setting the 'Purge All' parameter to No. Setting this parameter to Yes purges all records in the Payables Open Interface tables. Files Involved in the Interface Process The following filenames are involved in the Invoices Import Process:    1) Payables Open Interface Import Program:  APXIIMPT.rdf    2) Payables Open Interface Purge:  APXIIPRG.rdf Tables involved in the Invoices Import Process 1) AP_INVOICES_INTERFACE        Stores information to create the invoice header.        An invoice header is created for each record in this table. 2) AP_INVOICE_LINES_INTERFACE        Stores information to create invoice lines and invoice distributions.        Several invoice distributions can be created for the same invoice line. 3) AP_INTERFACE_CONTROLS        Temporary table that holds control information about segregated data in the AP_INVOICES_INTERFACE table during the Payables Open Interface Import.        The table ensures that each import must be unique with respect to the combination of SOURCE and GROUP_ID.        This allows the submission of multiple imports at the same time. 4) AP_INTERFACE_REJECTIONS        Stores information about invoice data from the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables which could not be processed by Payables Open Interface Import.        Data in this table can be purged by using the Payables Open Interface Purge report. Packages Involved in the Interface Process The following packages are involved in the Invoices Import Process:   1) Package name: AP_IMPORT_INVOICES_PKG       Package files: apiimptb.pls / apiimpts.pls   2) Package name: AP_IMPORT_UTILITIES_PKG       Package files: apiimutb.pls / apiimuts.pls   3) Package name: AP_IMPORT_VALIDATION_PKG       Package files: apiimvtb.pls / apiimvts.pls How the Payables Open Interface runs 1) The AP_INVOICES_INTERFACE and the AP_INVOICE_LINES_INTERFACE tables are populated by the user.     This task can be performed using one of the above detailed sources. 2) The Payables Open Interface Import program (APXIIMPT) is submitted by the user from the Submit Concurrent Requests window. 3) Package AP_IMPORT_INVOICES_PKG selects data from the interface tables for the specified source. 4) Package AP_IMPORT_UTILITIES_PKG checks the records and insert them into the AP_INTERFACE_CONTROLS table. 5) Then the AP_IMPORT_UTILITIES_PKG reviews every record in the AP_INTERFACE_CONTROLS table.     If the record is valid the AP_IMPORT_VALIDATION_PKG checks all the data to know if it is valid. Then the status is set to 'Processed' and will be displayed in the 'Payables Open Interface Audit' report.     If the record is rejected the status will be set to 'Rejected' and it will be populated in the AP_INTERFACE_REJECTIONS table. The record will be displayed in the 'Payables Open Interface Rejections' report. 6) The AP_IMPORT_VALIDATION_PKG checks that all data extracted from the interface tables like supplier, supplier site, PO number, payment method, payment terms, are valid.     This checking is performed only for valid records and never for the rejected ones. 7) If the data are valid then the AP_IMPORT_UTILITIES_PKG inserts the data into the AP_BATCHES_ALL, AP_INVOICES_ALL, AP_INVOICE_LINES_ALL tables.     Holds are also inserted in case the parameters 'Hold Name' and 'Hold Reason' have been set. 8) The successful processed records will be deleted from the interface tables by the AP_IMPORT_UTILITIES_PKG if the Purge parameter has been set to Yes. Troubleshooting Here we can find some of the most common error messages arisen during the import process:   *Issue: Invoice has not been imported and it should     Fix: Review the data for that invoice to know if they are valid. Examples: valid Supplier and Supplier Site, invoice number is not duplicated, invoice date has been set, PO number exists...   *Issue: Invoices are rejected during the invoice import process with the 'Invalid Liability Account' error message.     Fix: Check for Security rules and Cross Validation rules on the Liability account   *Issue: The Open Interface Invoice Lines are not deleted automatically even after creating Invoices.             The Line status changes to PROCESSED after the AP Invoice is generated but it still remains in the interface tables.     Fix: The successful processed invoice lines will be automatically deleted from the interface tables when the Purge parameter is set to Yes while submitting the Payables Open Interface Import program. Information required to log a SR If there is an issue in your instance with the Payables Open Interface Import Program and it is not detailed above you must check My Oracle Support Note:1311932.1 (APXIIMPT - Payables Open Interface Import - Troubleshooting). If the issue still persists a SR must be logged with Oracle Support Services. We strongly recommend to upload the following information at SR creation time in order to save time and get an answer/solution from Oracle Support Services as soon as possible:   1) Log file for the Payables Open Interface Import report   2) Debug Log file for the Payables Open Interface Import report -> see Note:1320716.1 for instructions   3) Output file for the 'Payables Open Interface Audit Report' and for the 'Payables Open Interface Rejections Report'   4) Versions for the AP_IMPORT_INVOICES_PKG, AP_IMPORT_UTILITIES_PKG and AP_IMPORT_VALIDATION_PKG packages -> see Note:1320692.1 for instructions   5) FND Debug Log file for the execution of the Payables Open Interface Import report -> see Note:1320736.1 for instructions.       Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP. REFERENCES NOTE:1311932.1 - R12: Master Note: APXIIMPT - Payables Open Interface Import - Troubleshooting NOTE:1320692.1 - R12: Main AP Packages Involved in Invoices Workbench (APXINWKB). How To Know Versions For These Packages? NOTE:1320716.1 - R12: How To Get a Debug Log File For a Concurrent Request NOTE:1320736.1 - R12: How To Get The FND Debug Log For On-Line Processes And For Concurrent Requests  R12: Main AP Packages Involved in Invoices Workbench (APXINWKB). How To Know Versions For These Packages? (Doc ID 1320692.1) R12: Main AP Packages Involved in Invoices Workbench (APXINWKB). How To Know Versions For These Packages? (Doc ID 1320692.1) To Bottom   Modified:13-May-2013 Type:REFERENCE In this Document   Purpose   R12: Main AP Packages Involved in Invoices Workbench (APXINWKB). How To Know Versions For These Packages?      1) Packages involved in Invoices Processing and latest available versions      2) Script to know the latest available versions for packages in any time         APPLIES TO: Oracle Payables - Version: 12.0.1 to 12.1.3 - Release: 12.0 to 12.1 Information in this document applies to any platform. Invoices Entry form - APXINWKB PURPOSE Goal of this note is to know the main packages involved in the invoices creation and in the main invoices features and processes. Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP. R12: MAIN AP PACKAGES INVOLVED IN INVOICES WORKBENCH (APXINWKB). HOW TO KNOW VERSIONS FOR THESE PACKAGES? 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.18 - Patch:13374062:R12.AP.A **For OA release 12.1.X:        apiinceb.pls 120.49.12010000.16 - Patch:13374062:R12.AP.B AP_INVOICES_UTILITY_PKG  **For OA release 12.0.X:        apinvutb.pls 120.44.12000000.34 - Patch:10425573:R12.AP.A **For OA release 12.1.X:        apinvutb.pls 120.56.12010000.22 - Patch:10425573:R12.AP.B AP_UTILITIES_PKG  **For OA release 12.0.X:        aputilsb.pls 120.29.12000000.23 - Patch:13424053:R12.AP.A **For OA release 12.1.X:        aputilsb.pls 120.30.12010000.14 - Patch:13252658:R12.AP.B 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.58 - Patch:12373594:R12.AP.A **For OA release 12.1.X:        apinlinb.pls 120.64.12010000.48 - Patch:12373594:R12.AP.B AP_INVOICE_LINES_UTILITY_PKG **For OA release 12.0.X:        apilnutb.pls 120.28.12000000.21 - Patch:12865213:R12.AP.A **For OA release 12.1.X:        apilnutb.pls 120.31.12010000.15 - Patch:12865213:R12.AP.B Invoice Distributions    AP_INVOICE_DISTRIBUTIONS_PKG AP_INVOICE_DISTRIBUTIONS_PKG **For OA release 12.0.X:        apiindib.pls 120.59.12000000.54 - Patch:12691958:R12.AP.A **For OA release 12.1.X:        apiindib.pls 120.68.12010000.47 - Patch:12691958:R12.AP.B 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.135 - Patch:13374062:R12.AP.A **For OA release 12.1.X:        apaprvlb.pls 120.140.12010000.98 - Patch:13374062:R12.AP.B AP_APPROVAL_MATCHED_PKG **For OA release 12.0.X:        aprmtchb.pls 120.42.12000000.44 - Patch:12908372:R12.AP.A **For OA release 12.1.X:        aprmtchb.pls 120.43.12010000.34 - Patch:12908372:R12.AP.B 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.6 - Patch:12747896:R12.AP.B AP_FUNDS_CONTROL_PKG **For OA release 12.0.X:        aprfundb.pls 120.40.12000000.22 - Patch:13114217:R12.AP.A **For OA release 12.1.X:        aprfundb.pls 120.44.12010000.17 - Patch:13114217:R12.AP.B 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:13424053:R12.AP.A **For OA release 12.1.X:        apetaxpb.pls 120.15.12010000.3 - Patch:13424053:R12.AP.B AP_ETAX_SERVICES_PKG **For OA release 12.0.X:        apetxsrb.pls 120.81.12000000.144 - Patch:13079028:R12.AP.A **For OA release 12.1.X:        apetxsrb.pls 120.115.12010000.96 - Patch:13079028:R12.AP.B AP_ETAX_UTILITY_PKG **For OA release 12.0.X:        apetxutb.pls 120.66.12000000.111 - Patch:13106066:R12.AP.A **For OA release 12.1.X:        apetxutb.pls 120.102.12010000.72 - Patch:13106066:R12.AP.B  Prepayment application   AP_PREPAY_PKG   AP_PREPAY_UTILS_PKG AP_PREPAY_PKG **For OA release 12.0.X:        aprepayb.pls 120.42.12000000.19 - Patch:12595394:R12.AP.A **For OA release 12.1.X:        aprepayb.pls 120.42.12010000.18 - Patch:13090879:R12.AP.B 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:12742360:R12.AP.B  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.37 - Patch:12428818:R12.AP.A **For OA release 12.1.X:        apmatchb.pls 120.58.12010000.29 - Patch:12428818:R12.AP.B AP_MATCHING_UTILS_PKG **For OA release 12.0.X:        apmtutlb.pls 120.33.12000000.18 - Patch:13374235:R12.AP.A **For OA release 12.1.X:        apmtutlb.pls 120.36.12010000.15 - Patch:13374235:R12.AP.B AP_PO_AMT_MATCH_PKG **For OA release 12.0.X:        apamtpob.pls 120.43.12000000.16 - Patch:12428818:R12.AP.A **For OA release 12.1.X:        apamtpob.pls 120.44.12010000.13 - Patch:13374235:R12.AP.B AP_RECT_MATCH_PKG **For OA release 12.0.X:        aprcvmtb.pls 120.59.12000000.23 - Patch:13374235:R12.AP.A **For OA release 12.1.X:        aprcvmtb.pls 120.61.12010000.19 - Patch:13374235:R12.AP.B AP_OTHR_CHRG_MATCH_PKG **For OA release 12.0.X:        apothmtb.pls 120.19.12000000.9 - Patch:12428818:R12.AP.A **For OA release 12.1.X:        apothmtb.pls 120.20.12010000.8 - Patch:13374235:R12.AP.B Invoice Cancellation    AP_CANCEL_PKG    AP_INVOICE_CORRECTIONS_PKG AP_CANCEL_PKG **For OA release 12.0.X:        apicancb.pls 120.28.12000000.31 - Patch:11781836:R12.AP.A **For OA release 12.1.X:        apicancb.pls 120.35.12010000.21 - Patch:11781836:R12.AP.B AP_INVOICE_CORRECTIONS_PKG **For OA release 12.0.X:        apinvcob.pls 120.16.12000000.9 - Patch:13532662:R12.AP.A **For OA release 12.1.X:        apinvcob.pls 120.18.12010000.6 - Patch:13532662:R12.AP.B Mass Additions  AP_MASS_ADDITIONS_CREATE_PKG AP_MASS_ADDITIONS_CREATE_PKG **For OA release 12.0.X:        apmassab.pls 120.19.12000000.43 - Patch:12660674:R12.AP.A **For OA release 12.1.X:        apmassab.pls 120.22.12010000.32 - Patch:12660674:R12.AP.B Withholding Tax calculation (AWT lines)    AP_WITHHOLDING_PKG     AP_WITHHOLDING_PKG **For OA release 12.0.X:        apdoawtb.pls 120.30.12000000.50 - Patch:13431819:R12.AP.A **For OA release 12.1.X:        apdoawtb.pls 120.36.12010000.51 - Patch:13431819:R12.AP.B 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.36 - Patch:13491024:R12.AP.A **For OA release 12.1.X:        apiimptb.pls 120.64.12010000.34 - Patch:13491024:R12.AP.B AP_IMPORT_UTILITIES_PKG **For OA release 12.0.X:        apiimutb.pls 120.54.12000000.46 - Patch:13491024:R12.AP.A **For OA release 12.1.X:        apiimutb.pls 120.67.12010000.31 - Patch:13491024:R12.AP.B AP_IMPORT_VALIDATION_PKG **For OA release 12.0.X:        apiimvtb.pls 120.105.12000000.107 - Patch:13491024:R12.AP.A **For OA release 12.1.X:        apiimvtb.pls 120.121.12010000.93 - Patch:13491024:R12.AP.B 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.78 - Patch:12555714:R12.AP.A **For OA release 12.1.X:        apeventb.pls 120.54.12010000.60 - Patch:12555714:R12.AP.B AP_ACCOUNTING_PAY_PKG **For OA release 12.0.X: apacpayb.pls 120.12.12000000.36 - Patch:13334090:R12.AP.A **For OA release 12.1.X: apacpayb.pls 120.12.12010000.35 - Patch:13334090:R12.AP.B  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:12922024:R12.AP.A **For OA release 12.1.X:        apvndhrb.pls 120.15.12010000.5 - Patch:12678066:R12.AP.B AP_VENDOR_PARTY_MERGE_PKG **For OA release 12.0.X:        apvdmrgb.pls 120.9.12000000.19 - Patch:12555081:R12.AP.A **For OA release 12.1.X:        apvdmrgb.pls 120.12.12010000.11 - Patch:12915229:R12.AP.B AP_VENDOR_PUB_PKG **For OA release 12.0.X:        appvndrb.pls 120.43.12000000.153 - Patch:12590128:R12.AP.A **For OA release 12.1.X:        appvndrb.pls 120.78.12010000.110 - Patch:13339733:R12.AP.B AP_EMPLOYEE_UPDATE_PKG **For OA release 12.0.X:        aphrupdb.pls 120.7.12000000.10 - Patch:12863338:R12.AP.A **For OA release 12.1.X:        aphrupdb.pls 120.7.12010000.10 - Patch:12863338:R12.AP.B AP_GET_SUPPLIER_BALANCE_PKG **For OA release 12.0.X:        apxsoblb.pls 120.12.12000000.9 - Patch:12823793:R12.AP.A **For OA release 12.1.X:        apxsoblb.pls 120.14.12010000.7 - Patch:12823793:R12.AP.B AP_PAY_SINGLE_INVOICE_PKG **For OA release 12.0.X:        appayinb.pls 120.13.12000000.3 - Patch:12971160:R12.AP.A **For OA release 12.1.X:        appayinb.pls 120.14.12010000.2 - Patch:12971160:R12.AP.B 2) Script to know the latest available versions for packages in any time 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 = 'AP_XXXXXX_PKG';

Account’s Payables Invoices & Suppliers Loader Process Details

 

Account’s Payables Invoices & Suppliers Loader Process Details

 

1.Account’s Payables Invoices & Suppliers Loader Process Details

1) Payables Interface:

   -----------------

   Pre-requisites:

   --------------

     a) Vendors and their Sites Should Be Setup

     b) Currency and exchange Rates Should Be setup

     c) Source and invoice type lookup code must be defined

     d) Account Payables Account and Distribution Account must be defined.

     e) Payment Terms should be defines and GL Period must be in opened status.

 

   Interface Tables:

   ----------------

     AP_INVOICES_INTERFACE

     AP_INVOCE_LINES_INTERFACE

 Error Tables:

 ------------

      AP_INTERFACE_REJECTIONS

      AP_INTERFACE_CONTROLS

 

   BASE TABLES :

   ------------

     AP_INVOICES_ALL

     AP_INVOICE_DISTRIBUTIONS_ALL

     AP_PAYMENT_SCHEDULES

 

  INTERFACE PROGRAM:

  -----------------

     Payables Open Interface Import

     

 

  Parameters to be passed during the program:

  -----------------------------------------

      Source      = External

      group_id    = As Specified in the data file

      Batch Name  = N/A

      Hold Name   = null

      Hold Reason = null

      gl date     = null

      Purge       = No

      Summarize   = No

 

 Main Columns In AP_INVOICES_INTERFACE:

 --------------------------------------

INVOICE_ID,    

INVOICE_NUM,

INVOICE_DATE,

INVOICE_AMOUNT

VENDOR_ID,    

VENDOR_NUM,  

VENDOR_NAME,

VENDOR_SITE_CODE,

VENDOR_SITE_ID

TERMS_NAME,    

TERM_ID,    

TERM_DATE,    

SOURCE,          

PAYMENT_METHOD_LOOKUP_CODE,

GL_DATE,        

PO_NUMBER,  

INVOICE_CURRENCE_CODE,          

EXCHANGE_RATE_TYPE

VOUCHER_NUMBER,

PAYMENT_CURRENCY_CODE,

DOC_CATEGPRY_CODE

 

 Main Columns In AP_INVOICE_LINES_INTERFACE:

 ------------------------------------------

INVOICE_ID  ,

INVOICE_LINE_ID,      

LINE_NUM,

LINE_TYPE_LOOKUP_CODE,

AMOUNT,

DIST_CODE_COMBINATION_ID,

DIST_CODE_CONCATENATED

PO_HEADER_ID,

PO_LINE_ID,              

PO_LINE_NUMBER

 

 Tables To Be Used For Validation:

 --------------------------------

       PO_VENDORS / AP_SUPPLIERS          

       AP_TERMS        

       ORG_ORGANIZATION_DEFINITIONS

       FND_CURRNECIES      

       AP_INVOICES_ALL  

       GL_DAILY_CONVERSION_TYPES

       GL_CODE_COMBINATIONS  

       AP_LOOKUP_CODES  GL_PERIOD_STATUSES

 

2)  Supplier Conversion :

    -------------------

    Pre-Requisites:

    --------------

      a) Set-up Operating unitsm responsibilities, system profile options.

      b) Setup GL Account codes, ap distribution sets and bank accounts

      c) Setup Financial options and payable options

      d) Setup Supplier Classification , supplier types

      e) setup payment terms, paygroups, freight terms shipping methods

      f) setup tax codes and supplier numbering financial option

 

  Interface Tables:

  ----------------

      AP_SUPPLIERS_INT

      AP_SUPPLIER_SITES_INT

      AP_SUP_SITE_CONTACT_INT

 

  Base Tables :

  -----------

      PO_VENDORS \ AP_SUPPLIERS

      PO_VENDOR_SITES_ALL\AP_SUPPLIER_SITES_ALL

      PO_VENDOR_CONTACTS\AP_SUPPLIERS_CONTACTS

 

  Interface Programs:

  ------------------

       Supplier Open Interface Import

       Supplier Sites Open Interface Import

       Supplier Site Contacts Open Interface Import

  

  Parameters To Be Passesd During the program:

  -------------------------------------------

       Import Options        = All  (all, new, rejected)

       Batch_size            = 1000

       Print exceptions only = No

       Debug Switch          = No

       Trace Switch          = No

 

  Main Colums in AP_SUPPLIERS_INT:

  -------------------------------

          vendor_interface_id      

vendor_name      

segment1

          pay_group_lookup_code    

set_of_books_id\ledger_id  

organization_type_lookup_code

          vendor_type_lookup_code  

enabled_flag    

biil_to_location_id

          terms_id                

terms_name ,

num_1099,

type_1099

 

  Main Colums in AP_SUPPLIER_SITES_INT:

  ------------------------------------

          vendor_interface_id        

vendor_site_code  

vendor_site_id

          pay_group_lookup_code      

terms_name        

payment_method_lookup_code

          prepay_code_combination_id

default_pay_site_id

 

   Main Colums in AP_SUPPLIER_SITE_CONTACTS_INT:

  ---------------------------------------------

          vendor_site_id,

vendor_site_name

 

  Validation Tables :

  -----------------

          PO_VENDORS   \ AP_SUPPLIERS

FND_LOOKUP_CODES  

HR_LOCATIONS_ALL

          AP_TERMS_ALL AP_TAX_CODES_ALL  

GL_CODE_COMBINATIONS

 

 

===========================================================

 

 

 

Prompt creating Table B2_AP_INV_STAGE

Create table B2_AP_INV_STAGE

(

 Invoice_Id                           NUMBER          PRIMARY KEY

,Invoice_Type_Lookup_Code           VARCHAR2(80)

,Vendor_Number                           VARCHAR2(240)   NOT NULL

,Vendor_Site_Code                VARCHAR2(30)    NOT NULL

,Invoice_Num                    VARCHAR2(50)    NOT NULL

,Invoice_Date                    DATE        NOT NULL

,Invoice_Currency_Code               VARCHAR2(15)    NOT NULL

,Exchange_Rate                    NUMBER      NOT NULL

,Invoice_Amount                 NUMBER        NOT NULL

,Description                    VARCHAR2(240)

,Po_Number                    VARCHAR2(20)

,Liability_Account                      VARCHAR2(100)

,Desc_liability_acc                    VARCHAR2(240)

,Tax_code                               VARCHAR2(15)

,Tax_Amount                             NUMBER

,Inv_Recieved_Date            DATE            NOT NULL

,Created_Date                    DATE            NOT NULL                

,Terms_name                    VARCHAR2(50)    NOT NULL

,Terms_Date                    DATE        NOT NULL

,Pay_Group_Lookup_Code                 VARCHAR2(25)

,Payment_Currency_Code               VARCHAR2(15)

,Payment_Method_Lookup_Code           VARCHAR2(25)    NOT NULL

,GL_Date                    DATE        NOT NULL

,Invoice_Source                VARCHAR2(80)    NOT NULL

,Validation_Record_Flag                VARCHAR2(1)

,Error_Message                      VARCHAR2(2000)

,Created_by                NUMBER

,Creation_date                DATE

,Last_Updated_by             NUMBER

,Last_Update_Date              DATE

,Last_Update_Login            NUMBER

)                                    

/

 

Prompt granting all on B2_AP_INV_STAGE to apps

GRANT ALL ON AP.B2_AP_INV_STAGE TO APPS WITH GRANT OPTION;

/

 

Prompt dropping sequence B2_AP_INV_LINES_S

DROP SEQUENCE B2_AP_INV_LINES_S

/

 

Prompt creating sequence B2_AP_INV_LINES_S

CREATE SEQUENCE B2_AP_INV_LINES_S

INCREMENT   by 1

START       with 2

MAXVALUE    9999999

NOCACHE

NOCYCLE

/

 

Prompt granting all on B2_AP_INV_LINES_S to apps

GRANT ALL ON AP.B2_AP_INV_LINES_S TO APPS WITH GRANT OPTION;

/

 

Prompt dropping sequence B2_AP_INV_HEAID_S

DROP SEQUENCE B2_AP_INV_HEAID_S

/

 

Prompt creating sequence B2_AP_INV_HEAID_S

CREATE SEQUENCE B2_AP_INV_HEAID_S

INCREMENT   by 1

START       with 2

MAXVALUE    9999999

NOCACHE

NOCYCLE

/

 

 

Prompt granting all on B2_AP_INV_HEAID_S to apps

GRANT ALL ON AP.B2_AP_INV_HEAID_S TO APPS WITH GRANT OPTION;

/

 

Prompt Connecting to Apps Schema

connect apps/apps@vis

show user

 

 

Prompt dropping synonym B2_AP_INV_HEAID_S in apps schema

drop synonym B2_AP_INV_HEAID_S 

/

 

Prompt creating synonym B2_AP_INV_HEAID_S in apps schema

create synonym B2_AP_INV_HEAID_S   for ap.B2_AP_INV_HEAID_S

/

 

Prompt dropping synonym B2_AP_INV_LINES_S  in apps schema

drop synonym B2_AP_INV_LINES_S 

/

 

Prompt creating synonym B2_AP_INV_LINES_S in apps schema

create synonym B2_AP_INV_LINES_S for ap.B2_AP_INV_LINES_S  

/

 

Prompt dropping synonym B2_AP_INV_STAGE  in apps schema

drop synonym B2_AP_INV_STAGE

/

 

Prompt creating synonym B2_AP_INV_STAGE in apps schema

create synonym B2_AP_INV_STAGE for ap.B2_AP_INV_STAGE 

/