Error in Transfer Project Invoice Charges

Issue Description

Error while running the program to transfer Project Invoice Charges

Concurrent Program Name

Transfer Project Invoice Charges

Steps To Reproduce the Error

1. Navigate to Projects responsibility > Control > Invoice Charges

2. Run the program 'Transfer Project Invoice Charges'

3. Provide your project name and accept rest of the default parameters

Error Description

MSG-03113: IPV-10: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
REP-1825: Before Report trigger returned FALSE.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1825: MSG-00000: Transfer_Charges_to_PA() << : 
MSG-00000: Transfer_Charges_to_PA() >> : 
MSG-03113: IPV-10: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
REP-1825: Before Report trigger returned FALSE.

Resolution

1. Simply download patch 8338798 and apply it. Make sure you download the patch for your Server environment

2. Retry running the program and the error will be gone.

Environment

  • Oracle EBS R12.1.x
  • Linux x86-64

References

http://support.oracle.com-> patch 8338798 

Error in starting DB Listener - TNS-12542: TNS:add...
Error in PRC: Generate Draft Revenue for a Single ...