Microsoft Visual Basic Run-time error '1004': Method 'VBProject' of object '_Workbook' failed

To fix this issue, pls perform the below setups in MICROSOFT EXCEL to accept the WEBADI transaction in VBProject Workbook.

In Excel, use the following navigation:

Step 1: Open the Microsoft Excel and go to FILE à OPTIONS

Step 2: On the left, click on the Trust Center

Step 3: Click on the Trust Center Settings button and go to Macro Settings and Click on “Trust access to the VBA project object model”

Transient Attributes not getting populated | VO Extension

Scenario:

Standard VO has some transient attributes which gets populated by overriding the getter methods in the VORowmpl. When we extend this VO for adding some additional attributes, everything works except the original transient attributes. Those attributes are coming as null.

The reason is, when the extended VORowImpl is getting generated by the Jdeveloper, it will not call the super method (which is already overridden). So you need to modify the getter method of the Transient attribute in the extended VO to call the getter method in the Standard VO using super.

Standard VORowImpl getter method will be something as shown below.

                                public String getAttribute1() { 

                                                                return "Calculated Value"; 

 }  

Generated getter method in the extended VORowImpl  as shown below.

                                public String getAttribute1() { 

  return (String) getAttributeInternal("Attribute1"); 

 }  

Solution:

To fix this, modify the getter method of the extended VORowImpl as shown below.

                                public String getAttribute1() {  

  //return (String) getAttributeInternal("Attribute1"); 

  return super.getAttribute1();

 }

Populate LOV | Tab Out in OAF

Expectation :

Type search words in LOV Field & TAB out, it should populate the values as per search.

Issue : 

In LOV field, No response occurs when we type something & then click on TAB key.

Solution :

                Set disable validation Property to False for LOV.

iExpense Report struck in Interface table with REJECTION CODE : LINE AMOUNT IS NULL

Follow the below Steps to fix the Expense Interface struck:

Step 1: Identify the Null Amount column by using the below query for the reported Expense,

SELECT report_header_id  

  FROM AP_EXPENSE_REPORT_HEADERS_ALL 

WHERE invoice_num  = <Expense Number>;

SELECT report_line_id 

   FROM AP_EXPENSE_REPORT_LINES_ALL 

WHERE report_header_id = <report_header_id from query 1>

   AND amount IS NULL;

Step 2: Delete the Junk entry from Expense Line and Distribution after taking the backup.

CREATE TABLE AERLA_20190715_BKP AS  SELECT * FROM AP_EXPENSE_REPORT_LINES_ALL WHERE REPORT_LINE_ID = report_line_id ;

DELETE AP_EXPENSE_REPORT_LINES_ALL WHERE REPORT_LINE_ID = report_line_id ;

CREATE TABLE AERDA_20190715_BKP AS SELECT * FROM AP_EXP_REPORT_DISTS_ALL WHERE REPORT_LINE_ID = report_line_id ;

DELETE AP_EXP_REPORT_DISTS_ALL WHERE REPORT_LINE_ID = report_line_id ;

COMMIT;

Step 3: Run the “Expense Report Export” Program from AP Manager Responsibility

After the program completion check the output of the picked expense, it will be in PAID status rather than "Invoice Amount is Null"

Then it will move the Expense report to Payable section by keeping Expense Number reference as Invoice Number.

Oracle Database Link to the External Server from Current Server

To create database link from Server A to Server B (External Server), follow the below approach:

DATABASE LINK CREATION SYNTAX:

CREATE DATABASE LINK <DB_LINK_SERVER_B> CONNECT TO <B_SERVER_USER> IDENTIFIED BY <B_SERVER_USER_PWD> USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<serverB.domain@company.com>)(PORT=<1234>))(CONNECT_DATA=(SID=<SERVER_B_SID>)))';

ex: CREATE DATABASE LINK EXT_SERVER_B CONNECT TO USER_B IDENTIFIED BY USER_B_PWD USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serverB.domain@company.com)(PORT=1234))(CONNECT_DATA=(SID=B_SID)))';

Test the connection from server A:

SQL> SELECT * FROM DUAL@EXT_SERVER_B;

DUMMY
--------
X  => This result is from Server B

Note:  If DB LINK is already available in the database for the external server then drop the existing DB LINK first and then re-create the new entry.

DROP DATABASE LINK <DB_LINK_SERVER_B>;

If you're planning to re-create the DB LINK using the existing TNS server property with different DB LINK name which you've dropped then follow the below steps to achieve that, otherwise you'll end up in ORA-02085: database link string connects to string error.

A. Connect to SQL and check the global_names value

SQL> show parameter global_names

NAME              TYPE     VALUE
----                   ----          -----
global_names  boolean  TRUE

B. Change the global_names parameter property to FALSE to allow the system to set the different DB LINK name for the old TNS server entry with you need to change

SQL> alter system set global_names=FALSE scope=both;

System altered.

SQL> show parameter global_names

NAME              TYPE     VALUE
----                    ----        -----
global_names  boolean  TRUE

C. Drop the database link and re-create the database link.

SQL> DROP DATABASE LINK <DB_LINK_SERVER_B>;

Database link dropped.

SQL> CREATE DATABASE LINK <DB_LINK_SERVER_B1> CONNECT TO <B_SERVER_USER> IDENTIFIED BY <B_SERVER_USER_PWD> USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<serverB.domain@company.com>)(PORT=<1234>))(CONNECT_DATA=(SID=<SERVER_B_SID>)))';

Database link created.

Now check the DB LINK functionality by using the command from the current server A,

SQL> SELECT * FROM DUAL@<DB_LINK_SERVER_B1>;

DUMMY
-----
X

iProcurement : Unable To Lock The Record Cause: The Record Is Being Modified By Another User

Reason for this issue is system saved requisitions are not purged.

A system saved requisition when a user starts creating a requisition and then aborts the process; these records can cause the locking error.

SOLUTION

To implement the solution, execute the request : Purge System Saved Requisition

1. Go into the responsibility: Purchasing

2. Navigate to Reports > Run

3. Search for the Purge System Saved Requisition request

-- Users can schedule the request from this screen to run on an interval.

-- It is suggested to run this on a daily basis to ensure all system saved requisitions are purged.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

Unable To Lock The Record Cause: The Record Is Being Modified By Another User (Doc ID 1636766.1)

AP_INVOICES_UTILITY_PKG Package Body is Invalid Status Due to PLS-00302: component 'AP_CHECK_GDF_VALID' must be declared

This is part of GST Patch implementation work.

GST : Path to GST Implementation - Patch Details (Doc ID 2268465.1)


During the patching cycle the package AP_INVOICES_UTILITY_PKG will get INVALID due to Wrong Number of Argument change in AP_CHECK_GDF_VALID section.

To fix this issue try apply the patch as per Oracle Suggestion

For Release 12.2.x:   

fv    patch/115/sql    FVGTSUTB.pls    120.1.12020000.48
ap    patch/115/sql    apinvutb.pls    120.79.12020000.13

Please Refer Below Doc from Oracle,

R12 AP: AP_INVOICES_UTILITY_PKG Package Body is Invalid Due to PLS-00302: component 'AP_CHECK_GDF_VALID' must be declared (Doc ID 1934300.1)

Hope it Helps !!

Not Able To Do Third Party Registration Setup Of Supplier At Null Site - TDS Setup

When attempting to third party registration for TDS Regime 
the following error occurs.

ERROR
-----------------------
APP-JA-460353:You must create a records for null site first

Solution : 

To implement the solution, please execute the following steps:

1. Go into the responsibility: Oracle Financial for India 

2. Navigate to Party Registration > Define Third Party Registration 

3. To Create a null site level setup of Supplier , Do not pass any value for Operating unit 

4. In Find Third Party Registration Form ,Pass only Party type as "supplier " and Click on New 

5. Not Pass the all details to do the supplier setup at null site level 

6. Migrate the solution as appropriate to other environments.

********************************************************************************************