BPEL

Business Events can be used to invoke the BPEL from EBS

Practicalities - iProc

Issue:

Change the "Need-By Date" that defaults as 'System Date' to NULL

Solution:

• Set value of x_need_by_date as NULL in procedure CUSTOM_DEFAULT_REQ_LINE of the POR_CUSTOM_PKG; Compile the package and bounce Apache once.

Possible Solution:

• Try disabling the profile PO: Default Need-By Time

Oracle Code Analyzer

Oracle Code Analyzer tool is used to effectively analyse the PL/SQL failings in terms of the standards and the best practices to be followed to make the code more viable.

Set of pre-defined rules are taken into account while preparing the rule set. Most of the database standard rules are taken into account while preparing the rule set for the framework.

Run the rule set against the entire development environment and target those packages that violate any of the standards. This entails executing a daily report and reaching out to package owners for remediation.

• Centralized place to analyse the PL/SQL components.
• Availability of charts in the application providing necessary information about the PL/SQL component.
• Displays complexity cloud information of the PL/SQL components.

GoldenGate

Oracle GoldenGate empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases in real time with minimal overhead.

Oracle GoldenGate is used by major Fortune 500 companies and other large enterprises on more than 4,000 solution implementations worldwide to support mission-critical systems for data availability and integration.