A. Sequencing issue
Check the NEXTVAL Sequence by executing the following Sql query;
SELECT MAX(ID)from PPA_WIP_VALUES
SELECT PPA_WIP_VALUES_S1.NEXTVAL from dual
If the MAX(ID) is greater than the result from PPA_WIP_VALUES_S1.NEXTVAL then execute
these two Sql statement below.
Note: the Increment by value is dependent on the variance between MAX(ID) and result of PPA_WIP_VALUES_S1.NEXTVAL.
If for example output for MAX(ID) is: 60726 and output for PPA_WIP_VALUES_S1.NEXTVAL is: 60226 then you would want
to use an increment value if say 1000.
Here is the Sql query you execute:
alter PPA_WIP_VALUES_S1 increment by 1000;
then commit the change. This will set PPA_WIP_VALUES_S1.NEXTVAL value to 61226.
Now if going forward we want to maintain an increment value of 1 then we need to execute this Sql statement
alter PPA_WIP_VALUES_S1 increment by 1;
With the table sequence corrected the Post To Wip will now work as expected.
B. No dates provided on the Post to WIP page filter.
Per documentation, provide a "From Date" and "To Date"
Note: If you do not enter any dates (start date or end date), all available transactions from any past date are pulled up to the current (today’s) date. So, to post any available transactions with a future date you must specify an end date.