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 laterInformation in this document applies to any platform.
This problem can occur on any platform.
Symptoms
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
AR_FUNDS_CAPTURE_ORDERS_V view using CALL_APP_SERVICE_REQ_CODE
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
happening
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! |
In this Document
| Symptoms |
| Cause |
| Solution |