rvtptcontrol failed RVTTH-445: Subroutine Please define all applicable accounts. Cause: Accounts have not been correctly defined. Please verify that all accounts have been defined on the receiving parameter fo
This error is occured
solution :
Run below query and you will the PO distribution for which "Accrual Account" and "Variance Account" is null
select poh.segment1 PO_NUMBER, por.release_num, poll.shipment_num, ood.organization_name ORG_NAME,ood.organization_id,ood.organization_code,
pod.org_id OPERATING_UNIT, pod.po_distribution_id,
pod.accrual_account_id, pod.variance_account_id
from apps.po_headers_all poh,
apps.po_line_locations_all poll,
apps.po_distributions_all pod,
apps.po_releases_all por,
apps.org_organization_definitions ood
where (accrual_account_id is NULL
OR variance_account_id is NULL)
and poh.po_header_id = <PO_HEADER_ID>
and poh.po_header_id = pod.po_header_id
and poh.po_header_id = por.po_header_id
and poh.po_header_id = poll.po_header_id
and poll.line_location_id = pod.line_location_id
and por.po_release_id = poll.po_release_id
and ood.organization_id= pod.destination_organization_id --org_id
and poh.approved_flag = 'Y';
Now open PO-Release
Navigation : Purchasing Super User > Purchase Orders > Purchase Order Summary
Enter PO number and Release number
Click on OPEN
then verify the distributions and enter the "Accrual Account" and "Variance Account" wherever it is null.
This error is occured
solution :
Run below query and you will the PO distribution for which "Accrual Account" and "Variance Account" is null
select poh.segment1 PO_NUMBER, por.release_num, poll.shipment_num, ood.organization_name ORG_NAME,ood.organization_id,ood.organization_code,
pod.org_id OPERATING_UNIT, pod.po_distribution_id,
pod.accrual_account_id, pod.variance_account_id
from apps.po_headers_all poh,
apps.po_line_locations_all poll,
apps.po_distributions_all pod,
apps.po_releases_all por,
apps.org_organization_definitions ood
where (accrual_account_id is NULL
OR variance_account_id is NULL)
and poh.po_header_id = <PO_HEADER_ID>
and poh.po_header_id = pod.po_header_id
and poh.po_header_id = por.po_header_id
and poh.po_header_id = poll.po_header_id
and poll.line_location_id = pod.line_location_id
and por.po_release_id = poll.po_release_id
and ood.organization_id= pod.destination_organization_id --org_id
and poh.approved_flag = 'Y';
Now open PO-Release
Navigation : Purchasing Super User > Purchase Orders > Purchase Order Summary
Enter PO number and Release number
Click on OPEN
then verify the distributions and enter the "Accrual Account" and "Variance Account" wherever it is null.
No comments:
Post a Comment