Showing posts with label R11. Show all posts
Showing posts with label R11. Show all posts

Friday, June 16, 2017

Cannot Unapply Receipt in Fusion Receivables Cloud Service

When do unapply receipt for the transaction that has adjustment, this error come out:

1. A document sequence does not exist for the current document, even though the ledger option Enforce Sequencing for Receivables is enabled. (AR-855682)

2. ORA-20001: (AR-855636)

3. An Unexpected error occurred while reversing the adjustment . Contact your help desk (AR-856802)


After submit Service Request like below:

PROPOSED SOLUTION 
================== 
SELECT * 
/* SR3-15016089661 */ 
FROM FND_DOC_SEQUENCE_CATEGORIES 
WHERE NAME = 'Adjustment Reversal' 

Result: 

CODE NAME TABLE_NAME DESCRIPTION 
Adjustment Reversal Adjustment Reversal AR_ADJUSTMENTS_ALL Adjustment Reversal 

However, the above category is not assigned to any document sequence: 

SELECT 
/* SR3-15016089661 */ 
FROM fusion.FND_DOC_SEQUENCE_ASSIGNMENTS 
WHERE CATEGORY_CODE = 'Adjustment Reversal' 

Result: No Data Available 

Hence, you need to go to task Manage Document Sequences and assigned the Document Sequence Category 'Adjustment Reversal' to the appropriate Document sequence (I assume AR_PJA_SEQ_ADJUSTMENT) and its Legal Entity 

This assignment it is required. 

CAUSE DETERMINATION 
================== 
document sequence category 'Adjustment Reversal' is missing the assignment to a document sequence