Payables and Cash Management - EBS (MOSC)

MOSC Banner

API or Import program to create Retainage Release type Invoice in Payable

edited Mar 7, 2017 4:00AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

Hi,

Is there any API or Import program to create Retainage Release type Invoice in Payable ? While trying to populate the interface as below and submit Payables Open Interface Import; the program rejects the record with error Invalid Invoice Type Lookup code. Type must be Standard, Credit, Debit, Payment Request, Prepayment, or Expense Report.

WE have to develop an interface to create retainage release invoices and I would appreciate any guidance here.

insert into apps.ap_invoices_interface
        ( invoice_id,
          group_id,
          invoice_num,
          invoice_type_lookup_code,
          invoice_date,
          vendor_id,
          vendor_site_id,
          invoice_amount,
          invoice_currency_code,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center