My Oracle Support Banner

CSV Import: Line Item data is not being created in the Payment Applications record. The import seems to complete but no Line Item data is created. (Doc ID 2517123.1)

Last updated on OCTOBER 18, 2019

Applies to:

Primavera Unifier Cloud Service - Version N/A and later
Primavera Unifier - Version 9.7 and later
Information in this document applies to any platform.

Symptoms

On Unifier : Any Version

When importing Line Item Data with a zero dollar amount (0.00) to a Payment Applications type Business Process record by way of a CSV file:

Expected Result

Line Item data should be created after the import is complete.

Actual Result

Line Item data is not being created in the Payment Applications record. The import seems to complete but no Line Item data is created.

Steps To Reproduce

  1. To export the payment application line item template
    • Navigate to the payment application business process log.
    • Click New to create a new business process.
    • Select a Reference Base Commit for the business process. If you do not select a Reference Base Commit, the exported template will not contain data. Data from all columns
      in the Reference Base Commit is exported.
    • Choose File > Export Line Item Template.
    • Click Open to open the file in Microsoft Excel, or click Save to save the file to your local drive. The template exports with SOV line item data in it, based on the selected Reference
      Base Commit.
  2. To modify the payment application line item template
    • Open the exported CSV file in Microsoft Excel. The SOV line items are listed.
    • Enter the line item information into the spreadsheet. Each line must begin with a "D". For multiple tabs, you must enter appropriate tab name in the Tab Name column.
    • Enter data into the required fields, as well as non-required fields as needed.
  3. To import the payment application line item template
    • Navigate to the Payment Application business process log.
    • Select a business process and click Open.
    • Click the Import button. The imported line items replace any existing line items. If there are any import errors, you can open the CSV file to view and correct the error. No line
      items are imported if any row contains an import error.
Business Impact
Because of this Line Item Data with a zero dollar amount cannot be imported into the Payment Applications type Business Process record.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.