11i: How to Import Items Using Transaction Import When Using Conversion Of Legacy Data? (Doc ID 553250.1)

Last updated on OCTOBER 23, 2024

Applies to:

Oracle Project Costing - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Purpose

Questions and answers on how to import expenditure items using Transaction Import when using conversion of legacy data to Projects.

Questions and Answers

	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

Questions and Answers

For the transactions that are to be imported, should the expenditure ending date be the last day of the expenditure week for the transaction? Or can it be the same as the expenditure item date or some other date?

If employee history is not converted, there is no organization assignment to the employee as of the expenditure item date.
How to populate the organization_name and override_to_organization_name columns when Import Employee Organization is checked in the transaction source setup?

Can Supplier Invoices be used as the System Linkage function or Miscellaneous as the expenditure type class? If Supplier Invoices is used as the expenditure class, is it possible to drill down to Payables from projects?

What are the fields CDL_SYSTEM_REFERENCE1, CDL_SYSTEM_REFERENCE2,
CDL_SYSTEM_REFERENCE3 and CDL_SYSTEM_REFERENCE4 used for?

Are the fields ORIG_EXP_TXN_REFERENCE1, RIG_EXP_TXN_REFERENCE2,
ORIG_EXP_TXN_REFERENCE3, ORIG_USER_EXP_TXN_REFERENCE and VENDOR_NUMBER used by the Interface Supplier Invoices process only? Can these fields be used for bringing in converted data? Which of these fields should be populated for invoice number and vendor number so that drill down of payables is possible?

When transactions are imported as accounted, GL_DATE field is informational only. But should the GL period fall in open period even if the transaction will not go to GL?

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