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