Thursday, 8 June 2017

Validation status for all Event Class is on Not Validated status in SLA Mehtod for Cash Management

http://cashmanagementcm.blogspot.com/2017/06/validation-status-for-all-event-class.html

Validation status for all Event Class is still on Not Validated Status after running Validate Application Accounting Definitions

--------------------------------------------------------------------------------------------------

In test instance please:

1) Bounce the Services/Instance.

2) Import Application Accounting Definitions
concurrent request must be run from the Cash Management responsibility
with the following parameters:

AMB CONTEXT : Default
SOURCE FILE PATHNAME : <filename with full path for CEXLAAAD.ldt>
eg. /tst/apps/apps_st/appl/ce/12.0.0/patch/115/import/US/CEXLAAAD.ldt
MERGE ANALYSIS : No
IMPORT OPTION : Merge
VALIDATE : Yes


(2).
1. Please run XLAABACR Validate Application Accounting Definitions request
Paramters:
Ledger =
Uncompile Status Only= No
Application = Cash Management
Application Accounting definition owner= Oracle

2. Review Application Accounting Definition Validation Report
All AADs (of type Oracle and User) attached to ACTIVE ledgers and ACTIVE applications must be re-validated.

Tuesday, 23 May 2017

Validation status for all Event Class is till on Not Validated status in SLA Mehtod

http://cashmanagementcm.blogspot.com/2017/05/in-test-instance-please-1-bounce.html

In the Test instance please:

1) Bounce the Services/Instance.

2) Import Application Accounting Definitions
concurrent request must be run from the Cash Management responsibility
with the following parameters:

AMB CONTEXT : Default
SOURCE FILE PATHNAME : <filename with full path for CEXLAAAD.ldt>
eg. /tst/apps/apps_st/appl/ce/12.0.0/patch/115/import/US/CEXLAAAD.ldt
MERGE ANALYSIS : No
IMPORT OPTION : Merge
VALIDATE : Yes


(2).
1. Please run XLAABACR Validate Application Accounting Definitions request
Paramters:
Ledger =
Uncompile Status Only= No
Application = Cash Management
Application Accounting definition owner= Oracle

2. Review Application Accounting Definition Validation Report
All AADs (of type Oracle and User) attached to ACTIVE ledgers and ACTIVE applications must be re-validated.

Friday, 20 January 2017

Transfer Number Skips in Bank Account Transfers

http://cashmanagementcm.blogspot.com/2017/01/transfer-number-skips-in-bank-account.html

a.
alter Sequence CE.CE_PAYMENT_TRANSACTIONS_S NOCACHE;

b.
select min_value, max_value,increment_by, cache_size, last_number from all_sequences where
sequence_name like 'CE_PAYMENT_TRANSACTIONS_S%';

It should return one row with value: cache_size as 0

Monday, 9 January 2017

How to Generate Document Number in Bank Statement Reconciliation

http://cashmanagementcm.blogspot.com/2017/01/how-to-generate-document-number-in-bank.html

Query the Account Name from Reconcile Bank Statement Form

Navigate to Document Categories in system Administrator

Enter the Queried Account Name in Code, Name and Description

Enter Table Name "CE_STATEMENT_HEADERS_ALL" and save

Now, Define Sequences for the Account Name