Payables and Cash Management - EBS (MOSC)

MOSC Banner

Can't seem to get the distribution account to build when importing project related invoices through

edited Jun 25, 2009 10:12AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
I'm on 11.5.10.2 and I'm passing the following information for project related invoices, however when I run the payables import program it fails with account overlay errors.

Is there something else I should be passing?

I'd prefer not to have to call the project account generator from my sql code if it's avoidable.

  insert into ap_invoice_lines_interface
      ( invoice_id,
        invoice_line_id,
        line_number,
        line_type_lookup_code,
        amount,
        dist_code_concatenated, --null when project data provided
        description,
        creation_date,
        project_id,
        task_id,
        expenditure_type,
        expenditure_organization_id,
        expenditure_item_date 
      )
      values
      ( ap_invoices_s.currval,
        ap_invoice_lines_interface_s.nextval,

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