JA Natural Account Export Exception

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: Natural Account Export Exception Report
Short Name: JACNNAER
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT ACCOUNT_SEGMENT
                   ,ACCOUNT_LEVEL
                   ,VALUE_LENGTH
                   ,DECODE(EXPECTED_LENGTH, -1, '-', EXPECTED_LENGTH) EXP_LENGTH
               FROM JA_CN_COA_NA_EXCEPTIONS
              WHERE NA_REQUEST_ID=:request_id
              ORDER BY ACCOUNT_LEVEL, ACCOUNT_SEGMENT
Parameter Name SQL text Validation
Concurrent Request Id
 
Number