Please try the below one - This should give package/procedure associated with a WebADI Integrator.
SELECT BA.attribute2, BT.*
If Invoice approval workflow is enabled and AME is configured, please check the respective workflow from Workflow Administrator...
Check the Line Type mentioned on the Invoice Tolerance-PO Line Type.
Also as Rajesh mentioned, If you enter no value then Payables will...
Please check whether Line Level approval causing the issue.
financials_system_parameters is the org_id based view on financials_system_params_all, whether hr_all_organization_units helps you?
:)Ha ha ha..good one..
Can you try financials_system_parameters
In that case, you can update the table with condition that if user input is not null then update with that value else update...
I have not tried AP Invoice Interface in R12 hence not sure of the interface table column for settlement date.
However if you...
Below plsql code can give that result.
r NUMBER:= 1;
FOR i IN 1..5 LOOP...
I analyzed the standard invoice form, and noticed that if earliest_settlement_date is NULL then system defaults...
I think if settlement date is same as invoice date, then system defaults the type as 'Temporary'. Can you please try with...
Have you tried AP_INTERFACE_REJECTIONS or AP_INTERFACE_REJECTIONS_V,
I hope this table should have the error details.
PO Standard Import Program errors will be stored in po_interface_errors
If the number of operating unit is more, then you can use logic as shown below.
Store all the logos in $OA_MEDIA and follow naming...