EAP: Payables Revaluation (AP_REVALUE) Assigns the Same Document Sequence Number to All Transactions Even Though Revalue Option = Supplier (Doc ID 3002159.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

Document Sequencing is turned on and the Revaluation Posting Option is set to Supplier. When running the Payables Revaluation (AP_REVALUE) process, the process is assigning the same Document Sequence Number to all of the transactions even though different Suppliers are associated to the Vouchers that have been processed.

TO REPRODUCE
1. Set Up Financials/Supply Chain > Install > Installation Options > Overall page, check the Enable Document Sequencing box
2. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition > Definition page, check the Enable Document Sequencing box
3. Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables BU Definition > Definition page, specify Revalue Option = Supplier
4. Set Up Financials/Supply Chain > Common Definitions > Market Rates > Market Rates
5. Market Rate page, setup is as follows:
    a. From USD to CAD
    b. Rate Type = CRRNT
    c. Effective Date = 08/01/2023 with Rate = 2.0
    d. Effective Date = 01/01/2023 with Rate = 1.5
6. Accounts Payable > Vouchers > Add/Update > Regular Entry 
7. Add 1st Voucher as follows:
    a. Business Unit = US001
    b. Supplier = USA0000035
    c. Invoice Date = 05/01/2023
    d. Accounting Date = 05/01/2023
    e. Change the Currency from USD to CAD
    f. Click the Document Sequence link
    g. Document Sequence page shows Document Sequence Number assigned
    h. Voucher > Payments page, click the Holiday/Currency link
    i. Holiday/Currency page, change the Payment Currency from USD to CAD
8. Add 2nd Voucher as follows:
    a. Business Unit = US001
    b. Supplier = USA0000036
    c. Invoice Date = 05/01/2023
    d. Accounting Date = 05/01/2023
    e. Change the Currency from USD to CAD
    f. Click the Document Sequence link
    g. Document Sequence page shows Document Sequence Number assigned, which is different that the Document Sequence Number assigned above in Step 7g
    h. Voucher > Payments page, click the Holiday/Currency link
    i. Holiday/Currency page, change the Payment Currency from
9. Accounts Payable > Batch Processes > Vouchers > Voucher Posting
10. Run Voucher Posting
11. Accounts Payable > Batch Processes > Vouchers > Payables Revaluation
12. Run Payables Revaluation
      a. As of Date = 08/09/2023
      b. Rate Type = CRRNT
      c. Accounting Date = 08/09/2023
      d. Business Unit = US001
13. Through SQL, check the table RVL_ACCTG_LN_AP
14. Notice that the DOC_SEQ_NBR is the same for all of the transactions even though there are 2 different VENDOR_ID’s specified 

Changes

Cause

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