My Oracle Support Banner

The Concurrent Programs "Payables Transfer To General Ledger" And "Payables Transfer to GL" Fail In R12 (Doc ID 1179363.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Jul-2013***

Goal

Q1 - On R12 application, when attempting to run the "Payables Transfer to General Ledger" program the following error occurs:

Error
APP-FND-01564: ORACLE error 904 in FDFGDF

Cause: FDFGDF failed due to ORA-00904: "AP_GL_TRANSFER_PKG"."AP_MC_CHECK": invalid identifier.

The SQL statement being executed at the time of the error was: SELECT L.MEANING FROM FND_LOOKUPS L,AP_SYSTEM_PARAMETERS ASP WHERE L.LOOKUP_TYPE = 'YES_NO' AND (( L.LOOKUP_CODE = 'N' AND 'N' = (SELECT ASP.INCLUDE_REPORTING_SOB FROM AP_SYSTEM_PARAMETERS ASP)) OR ( L.LOOKUP_CODE = 'Y' AND 'Y' = (SELECT ASP.INCLUDE_REPORTING_SOB FROM AP_SYSTEM_PARAMETERS ASP ) AND AP_GL_TRANSFER_PKG.AP_MC_CHECK(:a1) <> 'R') OR ( L.LOOKUP_CODE = 'N' AND AP_GL_TRANSFER_PKG.AP_MC_CHECK(:a2) = 'R')) and was executed from the file &ERRFILE.

Q2 - On R12 application, when attempting to run the "Payables Transfer to GL" program, the following error occurs :

Error
APP-FND-00784: Invalid reference AP_SRS_ACCT_METHOD! in default value defined for segment Discount Taken
Please check the default values you have specified for your segments.

and

APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.