My Oracle Support Banner

Automatic Remittance Failing With ORA-00904 ORDERS.WORKER_ID Invalid Identifier (Doc ID 783975.1)

Last updated on DECEMBER 06, 2021

Applies to:

Oracle Payments - Version 12.0.5 and later
Information in this document applies to any platform.
This problem can occur on any platform.


Automatic remittance batch is erroring out and no settlement records are created in Payments. Remittance log shows the error:

AUTOREMAPI module: Automatic Remittances Creation Program (API)
p_calling_app_id 222
p_calling_app_request_code AR_1111order_view_name AR_FUNDS_CAPTURE_ORDERS_V
iby.plsql.IBY_FNDCPT_TRXN_PUB.Create_Settlements: ENTER
iby.plsql.IBY_FNDCPT_TRXN_PUB.Create_Settlements: Fetching documents from
iby.plsql.IBY_FNDCPT_TRXN_PUB.Create_Settlements: Exception : ORA-00904: "ORDERS"."WORKER_ID":  invalid identifier

### Steps to Reproduce ###
1. Order an item from iStore.
2. Credit card authorized and approved by Paymentech
3. Pick release from OM
4. Ship Confirm from OM
5. Receivables Interface
6. Auto Invoice to import the order
7. Run Automatic Receipts
8. Run Automatic Remittance.

At this point expect settlement records to be created in Funds capture process manager. It is not


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

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

In this Document

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