Wednesday 6 November 2013

Customer Standard Profile Class

Customer Standard Profile Class


While creating a new customer through the Customer Standard form of Order Management Super User Responsibility, the system threw up an error message "Error: Provide a positive integer for minimum customer balance amount or percent when balance amount overdue type is amount or percent respectively". Below steps can be followed to resolve the error.

1.Login to the application with ‘Oracle Order Management Super User’ Responsibility

2.The Navigation Path is Customers>Profile Class.

3.Query for the Profile Class “DEFAULT”

4.For each currency, make sure that the Minimum Customer Balance is not null and there exists a corresponding value.

5.Save the Changes.

Following screenshots depicts the above steps

Navigation: Customer >Profile Class.

Query the Profile Class “DEFAULT”




Monday 4 November 2013

How to find OPP log file - XML Publisher
The Concurrent Request ends with Phase 'Completed' and Status 'Warning' which indicates that the Output Post Processor (OPP) failed to generate an output file.






In such cases the request log file shows a generic error message indicating the the post-processing action has failed.

...
+------------- 1) PUBLISH -------------+
Beginning post-processing of request 3181343 on node FINAPPS at 25-OCT-2011 11:41:30.
Post-processing of request 3181343 failed at 25-OCT-2011 11:41:31 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+
...

The actual error returned by the XML Publisher Core engine is captured in the OPP log file.
One of the easiest way to obtain the OPP log file is to run the below script from the database by providing request_id.

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
  FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
 WHERE fcpp.processor_id = fcp.concurrent_process_id
   AND fcpp.action_type = 6
   AND fcpp.concurrent_request_id = &request_id;

Output of the script contains logfile location just like below
/u01/app/inst/apps/NZAPPS/logs/appl/conc/log/FNDOPP10981694.txt

Developer/Administrator/DBA has to go to that location and take the OPP logfile

Alternate Method:


Getting OPP Log from the application itself
a. System Administrator > Concurrent > Manager > Administer
b. Search for 'Output Post Processor'
c. Click the 'Processes' button
d. Click the Manager Log button. This will open the 'OPP'
e. Upload the OPP log file.