INTERFACE DETAILS
CUSTOMERS UPLOAD USING INTERFACE:
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INT_ALL
----------------------------------------------------
HZ_PARTIES
HZ_PARTY_SITES
HZ_CUSTOMER_PROFILES
HZ_CUST_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_ACCOUNTS
HZ_CUST_ACCT_RELATE_ALL
HZ_LOCATIONS
CUSTOMER UPLOAD USING API:
-- Creation of Customer Account and Party using API
HZ_CUST_ACCOUNT_V2PUB.create_cust_account
-> Check whether the customer account exist for the above party_id
-- To create a location
HZ_LOCATION_V2PUB.create_location
-> Check whether the given city, county, state combination is valid
-> Check whether the location already available
-- To create a party site using party_id and location_id
-- which were created from the earlier steps
HZ_PARTY_SITE_V2PUB.create_party_site
-> Checking Party Site already present in the system
-- To create an account site using cust_account_id and party_site_id
HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site
-> Checking Customer site already Present
-- To create an account site use using cust_acct_site_id
HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use
-> Checking Site Use already exist
-> get the payment term id from ra_terms table
` -> get the sales rep id from ra_salesreps table
-> get the territory_id from ra_territories table
-> Check primary site already exist for the SHIP_TO site
-> Create Profile amounts only if site is BILL_TO
-> get the customer account id to create relationship
-> Get the cust account profile id to create customer profile amounts
-> create customer profile amounts
HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt
-- Creation of Contact Points
-- 1. Create Person
-- 2. Create relation contact-org between the person and org
-- 3. Create a contact point at customer level/Address level
-- (Here the contact point is created at customer level and
-- PHONE, EMAIL has been added to the contact point)
HZ_PARTY_V2PUB.create_person
-- Create a relation cont-org to the contact and the customer
HZ_PARTY_CONTACT_V2PUB.create_org_contact
-- Create a contact point at customer level using the create role
HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role
-- Create a contact PHONE / EMAIL for the above contact point
HZ_CONTACT_POINT_V2PUB.create_contact_point
VENDOR INTERFACE:
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT
--------------------------------------------
PO_VENDORS
PO_VENDOR_SITES_ALL
PO_VENDOR_CONTACTS
VENDOR AND SITE LEVELS
--Validation for SHIP TO and BILL TO LOCATION ID
-- Validation for SHIP and BILL TO for vendors
-- Validation for TERM_ID for vendors
-- Validating the VAT CODe
-- Validating invoice Currency codes of vendors
-- Validating Payment Currency codes vendors
--Validating the vendor type lookup code
--Validating the Minority group lookup code
--Validating the pay group lookup code
--Validating the FREIGHT_TERMS_LOOKUP_CODE_V
--validating FOB_LOOKUP_CODE_V
CONTACTS LEVEL
--Validation for Vendor
--Validation for Site
TAX RATES INTERFACE:
AR_TAX_INTERFACE
-----------------------------------------
AR_LOCATION_VALUES
AR_LOCATION_RATES
ITEM MASTER INTERFACE:
MTL_SYSTEM_ITEMS_INTERFACE
-------------------------------------
MTL_SYSTEM_ITEMS_B
--validating for NULL Item Description
--validating Template (mtl_item_templates)
--Validating for Item Already Existing in Base Table (mtl_system_items_b)
--validating for Buyer (po_agents_v)
--validating for Planner (mtl_planners)
--validating for Cost Of Sales Account (gl_code_combinations_kfv)
--validating for Sales Account (gl_code_combinations_kfv)
ITEM CATEGORIES INTERFACE:
MTL_ITEM_CATEGORIES_INTERFACE
-----------------------------------------
MTL_ITEM_CATEGORIES
--validating For Item Not Present in Base Table (mtl_system_items_b)
--validating for NULL MANUFACTURER
--validating for NULL PRODUCT_GROUP
--validating for NULL TYPE
--validating for NULL Sub Type
--validating For MANUFACTURER, PRODUCT_GROUP, TYPE, SUB_TYPE Combination in Base Table (mtl_categories_b)
PRICE LIST API:
QP_PRICE_LIST_PUB.PROCESS_PRICE_LIST
-----------------------------------------------
QP_LIST_HEADERS
QP_LIST_LINES
--Validating For Item is Present in Base Table (mtl_system_items_b)
--Deriving Concatenated Category Segment For the Given Inventory Item ID (mtl_categories_b_kfv)
--Validating For Dynamic Formula is Present in Base Table (qp_price_formulas_tl)
STOCK LOCATORS API:
INV_LOC_WMS_PUB.CREATE_LOCATOR
-----------------------------------------------------------
MTL_ITEM_LOCATIONS
--Combination is already Exists (mtl_item_locations_kfv)
--Sub Inventory is not exists (mtl_secondary_inventories)
PURCHASE ORDER INTERFACE:
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
------------------------------------------------
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
-- populating Project information from mapping table
-- Project ID population (pa_projects_all)
-- Task ID population (pa_tasks)
-- Get Mapping Values for charge account, accrual account and Varaiance account
-- getting the requestor info (per_all_people_f)
-- Populating New Deliver to location from mapping table
-- Populating New Ship to location from mapping table
-- Populating New Bill to location from mapping table
GOODS RECEIPTS INTERFACE:
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
-----------------------------------------------------------
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS
-- Checking PO is exists are not
-- Receipt is Already in Interface Table (rcv_headers_interface)
-- getting mapped inv org (mtl_parameters)
-- fetching Vendor, Site, Ship to location and Agent_Id from PO (po_headers_all)
-- getting employee/person name (per_all_people_f)
-- Fetching new ship to lotion code part (hr_locations_all)
-- Fetching new deliver to location code part (hr_locations_all)
AR INVOICES INTERFACE:
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
---------------------------------------------------------
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
-- Validation for transaction type (RA_CUST_TRX_TYPES)
-- derive_cust_trxtype_id (ra_cust_trx_types)
-- validate_trx_amount is null
-- validate_tax_code (ar_vat_tax)
-- derive_term_id (ra_terms)
-- derive_salesrep_id (ra_salesreps)
-- derive_orig_system_customer_id (hz_cust_accounts)
-- derive_orig_system_address_id (hz_cust_acct_sites, hz_cust_site_uses)
AP INVOICES INTERFACE:
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
----------------------------------------------------
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_PAYMENTS_ALL
-- duplicate_inv_check (ap_invoices)
-- get_vendor_details (po_vendors, po_vendor_sites)
-- get_term_id (ap_terms_tl)
-- get_ccid (gl_code_combinations)
-- check for invoice number is null
-- check for invoice net amount is null
-- check for invoice date is null
AR RECEIPTS (AUTO LOCK BOX):
AR_INTERIM_CASH_RECEIPTS_ALL
----------------------------------------------------
AR_CASH_RECEIPTS_ALL
-- Batch Name Validation (ar_batches)
-- Currency Code Validation (fnd_currencies)
-- Bill Customer / Address Validation (hz_cust_acct_sites, hz_cust_site_uses, hz_cust_accounts)
FIXED ASSETS
FA_MASS_ADDITIONS
--------------------------
FA_ADDITIONS
-- Validation for Location KFF (fa_locations)
-- Validation for Categories KFF (fa_categories)
-- Validation for Expense Account KFF (gl_code_combinations)
SALES ORDER IMPORT:
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
------------------------------------------
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
WSH_DELIVERY_DETAILS
Headers:
-- Code FOR SOLD TO ORG ID (hz_cust_accounts)
-- Code For Bill To From Orig System Reference (hz_cust_acct_sites, hz_cust_site_uses)
-- Code For Order Type (oe_order_types_v)
-- Code For Sales Rep (ra_salesreps_all)
-- Code For Payment Term (ra_terms)
Lines:
-- Item not exists in Price list for Item (qp_list_lines_v, mtl_system_items)
CUSTOMER ITEM CROSS REFERENCE INTERFACE:
MTL_CI_INTERFACE
MTL_CI_XREFS_INTERFACE
------------------------------
MTL_CUSTOMER_ITEMS
MTL_CUSTOMER_ITEM_XREFS
--validating for NULL Customer Number
--validating Duplicate Customer Number, Cross Reference Combination In Staging Table
--validating Duplicate Item Number, Customer Number, Cross Reference Combination In Staging Table
--validating for Item (mtl_system_items_b)
--validating for Customer (ra_customers)
BOM INTERFACE:
BOM_BILL_OF_MTLS_INTERFACE
BOM_INVENTORY_COMPS_INTERFACE
--------------------------------------------
BOM_BILL_OF_MATERIALS
BOM_INVENTORY_COMPONENTS
--validating for NULL Assembly Item
--Validating for Assembly Item Is Existing in Base Table (mtl_system_items_b)
--Validating for Component Item Is Existing in Base Table (mtl_system_items_b)
ON HAND QUANTITIES INTERFACE:
MTL_TRANSACTIONS_INTERFACE
---------------------------------------
MTL_ONHAND_QUANTITIES_DETAIL
--validating for NULL Item Number
--validating for NULL SubInventory
--validating For Item Not Present in Base Table (mtl_system_items_b)
--validating For NULL OnHand Quantity
--validating For Zero OnHand Quantity
--Validating For Unit Of Measure (mtl_units_of_measure)
--Validating For SubInventory (mtl_secondary_inventories)
--Validating For Distribution Account (gl_code_combinations_kfv)
--Validating For Locators (mtl_item_locations_kfv)
--Validating For Transaction Type (mtl_transaction_types)
PURCHASE REQUISION INTERFACE:
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL
--------------------------------------------------
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL
REPORT DEVELOPMENT/CUSTOMIZATION
CREDIT MEMO
Optio Report will be using Oracle reports to capture the information and will print the output with business logo and required format.
1. Pull standard Invoice Print Selected Invoices report
2. Add seven fields in the standard report and save as custom NAE Credit Memo Invoice Print Selected Invoices report.
Fields
1. Warehouse location – Should appear to the right of Amount in the line item section.
2. Customer collector – Should appear to the right of salesperson.
3. Item No. – Should appear to the left of Description.
4. UOM (unit of measure) – Should appear to the right of Description.
5. Sales tax – Should appear below Invoice discount.
6. Amount subject to sales tax – Should appear below sales tax. This amount is the total of Line Item Amounts where tax code is not Exempt.
7. Amount exempt from sales tax – Should appear below Amount subject to sales tax. This amount is the total of Line Item Amounts where tax code is Exempt.
8. Customer Item No. (From Customer Cross Reference table) – Should appear to the right of Item Number. (8/18/05)
9. Invoice Discount – Should appear below tax summary by tax name. (8/18/05)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment