OBPM 14.5.0.9.0 File Upload : Future Dated Transaction Not Going Into Warehouse Queue. (Doc ID 3001543.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Symptoms

On : 14.5.0.0.0 version, Production Support

OBPM 14.5.0.9.0 File Upload : Future dated transaction not going into Warehouse Queue.


ERROR
-----------------------
File Upload : Future dated transaction not going into Warehouse Queue.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. We are having an issue where file upload is future dated it is not dropping into Warehouse Queue but after Sanction Check it is being processed.
2. Pain.001 is received.
3. Batch is created and txn ref no is generated.
4. Txn goes into Sanction Check Queue
5. After approve the txn does not drop_in Warehouse Queue but it is processed even though the Instruction Date is correct (future date).

Changes

 fix provided to update txn status as future dated in pasoview and dispatch status will be pending during processing and once linked txn got created then dispatch status will be updated as blank.

The C2b Seed jobs in table pmtm_c2b_h_auto_job_param for  job codes was not maintained , hence console was not moved to warehouse queue after batch cutoff time .
Not the transaction will be in wareHouse queue .
Please check below seed jobs are maintained  :
C2B_HYBRID_FUTURE_JOB
C2B_HYBRID_POST_WAIT_PENDING_JOB
C2B_HYBRID_PRE_WAIT_PENDING_JOB  

Cause

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