How to Import Project Misc Cost in Oracle Fusion using the FBDI

 In this post, we will see how to import the Project Miscellaneous Cost using the Oracle FBDI templates in the fusion.

1. Download the latest FBDI template : ProjectUnprocessedMiscellaneousExpenditureItemImportTemplate.xlsm

2. Enter all the required columns and generate the data in CSV file format.

3. Following the CSV file is generated, Load the file into the staging tables using the process : "Load Interface File for Format"in the Scheduled process. Ensure the submitted process completes successfully.

4. After successful loading of the data, run the "Import Costs" process.

 5. Select all the Mandatory input parameters and submit the process.

6. To check the output of the Import Cost Process, see the chld job "Import Cost : Generate Output Report" which has output details.

Tables for the PO Interface Errors in Oracle Fusion.

 Here is the post which provides details about the PO Interface Error Table.

            PO_INTERFACE_ERRORS

Following are the key columns which stores the error information in the interface table.

         a. Error_Message

         b. Error_Message_Name

         c. Column_Name

         d. Column_Value

         e. Table_Name

    

Tables for the Contract Attachments in Oracle Fusion.

 Following are the tables involved in the Contract Attachments in Oracle Fusion.

1. FND_ATTACHED_DOCUMENTS

2. FND_DOCUMENTS_VL

Here is some more additional details for the WHERE clause which needed for the Contract Attachments.

a. FND_ATTACHED_DOCUMENTS.ENTITY_NAME = 'OKC_SUPPORTING_DOCS'

b. FND_ATTACHED_DOCUMENTS.PK1_VALUE = OKC_K_HEADERS_VL.ID

c. FND_ATTACHED_DOCUMETNS.DOCUMENT_ID =  

                                                                             FND_DOCUMENTS_VL.DOCUMENT_ID

 

Tables for Contracts in Oracle fusion.

 In this post we will see the base tables for the Contracts in Oracle fusion. 

These are some of the tables involved in the Contracts.

1. OKC_K_HEADERS_VL

2. OKC_CONTRACT_TYPES_TL

3. OKC_CONTACTS

4. OKC_K_PARTY_ROLES_B

5. OKC_K_REL_OBJS

How to Import Journals with the Descriptive Flex Fields in Oracle fusion.

In order to import the Import Journals in Oracle fusion along with the Descriptive Flexfields, make sure that you have the FBDI created for the Journals along with the attribute columns populated.

And during the Import Journal Process, just make sure you select the input parameter : Import Descriptive Flexfields either as "With validation" or "Without validation"

Import Journals - GL Interface table in Oracle fusion.

For the Import Journals - General Ledger, below is the interface table used in Oracle fusion.

GL_INTERFACE

In order to identify the records for the Journals which you load, always use the Group ID in the FBDI file that distinguishes the GL records.

Import the Journals using the Oracle FBDI, following are the steps needs to be followed :

1. Generate the GLInterface.csv file using the Oracle FBDI.

2. Load Interface File for Import

     Import Process : Import Journals

     Data File : Upload the GL Journal FBDI zip file to be uploaded.

3. Once the process completes successfully, run the next import process :

      Import Journals 

      Following are the parameters to be used for the import

      Data Access Set : Select the data access set

      Source : Select the source as per what is mentioned in the FBDI file.

      Ledger : Select the ledger to be imported.

      Group ID  : Identifier from the FBDI file.

      Post Account Errors to Suspense : No

      Create Summary Journals : No

      Import Descriptive Flexfields : No