Tag Archives: Data Pump

The business group specified is invalid

Posted by on June 22, 2012 No comments

Problem:

After running a data pump import, the following is displayed in the “Data Pump Batch Exceptions Report”:

The business group specified is invalid

Cause:        You have specified an incorrect business group
identifier or name.
Action:        Correct the business group value or call your
local support representative.

Possible Solution:

Ensure that the business group in the data pump file matches the system profiles:

Profile > System > HR:Business Group
Profile > System > HR: Security Profile

 

SQL*Loader-404: Column CHAR present more than once

Posted by on June 22, 2012 No comments

Problem:

When loading data via SQL*Loader into a table on an 11g database, the following message appears:

SQL*Loader-404: Column CHAR present more than once in APPS.TMP_HRDPV_CREATE_IN_CWK's 
INTO TABLE block.

Solution:

In the SQL*Loader control file, the column names had comma after them. There should be whitespace, and then CHAR followed by comma.