Hi

I have created a package to load grades information as per code:
http://pastebin.com/m57c2146f

Data in my temporary table(currently loading 1st record only for testing!):
http://pastebin.com/m681542e3

The data in my table in sql :
Name Null? Type
----------------------------------------- -------- -----
SEQUENCE NUMBER
NAME VARCHAR2(70)
HEALTHCARE_SERVICE VARCHAR2(80)
DEATH_SERVICE VARCHAR2(70)
LONG_DISABILITY VARCHAR2(70)
MOBILE_PHONE VARCHAR2(5)
HOLIDAY_ENTITLEMENT NUMBER(5)
STD_PROBATION NUMBER(5)
STD_NOTICE NUMBER(5)
REPORTED_AS VARCHAR2(30)
PAYCODE VARCHAR2(5)
INCENTIVE_SCHEME VARCHAR2(20)
FLEX_BENEFIT VARCHAR2(20)

Also: I have removed all the value sets for the descriptive flexfield under:
Application > flexfield > Descriptive > segments

and i have successfully inserted the record manually by cutting and pasting field values from my data file!

So in SQL*PLUS: Why does it still complain of this:

Problem:
I am getting error:
LINE/COL ERROR
-----------------------------------------------------------------
71/1 PLS-00306: wrong number or types of arguments in call to
'CREATE_GRADE'

I went to line 71 within the file in notepad and i didnt find anything i am confused.

Thanks in advance

Tovia singer

Tovia

I would reckon it's objecting to your omission of the p_grade_id output parameter from the parameter list.

HI CT

Thanks so much

I added p_grade_id:=v_grade_id;
and it compiled successfull but didnt create any records, so i checked the commit, and it was in the place same place as in my jobs api call.
Also checked the application and there where no grades so it shouldnt have any problem loading them.

My data file is:
http://pastebin.com/m2bce6d4a

There should be an error if it doesnt load the data i dont understand!

Thanks in advance

Tovia Singer

So what gets reported when you run it? Presumably you get a load of lines in your 'dbms_output' destination that show

'Ex:<grade_id>,<object_version_number>'

What are the actual numbers being returned, if any?

Hi CT

Basically i set serverouput on:
set serveroutput on size 20000;

But i still get the following output:

SQL> @XXcompany_INT_GRADES_LOAD

Package created.

No errors.

Package body created.

No errors.

The revised code with p_grade_id:
http://pastebin.com/m5fc0c461

Thanks in advance

Tovia

OK so it compiles, but what happens when you run it?

HI CT

Sorry:

SQL> execute XXcompany_PKG_GRADES.XXcompany_LOAD_GRADES;
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,
Ex:,

PL/SQL procedure successfully completed.

And it doesnt actually load any data,

Thanks in advance

Tovia S

Could it be that the only reason you're not seeing exceptions is because you are trying to report them via the FND_FILE package, which really only works if you're running this from the conc. manager. As a temporary measure, can you change the FND_FILE references to DBMS_OUTPUT.put_line and re-run it? Also, I would say in the latest version of your script, you might benefit from moving the line of code currently at line 128:

DBMS_OUTPUT.PUT_LINE('Ex:'||v_grade_id||','||v_object_version_number);

to immediately *after* the api call, e.g. at line 119 (to quote the numbers from your Pastebin listing)

Hi CT

Sorry for the delay in feedback,

I did as you said above:

Latest code:
http://pastebin.com/m2c1dff1d

The feedback from/ error in sql:

SQL> execute XXcompany_PKG_GRADES.XXcompany_LOAD_GRA
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
Ex:,
-20001ORA-20001: FLEX-ID DOES NOT EXIST:
Ex:,
PL/SQL procedure successfully completed.
SQL>

Thanks in advance

Tovia Singer

Ah, this is of course a problem you will have seen before, in your 'job loading' process (see separate thread)

Recall that the text associated with this message code is "ID &ID for the flexfield segment &SEGMENT does not exist in the value set &VALUESET." In other words, you still have a valueset in place somewhere that is not liking the data you're trying to send to a desc flex segment.