Home » Applications » Oracle Fusion Apps & E-Business Suite » iby_ext_party_pmt_mthds record is not being created from supplier open interface (r12 ap,iby , supplier open interface)
| iby_ext_party_pmt_mthds record is not being created from supplier open interface [message #581526] |
Mon, 08 April 2013 10:22 |
marvSQL
Messages: 13
Registered: February 2008
Location: JAMAICA
|
Junior Member |
|
|
In 11i payment method the PAYMENT_METHOD_LOOKUP_CODE was stored on the po_vendors record.this value could be retrieved by :
SELECT payment_method_lookup_code
INTO v_temp_look_up
FROM po.po_vendors
WHERE Trim(UPPER (vendor_name)) = Trim(UPPER (var_vendor_nm));
Sites record also had PAYMENT_METHOD_LOOKUP_CODE that could be retrieved by:
select pos.payment_method_lookup_code
INTO v_temp_look_up
from po_vendors po,PO_VENDOR_SITES_ALL pos
where po.vendor_id=pos.vendor_id
AND Vendor_site_Id=var_Vendor_site_Id ;
Some of our old custom applications however ONLY USE the PAYMENT_METHOD_LOOKUP_CODE from the po.po_vendors RECORD.
Hence upon completion of the SUPPLIER OPEN INTERFACE the PAYMENT_METHOD_LOOKUP_CODE would be accessible from the po.po_vendors record.
Now we are upgrading to R12.
I did some reading and realized that r12 PAYMENT_METHOD_LOOKUP_CODE
Is stored in IBY_EXTERNAL_PAYEES_ALL and iby_ext_party_pmt_mthds.
I loaded a vendor via the interface using:
INSERT INTO AP.AP_SUPPLIERS_INT
(VENDOR_INTERFACE_ID,
VENDOR_NAME,
SEGMENT1,
VENDOR_TYPE_LOOKUP_CODE,
TERMS_ID,
SET_OF_BOOKS_ID,
PAY_DATE_BASIS_LOOKUP_CODE,
PAY_GROUP_LOOKUP_CODE,
PAYMENT_PRIORITY,
INVOICE_CURRENCY_CODE,
PAYMENT_CURRENCY_CODE,
DISTRIBUTION_SET_ID ,
ACCTS_PAY_CODE_COMBINATION_ID ,
PREPAY_CODE_COMBINATION_ID,
PAYMENT_METHOD_LOOKUP_CODE ,
TERMS_DATE_BASIS ,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
payment_method_code)
VALUES
(
VAR_VENDOR_INTERFACE_ID ,
SUP_VENDOR_NAME_var,
SUP_SEGMENT1_var,
Upper(Trim(VENDOR_TYPE_LOOKUP_CODE_var)),
10000 ,
2024 ,
SUP_PAY_DATE_BASIS_LOOKUP_CODE_var,
Upper(Trim(Nvl(PAY_GROUP_LOOKUP_CODE_var))) ,
SUP_PAYMENT_PRIORITY_var,
SUP_INVOICE_CURRENCY_CODE_var,
SUP_PAYMENT_CURRENCY_CODE_var,
SUP_DISTRIBUTION_SET_ID_var,
'3007',
'3007',
'EFT',
SUP_TERMS_DATE_BASIS_var,
SUP_ATTRIBUTE_CATEGORY_var,
SUP_ATTRIBUTE1_var ,
'EFT') ;
I ran the supplier interface and it completed successfully.
I ran the query for the supplier:
SELECT * FROM ap_suppliers WHERE VENDOR_NAME ='MARVEN, MARVEN'
AND VENDOR_ID='35425'
AND PARTY_ID ='47546' ;
This query returned the correct record.
I then ran another query to get the iby_ext_party_pmt_mthds for the SUPPLIER.
SELECT * FROM iby_ext_party_pmt_mthds
WHERE ext_pmt_party_id IN (
SELECT EXT_PAYEE_ID FROM IBY_EXTERNAL_PAYEES_ALL
WHERE PAYEE_PARTY_ID='47546'
)
BUT IT DID NOT RETURN ANY VALUE!!!
I logged into the oracle payables and then went to the suppliers screen.
I then clicked the Payment Details link. Under the Payment Method section none of the payment methods were selected !
I checked the 'Wire' Payment method and saved.
I then ran the query :
I then ran another query to get the iby_ext_party_pmt_mthds for the SUPPLIER.
SELECT * FROM iby_ext_party_pmt_mthds
WHERE ext_pmt_party_id IN (
SELECT EXT_PAYEE_ID FROM IBY_EXTERNAL_PAYEES_ALL
WHERE PAYEE_PARTY_ID='47546'
)
And it returned the correct row.
Now I would like to know
Why is the iby_ext_party_pmt_mthds record was not created from the supplier open interface seeing that I specified a value ('EFT') for the payment method for the supplier?
kindly help...thanks in advance
|
|
|
|
Goto Forum:
Current Time: Mon Dec 23 00:26:19 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
