ERPstuff - Oracle EBS Community

While Submitting in Payables Create Accounting program iam getting this Error


APP-FND-01564: ORACLE error 923 in FDFGDF

Cause: FDFGDF failed due to ORA-00923: FROM keyword not found where expected.

The SQL statement being executed at the time of the error was: SELECT FND_DATE.DATE_TO_DISPLAYDATE(GLP.START_DATE) and was executed from the file &ERRFILE.


while Submitting in Payables Transfer Journal Entries to GL


APP-FND-00806: The default value Asia/Pacific Localizations is invalid for the Application segment. Your default value will be ignored. Please inform your system administrator that:

Add the value Asia/Pacific Localizations to the value set for segment Application, or choose another default value in the Key Flexfield Segments form or Descriptive Flexfield Segments form. Use the Edit Concurrent Program or Define Report Set form for Standard Report Submission report defaults.
--------------------------------------------------------------
Value Asia/Pacific Localizations for the flexfield segment Application does not exist in the value set XLA_SRS_SUBLEDGERS.

1. The application for the responsibility (in Sysadmin --> Security --> Responsibility --> Define) should be 'Payables', Not 'Asia/pacific Localization'.
2. The application for the 'Create Accounting' concurrent program should be 'Subledger Accounting' (when you attach this concurrent program with the request set, check the application), NOT 'Asia/Pacific Localization'.

Cheers,
Saravanan

Hi TGS,

The application for the 'Create Accounting' concurrent program should be 'Subledger Accounting' (when you attach this concurrent program with the request set, check the application), NOT 'Asia/Pacific Localization'.

As Per Your solution i have checked the 'Create Accounting' program request Set And the Application Name for that was subledger Accounting and not 'Asia/Pacific Localization'.

And I am getting the same error.
Please provide some inputs on this issue as I am not able to resolve the same.

Thanks and Regards