EEX 9.2: Post Liabilities Abends at Step EX_LIBRARY.CF_INS.CF_INS_2 With a Unique Constraint Error When Applying Cash Advances With Different Cost Centers to an Expense Report (Doc ID 2939431.1)

Last updated on JULY 24, 2023

Applies to:

Symptoms

    When applying Cash Advances with different cost centers to an Expense Report, Post Liabilities is abending at Step EX_LIBRARY.CF_INS.CF_INS_2 with a unique constraint error.

    Steps to reproduce the issue:

    1 .- Log into the FSCM Online Application as an Expenses User
    2 .- On the Employee Self Service Fluid Homepage, click on Cash Advances Tile
    3 .- Create Two Cash Advance, with different Account and Deptid each one Cash Advances, Approve, Stage, Pay and Post
    4 .- Add New Expense Report Tab
    5 .- Click on Add
    6 .- Filling all  Expense Report Required fields, lint the two Cash Advances
    7 .- Click on Summary and Submit
    8 .- Select the Check box "By checking this box, I certify the expenses submitted are accurate and comply with expense policy."
    9 .- Click on submit expense report
    10.- Log into the FSCM Online Application as an Expenses Approver
    11.- On the Employee Self Service Fluid Homepage, click on Approval Tile
    12.- Approve the Expense Report
    13.- Navigate to Travel & Expenses > Expenses > Expense Process
    14.- Run Expense Processing "Post Liabilities"
    15.- ISSUE: Unique constraint error while running Post Liabilities process

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.