How can I release the credit hold amount in a partially closed order?
Summary:
Pic 12444: The credit amount should be 1039.24 but not 4874.58. Any Idea?
Pic example: The result is like that, let's use order 12444 to have an example.
Content (required):
Here have some partially closed orders but the close status line didn't release the credit amount correctly.
Please refer to my attachments.
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications 23A (11.13.23.01.0)
Code Snippet (add any code snippets that support your topic, if applicable):
We use this SQL to query the data about credit :
WITH v1 AS (
SELECT CustomerAccountPEO.CUST_ACCOUNT_ID,
PartyPEO.PARTY_NAME
FROM fusion.HZ_CUST_ACCOUNTS CustomerAccountPEO,
Tagged:
1