Financial Management - PSFT (MOSC)

MOSC Banner

Pay Cycle: payment creations fails for new bank account/payment mehtods

edited Jan 3, 2019 4:49AM in Financial Management - PSFT (MOSC) 4 commentsAnswered

We have added 3 new payment methods (Boleto, Book, and TED) for our Brazil business unit. We also open a new bank account in Brazil. For paycycle criteria, I added brazil business unit, new bank code and new payment methods. Now when we run paycycle. It selects Brazilian payments with these new payment method but payment creation process fails on step " AP_PYMNTID.IDMAIN.Step09-A (Action SQL) " with message " SQL Error: ORA-01407: cannot update ("SYSADM"."PS_PYCYCL_01_TMP8"."PYMNT_ID") to NULL"

It tried to update pymnt_id from PS_PYMNT_IDR_TMP, where this table has nothing in it. My guess is that I am missing something in configuration. As these are new payments and pay cycle is not recognizing it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center