My Oracle Support Banner

EAR 9.2: Error Message On FUNCLIB_AR.EXS_FUNCLIB.FieldFormula Codeline Due To Missing Fields STX_TAX_AUTH_RATE, And STX_TAX_RATE_CD, On Record PS_PAYMENT_ITEM (Doc ID 2402121.1)

Last updated on MAY 22, 2018

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

When attempting to open the Regular Deposit page in an environment that has just been updated with fixes from FSCM 9.2 Image #27, the Users get an Error Message at the time of trying to open an existing transaction, or adding a new one.

The executed PeopleCode from FUNCLIB_AR.EXS_FUNCLIB.FieldFormula seems to make reference to Fields STX_TAX_AUTH_RATE, and STX_TAX_RATE_CD, on Record PS_PAYMENT_ITEM, but after checking in Application Designer, such Fields do not exist in this Table.

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as a Receivables User
     2.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     3.- Click on the Find and Existing Value tab
     4.- Enter a Deposit Business Unit, and click on Search button
     5.- The system throws an Error Message
     6.- Click on the Add a New Value tab
     7.- Enter a Deposit Business Unit, and click on Add button
     8.- The system throws the same Error Message

ERROR MESSAGE:

     " PeopleCode compile error (Field PAYMENT_ITEM.STX_TAX_AUTH_RATE not defined. (2,17) ^ FAR) for program FUNCLIB_AR.EXS_FUNCLIB.FieldFormula. (2,405)
       A PeopleCode program for the specified reference failed to compile correctly for the indicated reason.
       In Application Designer, open the referenced program and examine the PeopleCode to locate the cause of the error. "

     " Cannot load PeopleCode for FUNCLIB_AR.EXS_FUNCLIB.FieldFormula. (2,218) PAYMENT_ID_ITEM.REF_VALUE.RowInit PCPC: 2507 Statement: 80
       Unable to load the specified PeopleCode program for the record or field.
       Review the program for errors. Verify that the record, field, and program type exist. If necessary, run a PeopleCode trace to determine the program that failed. "

ACTUAL RESULTS:

The faced Error Message prevents Users from creating new Regular Deposits, and its related Payments, or even viewing existing transactions. This is halting further testing to be able to Go Live with Image #26 in Production.

EXPECTED BEHAVIOR:

When a User tries to create a new Regular Deposit, or open and review and existing one, the system should enabled it so, with no Error Messages being thrown out.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.