You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I release the credit hold amount in a partially closed order?

Accepted answer
68
Views
4
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!