When you drill down to AX Payables or Receivables from GL, you get the message FRM-40350 Query caused no records to be retrieved.

Make sure you set the Profile Option AX: Application Name to Null.

Interview Candidate
Apr 3rd, 2005
1
3519

Showing Answers 1 - 1 of 1 Answers

Prasad Patkar

Apr 20th, 2006

In this case suggest you to check Oracle Metalink...as
Subject: Receive FRM-40350 Error When Drilling Down From GL to AP Accounting
Doc ID: Note:364277.1
In Metalink cause is metioned as : The AP_AEL_SL_PAY_V and AP_AEL_SL_INV_V are org specific. This limits GL drill down to only those orgs that match the value set for the "MO: Operating Unit" profile option for GL.
This is documented in Bug 5141707 - Cannot Display Ap Accounting Lines From Drilldown When Org Ids Different
Solution : This issue will be resolved in a future patchset. The workaround is to set the "MO: Operating Unit" profile option for the GL user to the Org that is being drilled down into.