EAR 9.2: Budget Checking Process (FS_BP AE Program) No Longer Setting Budget Line Status to B (Bypass) on Cash Control Accounting Entries for Direct Journal Payments Causing GLSF224G SQR Report To Miss Transactions (Doc ID 3039735.1)

Last updated on AUGUST 06, 2024

Applies to:

Symptoms

After a systems upgrade from FSCM 9.2 PUM Image #18 to Image #48, it has been detected that the Budget Checking process, (FS_BP AE Program), is no longer populating the Budget Line Status of the AR Cash Accounting Line with a value of 'B' (Bypass), instead it leaves it as blank. This, in turn, is causing the GLSF224G SQR report to not include its Accounting Entries.

REPLICATION STEPS:

  1.- Log into the FSCM 9.2 Online Application as a Receivables User.
  2.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
  3.- Create a new Regular Deposit, and enter one Payment transaction, defining it as Direct Journal.
  4.- Navigate to: Accounts Receivable > Payments > Direct Journal Payments > Direct Journal Acctg Entries
  5.- Open the recently created Payment transaction.
  6.- Manually add the needed Accounting Entries, balance them, and mark the transaction as complete.
  7.- Upon saving the changes, the system shows the Budget Check icon.
  8.- Launch Budget Checking process (FS_BP AE Program) against this Direct Journal Payment, to validate the entered accounting entries.
  9.- Confirm that the Budget Status is displayed as valid.
  10.- PROBLEM: Query Record PS_AR_PAY_MISC for the Regular Deposit Payment transaction, and confirm that from the 2 Accounting Entry Lines generated, the AR Cash one has a Field BUDGET_LINE_STATUS as blank, while the AR Distribution line has a value of V (Valid).
  11.- Navigate to: General Ledger > Federal Reports > CTA / 1219 / 1220 > Generate CTA / 1220 Data
  12.- Create a new Run Control ID with all needed criteria.
  13.- Launch the SF224/SF1220 Generate process (GLSF224G SQR Report).
  14.- PROBLEM: Checking at the output on the GLSF224G SQR Report, the Deposit and Payment recently completed and Budget Check is not being included.

As the SF224/SF1220 Generate process (GLSF224G SQR Report) is not including some of the Direct Journal Payment data, the Federal Reports will not be accurate, and will miss relevant information.

When the Budget Check process (FS_BP_ AE Program) is run at the Direct Journal Payment Accounting Entries page, the commitment control logic should properly validate all needed lines, and correctly set Record Field PS_AR_PAY_MISC.BUDGET_LINE_STATUS = 'B' (Bypass) for the AR Cash Accounting Line, and not leave it as blank.

Changes

Cause

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