Tag Archives: FFXBCP

ORA-01403 Error on FF_DATABASE_ITEMS When Running Quickpay

Ran QuickPay for user Joe; failed with error ORA-01403
Error was encountered when processing assignment USER-416
Error ORA-01403: no data found
has occurred in table ff_database_items at location 552
Cause:        an oracle error has occurred.  The failure was reported on table ff_database_items at location 552 with the error text ORA-01403: no dat

Checked Metalink, got article:

Subject:  ORA-01403 Error on FF_DATABASE_ITEMS When Running Quickpay
Doc ID:  Note:330791.1

Chose responsibility UK USD – HRMS Manager
Ran Bulk Compile Formula

Completed in error

See Metalink document:

Subject:  Payroll Failing with Ora-20001 Ora-06512: At “Apps.Pay_balance_pkg ORA-01006
Doc ID:  Note:428219.1

$FF_TOP/bin/FFXBCP apps/<apps password> 0 Y -U %% %%

APP-FF-34004: Oracle Payroll:HOUSE_RENT:1950/01/01 FAILED
APP-FF-33005: The local variable NET_PAY_ASG_RUN was used before being initialized

Cause:        The variable named in the error message is being used before any value has been assigned to it, so it has no meaningful value.

Action:        Please ensure variables have been assigned to before using them.

Subject:  PTO Formula Fails to Compile with Error APP-FF-33005
Doc ID:  Note:336157.1

Rerun HRGLOBAL with the global option (run DataInstall, choose 1I)

Bulk Compile Formula Command Line:

$FF_TOP/bin/FFXBCP apps/<apps password> 0 Y -U %% %%

Reduced number of formula instances to process from 159 to 47.

Ran QuickPay, completed successfully!!!

Ran Element Creation, completed successfully!!!

Ran Active Users report (Concurrent Manager), completed successfully!!!

ETA:

DataInstall set to Global

HRGLOBAL run, error with hrrbdeib.sql

DataInstall set to Global, UK HRMS, UK Payroll

HRGLOBAL run, error with hrrbdeib.sql

$FF_TOP/bin/FFXBCP apps/<apps password> 0 Y -U %% %%

HRGLOBAL run, error with hrrbdeib.sql